My Oracle Support Banner

R12.x - In Gl Cannot Drilldown To Transaction For 11i Migrated Po Data. (Doc ID 1669518.1)

Last updated on MARCH 02, 2023

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.


After customer applies latest releases of eBusiness , Upgraded from 11.5.x to R12.2.3 . - The 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.


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

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