Page 1 of 1
R12 - AP Trail Balance Report R12
Posted: Thu Oct 23, 2008 3:04 am
by 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
Posted: Thu Oct 23, 2008 3:24 am
by venkat.5091
Hi
as per trail balance case, how frequently we reconcile the accounts that that many times we used that perticular report
Posted: Sun Oct 26, 2008 8:49 am
by 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.
Posted: Mon Oct 27, 2008 8:56 am
by 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
Posted: Mon Oct 27, 2008 1:56 pm
by 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
Posted: Wed Oct 29, 2008 1:20 am
by k.khan
This is what I want to ask that in which ways we can use these definations
Regards,
khan
Posted: Wed Oct 29, 2008 7:23 am
by 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
Posted: Mon Nov 03, 2008 4:54 am
by 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?