My Oracle Support Banner

E1: 09: Frequently Asked Questions regarding General Accounting Online Inquiries (P09200/P09201/P09202/P09210A/P09214/P09215/P09216/P0902P1) (Doc ID 664775.1)

Last updated on MAY 06, 2020

Applies to:

JD Edwards EnterpriseOne General Ledger - Version XE and later
Information in this document applies to any platform.

Purpose

This document provides answers to some frequently asked questions on General Accounting Online Inquiries.

Questions and Answers

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
Questions and Answers
 General Questions for General Accounting Online Inquiries
 Question 1: What are the different online inquires available in EnterpriseOne General Accounting module?
 Question 2: What are the different AAIs used by online inquiries?
 Question 3:   What is Real Time Summarization functionality when using General Accounting inquiries?
 General Questions for Account Ledger Inquiries (P09200/P09201/P09202)
 Question 1: Why do I get an error message "Invalid Combination of Values" while trying to inquire on two different ledger types in P09200, P09201, P09202 applications?
 Question 2: Why do I have certain records missing during export of records in P09200, P09201 or P09202 application?
 Question 3: Sometimes P09201 might show mismatched values for Ledger Type 1 and Ledger Type 2. Why does this happen?
 Account Ledger Inquiry (P09200)
 Question 1: Why is the Column Total for AA ledger different when the Ledger Type 1 and Ledger Type 2 are swapped with CA Ledger Type?
 Question 2: Why do I not see the detailed transactions in P09200 application for AU ledger only?
 Question 3: Why do I not see the information pertaining to unposted cash receipts in P09200 application?
 Question 4: Why is the YTD value in P09200 header not equal to the LT1 column total for AA Ledger?
 Question 5: Why is the Cumulative value in P09200 header not equal to the LT1 Posted Column Total for AA Ledger?
 Question 6: Why are BA ledger (or other budget ledger type) records not returned in the P09200 query?
 Question 7: Why would posted AA ledger F0911 records fail to be shown when the account in question is queried for in P09200?
 Question 8: What is the purpose of the Ledger Type 1 (LT1) and Ledger Type 2 (LT2) fields and how are the populated?
 Account Inquiry by Object Account (P09201)
 Question 1: Why can I not create customized sequenced grid columns in the Account Inquiry by Object Account (P09201)?
 Question 2: Why do I see posted records if "Unposted" option is selected to view unposted records only?
 Question 3: Why can I not search using wildcard '*' in Object/Sub field in P09201 application, after upgrading to 8.98 tools?
 Question 4: Why when inquiring on multiple companies that have CAD currency the currency displayed by AA ledger in the P09201 header is USD?
 Work with Account Ledger by Category Code (P09202)
 Question 1: Why does the P09202 show double the actual amount for Ledger Type "XA" when inquiring in a multi-currency environment?
 Question 2: Can I use P09202 application by Account Category Codes 41 - 43?
 General Questions for Trial Balance Inquiries (P09210A/P09214/P09215/P09216)
 Question 1: Why does the cursor disappear while tabbing from Subledger type to Subledger field?
 Question 2: Why do the T/B applications show incorrect balances for subledger accounts?
 Question 3: Why do budgets entered using the Job Cost Original Budget Entry Program (P510121) not display in the Trial Balance/Ledger Comparison (P09210A)?
 Trial Balance/Ledger Comparison (P09210A)
 Question 1: Why do I not see the Budget Amount Balance (CA) in P09210 application, even though the Final Budget is setup correctly using Budget by Business Unit (P14102)?
 Question 2: Which is the EnterpriseOne equivalent application for Trial Balances by Business Unit (P09210) in World?
 Trial Balance by Object (P09214)
 Question 1: Why do I face performance issues while inquiring on a prior year's balances in the Trial Balance by Object (P09214) application?
 Question 2: Why does the "Exit Ledger Type" processing option of P09214 not function the same way as compared to P09210A?
 Question 3: Why does the system not format the company field and throw error messages, "Fetch from table failed"; "Company 1 Invalid"?
 Question 4: Why do I get inconsistent results when inquiring for multiple companies using P09214 application?
 Trial Balance by Subledger (P09215)
 Question 1: Why does P09215 show incorrect balance amounts?
 Question 2: Why do I get inconsistent results when inquiring on all companies (Company = '*') using P09215 application?
 Question 3: Does the Trial Balance by Subledger program consider Document Company when displaying results?
 Trial Balance by Company (P09216)
 Question 1: Why does P09216 show incorrect balance amounts, when Thru Date is not equal to period end dates?
 Question 2: Why does it take forever while inquiring in P09216 with "Select" checkbox off?
 Question 3: Why does the "General Ledger Period Balance" not include subledger balances also?
 Question 4: Why does P09216 display different results (not displaying non posting/header accounts) in higher releases compared to 8.12 release and prior?
 Question 5: Why does P09216 display different results for a specific object account when comparing with R094121 (Trial Balance by Object Report)?
 Question 6: Why does P09216 not display amounts for F0902 records that have beginning balances in the current year?
 Account Balances (P0902P1)
 Question 1: Why does the cursor disappear while tabbing from Subledger type to Subledger field?
 Question 2: Why does some of the accounts balances are not displayed as zero decimals in the Account Balance By Month (P0902P1) inquiry application for CA ledger, even though the base currency for the object company is setup for zero decimals?
References

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