Hi,
Can any body tell me how effective can we use Trail Balance Report as very less in written over it in user guide
Regards,
Khan
R12 - AP Trail Balance Report R12
-
- Posts: 3
- Joined: Mon Sep 29, 2008 2:46 am
- Location: India
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
It is written very less in user guide because it does not exist in Release 12.
The name used in R12 is OPEN ACCOUNT BALANCES LISTING.
By default the AP trial balance report will be disabled, you cannot see it in payables.
In R12, you can run this Open Account Balances listing for more than one liability account, the output is xml, it will generate a pdf output. You also need to define Report definition before start using this report in R12.
The name used in R12 is OPEN ACCOUNT BALANCES LISTING.
By default the AP trial balance report will be disabled, you cannot see it in payables.
In R12, you can run this Open Account Balances listing for more than one liability account, the output is xml, it will generate a pdf output. You also need to define Report definition before start using this report in R12.
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
-
- Posts: 64
- Joined: Thu Jul 19, 2007 1:02 am
- Location: India
Hi,
I have done the report definitions for Payables module and ran the request. But it's completed error with the below error message.
please let us know hw we can get the output.
XDO Data Engine Version No: 5.6.3
Request ID: 1304290
All Parameters: P_DEFINITION_CODE=ACEPL:P_JOURNAL_SOURCE=Payables:P_START_DATE="2008/04/01 00:00:00":P_AS_OF_DATE="2008/10/10 00:00:00":P_THIRD_PARTY_ID=22009#$S:P_SHOW_TRX_DETAIL_FLAG=Y:P_INCL_WRITE_OFF_FLAG=N:P_COA_ID=50414:P_ACCOUNT_FROM=01.000.000.1020.0000.00.0000:P_ACCOUNT_TO=01.zzz.zzz.1020.zzzz.zz.zzzz:P_ACCT_BALANCE=YEAR_TO_DATE:P_SECURITY_FLAG=Y:P_VALUATION_METHOD=:P_SECURITY_ID_INT_1=:P_SECURITY_ID_CHAR_1=:P_CUSTOM_PARAM_1=:P_CUSTOM_PARAM_2=:P_CUSTOM_PARAM_3=
Data Template Code: XLATBRPT
Data Template Application Short Name: SQLAP
Debug Flag: N
{P_INCL_WRITE_OFF_FLAG=N, P_COA_ID=50414, P_AS_OF_DATE=2008/10/10 00:00:00, P_DEFINITION_CODE=ACEPL, P_ACCT_BALANCE=YEAR_TO_DATE, P_VALUATION_METHOD=, P_THIRD_PARTY_ID=22009#$S, P_SECURITY_ID_INT_1=, P_SECURITY_FLAG=Y, P_ACCOUNT_FROM=01.000.000.1020.0000.00.0000, P_START_DATE=2008/04/01 00:00:00, P_SHOW_TRX_DETAIL_FLAG=Y, P_CUSTOM_PARAM_3=, P_JOURNAL_SOURCE=Payables, P_CUSTOM_PARAM_2=, P_CUSTOM_PARAM_1=, P_SECURITY_ID_CHAR_1=, P_ACCOUNT_TO=01.zzz.zzz.1020.zzzz.zz.zzzz}
Calling XDO Data Engine...
java.lang.NullPointerException
at oracle.apps.xdo.oa.util.DataTemplate.getDataTemplate(DataTemplate.java:281)
at oracle.apps.xdo.oa.util.DataTemplate.<init>(DataTemplate.java:133)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:282)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157
I have done the report definitions for Payables module and ran the request. But it's completed error with the below error message.
please let us know hw we can get the output.
XDO Data Engine Version No: 5.6.3
Request ID: 1304290
All Parameters: P_DEFINITION_CODE=ACEPL:P_JOURNAL_SOURCE=Payables:P_START_DATE="2008/04/01 00:00:00":P_AS_OF_DATE="2008/10/10 00:00:00":P_THIRD_PARTY_ID=22009#$S:P_SHOW_TRX_DETAIL_FLAG=Y:P_INCL_WRITE_OFF_FLAG=N:P_COA_ID=50414:P_ACCOUNT_FROM=01.000.000.1020.0000.00.0000:P_ACCOUNT_TO=01.zzz.zzz.1020.zzzz.zz.zzzz:P_ACCT_BALANCE=YEAR_TO_DATE:P_SECURITY_FLAG=Y:P_VALUATION_METHOD=:P_SECURITY_ID_INT_1=:P_SECURITY_ID_CHAR_1=:P_CUSTOM_PARAM_1=:P_CUSTOM_PARAM_2=:P_CUSTOM_PARAM_3=
Data Template Code: XLATBRPT
Data Template Application Short Name: SQLAP
Debug Flag: N
{P_INCL_WRITE_OFF_FLAG=N, P_COA_ID=50414, P_AS_OF_DATE=2008/10/10 00:00:00, P_DEFINITION_CODE=ACEPL, P_ACCT_BALANCE=YEAR_TO_DATE, P_VALUATION_METHOD=, P_THIRD_PARTY_ID=22009#$S, P_SECURITY_ID_INT_1=, P_SECURITY_FLAG=Y, P_ACCOUNT_FROM=01.000.000.1020.0000.00.0000, P_START_DATE=2008/04/01 00:00:00, P_SHOW_TRX_DETAIL_FLAG=Y, P_CUSTOM_PARAM_3=, P_JOURNAL_SOURCE=Payables, P_CUSTOM_PARAM_2=, P_CUSTOM_PARAM_1=, P_SECURITY_ID_CHAR_1=, P_ACCOUNT_TO=01.zzz.zzz.1020.zzzz.zz.zzzz}
Calling XDO Data Engine...
java.lang.NullPointerException
at oracle.apps.xdo.oa.util.DataTemplate.getDataTemplate(DataTemplate.java:281)
at oracle.apps.xdo.oa.util.DataTemplate.<init>(DataTemplate.java:133)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:282)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157
Who is online
Users browsing this forum: No registered users and 0 guests