Accounts Payable Trial Balance Report

Oracle Payables
How To
Table of Contents
How to Set Whether Payables Transfer To General Ledger Is In Detail Or Summary
3
How to Debug Account Payables Accounting Process - APACCENG
4
How do you correct invalid accounts reported by the "Create Accounting Process" in R12
Payables?
5
Accounting Entries Are Created Even Though Invoice Did Not Pass Validation
6
How do you make the R12 Accounts Payable Trial Balance Report show Detail or Summary
output?
7
Question
How
to
Set Whether Payables Transfer to
General Ledger Is In Detail Or Summary
Metalink Doc ID
Note:140545.1
Version
11.5
Answer
In the payables responsibility:
Setup -> Options -> Payables -> Transfer to GL Tab
You can transfer to GL
In Detail
Summarize by Accounting Date
Summarize by Accounting Period
Question
How to Debug Account Payables Accounting Process - APACCENG
Metalink Doc ID
Note:190146.1
Version
Answer
If you need a debug log file for a detailed analysis of an accounting problem the following
steps are required:
1. Responsibility: System Administrator
-> Concurrent - Program - Define
-> Query for the Payables Accounting Process
-> Click on the Parameters button
-> Click in the line with the parameter Debug
-> Check the flag Display
-> Save


2. Responsibility: Payables Manager
-> Other - Requests - Run
-> Choose the Payables Accounting Process
-> In the Parameters form you now have an additional parameter: Debug
-> Choose Yes for the Parameter Debug and submit the report
3. Where to find the DEBUG information
When you run the Payables Accounting proces with this parameter set to Y, the
debug information is displayed in the the normal log file for the concurrent
process. If you open up the log file, you will be able to see all of the
details about the accounting process and each transaction. This log file is
stored in the same operating system directory where all log files are stored.
4. After creating a debug log file revert the changes.
Question
How do you correct invalid
accounts reported by the "Create
Accounting
Process"
in R12
Payables?
Metalink Doc ID
Note:459274.1
Version
12.0
Answer
The Update Accounting Entries form was available in earlier releases of R11i to allow
update/correction of invalid accounts created by the Payables accounting process. The
R11i Update Accounting Entries form is phased out in 11.5.10 and is not available in R12.
In R11i version 11.5.10, accounting is not created with invalid
accounts;
instead the
accounting is reported in error and rolled back. The users are required to fix the invalid
account referenced in the transaction data at the transaction level. R12 has similar
functionality, if an account is invalid, the accounting is created with a status = Invalid. When
accounting is created with a status = Invalid due to invalid accounts, the user should correct
the transaction data or rule referencing the invalid account and then run the Create
Accounting process again. Accounting with status = Invalid and Draft can be recreated
each time the Create Accounting process is ran. You can modify transaction data and rules
to correct and change the accounting until you see accounting status = Final.


Question
Accounting Entries Are Created Even Though Invoice Did
Not
Pass
Validation
Metalink Doc ID
Note:457779.1
Version
11.5.9
Answer
If an invoice goes on hold the status will be "Needs Revalidation".
But, to determine if the
accounting_event_id is to be created, which will then allow the accounting to be created,
is
based on the postable_flag that is set for the Hold.
If this field is set to Y then the
accounting_event_id will be created.
So even if the invoice is on hold, this flag tells the
system that you still want to create the accounting.
If you want an invoice to go on hold and
NOT allow posting, then this flag has to be set to N.

Question
How do you make the R12 Accounts Payable Trial Balance Report show
Detail or Summary output?
Metalink Doc ID
Note:444044.1
Version
Version: 12.0
Answer
The R12 Accounts Payable Trial Balance has 4 templates available that
control the output that is displayed. The four templates available are:
Accounts Payable Trial Balance - Group by Account, Summary
Accounts Payable Trial Balance - Group by Account, Detail
Accounts Payable Trial Balance - Group by Third Party, Summary
Accounts Payable Trial Balance - Group by Third Party, Detail
Do the following to change the template that is used when the report is
submitted:
1. Navigate: Payables Responsibility>Other>Request>Run
2. Select the Accounts Payable Trial Balance
3. Enter all of the parameters for the report. DO NOT SUBMIT THE REPORT.
4. Click on the Options button in the Upon Completion section of the Submit
Request screen.
5. Select the desired template name.
6. Submit the Trial balance.
Do the following to change the default template used when the report is
submitted:
1. Navigate: System Administration Responsibility>Concurrent>Programs
2. Search for:
Application = Payables
Program = Accounts Payable Trial Balance
Click on Go


3. Click on Update for the Accounts Payable Trial Balance program
4. Select the Onsite Setting tab
5. Select the default template from the Template dropdown in the General
section.
6. Click on Apply to save the changes.