My Oracle Support Banner

Enhancement - Account Analysis Drilldown from Account Journal Line to the GL Enter Journals Form (Doc ID 1608715.1)

Last updated on OCTOBER 10, 2022

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
All Platforms


1) Old Behavior:

In Accounting analysis and drilldown flow, as of now, you are able to drill on credit/debit amounts only for subledger journals.
There is no provision on the page to drill on manual or other sources.

2) New Behavior:

Now, In Accounting analysis and drilldown flow, on journal lines page, you have hyper link on journal names for all kind of journals.

Once you click on journal name link, journal entry form opens up with the complete details of the selected journal.

The hyper link on Dr/Cr amount is still used for drilldown to the SLA page for subledger journals.


NOTE: In the images and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 


To implement the solution, please execute the following steps:

1. This enhancement has now been implemented as part of <Patch 17613377>:R12.GL.B Enable Drill Down For All Journals From Account Analysis And Drilldown Flow
Download and review the readme and pre-requisites for <Patch 17613377>:R12.GL.B.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
$GL_TOP/java/inquiryWkb/webui/  version  120.6.12010000.2
$GL_TOP/mds/inquiryWkb/webui/JeLinesDrilldownPG.xml  version  120.4.12010000.2

You can use commands like the following:
        strings -a $GL_TOP/mds/inquiryWkb/webui/JeLinesDrilldownPG.xml | grep '$Header'
        strings -a $JAVA_TOP/oracle/apps/gl/inquiryWkb/webui/JeLinesDrilldownCO.class | grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.


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
 1) Old Behavior:
 2) New Behavior:

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