My Oracle Support Banner

WS: 09: Troubleshooting Standard Accounting Inquiries (P09200, P09210, P09216) (Doc ID 1588418.1)

Last updated on MAY 06, 2024

Applies to:

JD Edwards World General Ledger - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Purpose

 Documents frequent errors and issues encountered when using standard accounting inquiries.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Account Ledger Inquiry (P09200)
 Issue 1: Account Ledger Inquiry not displaying dates correctly: the beginning year date when it should populate the current accounting period.
 Issue 2: An account on the Account Ledger Inquiry displays a business unit from the wrong company when you access the Account Ledger inquiry from the Trial Balance by Object (P09214).       
 Issue 3:  The F0911 and F0902 files are out of balance as viewed on the Account Balance by Month (P09213) and Account Ledger Inquiry (P09200) by month.
 Issue 4: The Print Ledger function (F21) In Account Ledger Inquiry is not working after IBM Upgrade to V6R1.
 Issue 5:  Error message P09200 506900 V09200 attempts to write duplicate record (C G S D F) when paging down through a large number of records.
 Issue 6:  Error message P09200 526000 V09200 attempts to write duplicate record (C G S D F) when attempting "Export to CSV File" option (F23).
 Issue 7:  Y-T-D Period End and/or Cumul Period End fields show blank values even though there are transactions posted to the year or period(s) in question.
 Account Balance Comparison (P092121)
 Issue 1: The On-Line Budget Comparison screen does not display the budget amount entered for the first day of the period.
 Trial Balance by Business Unit , by Object, by Company (P09210, P09214, P09216)
 Issue 1: An account does not display for the Trial Balance by Business Unit program (P09210), but does display for the Trial Balance by Object (P09214) and Trial Balance by Company (P09216) programs.        
 Issue 2: Object accounts display on the Trial Balance By Object (P09214) without a business unit.
 Issue 3: The Trial Balance by Object (P09214) does not net to zero for the current year.
 Issue 4: The Trial Balance by Object (P09214) retrieves objects that are ahead of the requested account in the chart of accounts.
 Issue 5: On a new environment, with balances set up for the current fiscal year, the system returns an I/O Limit Exceeded message on inquiry of a single account in the Trial Balance by Object (P09214) program.
 Issue 6: The T/B by Business Unit (P09210) display a different balance than the Trial Balance by Object Account (P09214) when you specify a date that is not a period ending date in the Thru Date/Period field.
 Issue 7: T/B by Business Unit (P09210) Displays and Adds Accounts Twice On A9.3
 Issue 8: Monetary Account Balance Displays without Decimals for CA Ledger in Trial Balance by Business Unit (P09210)
 Issue 9: Trying to inquire on a business unit + one character of the object (such as 100.1) via T/B by Business Unit, and the system returns error: The P09210 xxxxxx array index is not valid (C G S D F).
 Issue 10: Error "0168 - Fiscal Year Not Set Up" returned when trying to inquire on account information for a fiscal year that is correctly set up in the relevant Fiscal Date Pattern.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.