R12 - GL / XLA - Drilldown from GL is not consistently opening in OA pages

vamsi kasina's picture
articles: 

Sometimes Drilldown from GL will open OA pages and sometimes Oracle Forms.

Here is the reason:

  • When the data is from 11i and not upgraded to R12 (means it is not in XLA tables and gl_je_headers.je_from_sla_flag is NULL), then it will open the subledger form directly.
  • When the data is from R12 or from 11i and upgraded to R12 (means it is in XLA tables and gl_je_headers.je_from_sla_flag is 'Y' or 'U'), then it will open the SLA OA page first, so that we can check the XLA data and we can open the subledger form through View Transactions button.
  • When it is a Manual entry in GL (means it is not in XLA tables and gl_je_headers.je_from_sla_flag is 'N'), the Drilldown button will be disabled.