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

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.

Symptoms

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
Expect upgraded data to be visible for drill down in GL.

STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot view details of upgraded data.

Changes

 Upgrade from 11i to R12.x which introduced Subledger Accounting.  Upgraded some historical data. Also have non-upgraded historical data.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms