R12.x - In Gl Cannot Drilldown To Transaction For 11i Migrated Po Data.
Last updated on JUNE 13, 2014
Applies to:Oracle Purchasing - Version 12.0.6 to 12.2.3 [Release 12 to 12.2]
Oracle U.S. Federal Financials - Version 12.0.6 to 12.2.3 [Release 12.0 to 12.2]
Information in this document applies to any platform.
This customer applies latest releases of eBusiness as soon as available.
Upgraded from 11.5.x to R12.2.3 . - This issue has been observed on R12.0.6 , R12.1.3 and now R12.2.3
R12 introduced Subledger Accounting (SLA). The new SLA tables include XLA_AE_HEADERS, and XLA_AE_LINES.
When upgrading from 11i to R12.x, one has the option to upgrade 11i historical journal data base on date.
Current iteration of test upgraded 12 months of data (2013) to XLA table format and not older data ( from 2012).
Found in General Ledger (GL) forms, cannot drill down on journal to transaction level using upgraded (R12) data.
Application takes user to new html form. See header information and no detail information.
For Non-upgraded data (from 2012 and before), user can drill down on GL journals to transaction level using old (11i) form and see header and detail information.
For transactions created in R12 , user can drill down on GL journal to transaction as desired and see header and detail information.
Expect upgraded data to be visible for drill down in GL.
The issue can be reproduced at will with the following steps:
1. Upgrade from 11.5.x to R12.2.3
2. Migrate historical transactions
3. Navigate General Ledger: Inquiry General; query a batch
Show journal, select one
Press button: Review Journal
Expect to see header and detail information
Due to this issue, users cannot view details of upgraded data.
Upgrade from 11i to R12.x which introduced Subledger Accounting. Upgraded some historical data. Also have non-upgraded historical data.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms