Oracle Public Sector Permits Cloud Service: Financial Views (XLA Views) Are Not Populated (Doc ID 3006227.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

On : 11.13.23.10.0 version, Analytics and Reporting

Financial Views (XLA Views) are not populated

They are running a query against the XLA views and the results are all blank. This query works in DEV and TEST.

SELECT SL.*
  FROM XLA_SUBLEDGERS_VL SL
  INNER JOIN XLA_SUBLEDGER_OPTIONS_V SLO ON SL.APPLICATION_ID = SLO.APPLICATION_ID
  INNER JOIN XLA_ACCTG_METHODS_VL AM ON SLO.SLA_ACCOUNTING_METHOD_CODE = AM.ACCOUNTING_METHOD_CODE
  INNER JOIN XLA_SLAM_JE_RULE_SETS SLAMJERS ON SLO.APPLICATION_ID = SLAMJERS.APPLICATION_ID
  INNER JOIN XLA_JERS_JLT_LINES JL ON SLAMJERS.JOURNAL_RULE_SET_CODE = JL.JERS_CODE AND JL.SIDE_CODE = 'CREDIT'
  INNER JOIN XLA_JERS_ADR_LINES JAA ON SLAMJERS.JOURNAL_RULE_SET_CODE = JAA.JERS_CODE AND JL.ACCOUNTING_LINE_CODE = JAA.ACCOUNTING_LINE_CODE
  INNER JOIN XLA_SEG_RULES_B AR ON JAA.SEGMENT_RULE_CODE = AR.SEGMENT_RULE_CODE
  INNER JOIN XLA_SEG_RULE_DETAILS ARD ON AR.SEGMENT_RULE_CODE = ARD.SEGMENT_RULE_CODE
  INNER JOIN XLA_MAPPING_SETS_VL MS ON ARD.VALUE_MAPPING_SET_CODE = MS.MAPPING_SET_CODE
  INNER JOIN XLA_MAPPING_SET_INPUTS MSI1 ON MS.MAPPING_SET_CODE = MSI1.MAPPING_SET_CODE AND MSI1.INPUT_SEQ = 1
  INNER JOIN XLA_MAPPING_SET_INPUTS MSI2 ON MS.MAPPING_SET_CODE = MSI2.MAPPING_SET_CODE AND MSI2.INPUT_SEQ = 2
 

Cause

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