R12 - AP Trail Balance Report R12

[k.khan]

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

[venkat.5091]

Hi
as per trail balance case, how frequently we reconcile the accounts that that many times we used that perticular report

[karthikeyanp1981]

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.

[k.khan]

Hi,

As these parmeters are to be customised as per the requiremnet so any plz give me some examples for this.

Regards,
khan

[karthikeyanp1981]

No need to customize any thing, apart from Report Definition.
Report definition controls the content of the report, therefore only this needs to be defined as per the business requirement.
All other parameter can have their defaults

[k.khan]

This is what I want to ask that in which ways we can use these definations

Regards,
khan

[chaitu_apps]

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

[k.khan]

Hi,

that another thing it is completing in error....
important thing is that it is important tool for reconciliations and we need to know how good we can utilise it THATS THE QUESTION?