Error 'ORA-00904: T963640.INV_IN_TRAN_RTL_AMT_LCL: invalid identifier at OCI call OCIStmtExecute'While Creating Analysis in RMA As-Is and Running Report (Doc ID 2110073.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Retail Merchandising Insights - Version 13.3 to 13.3.8 [Release 13.3]
Information in this document applies to any platform.

Symptoms

In ORA 13.3.8

INV_IN_TRAN_RTL_AMT_LC column in W_RTL_INV_IT_LC_DY_FV view is causing the below errors on the OBIEE side:


OBIEE expects the field INV_IN_TRAN_RTL_AMT_LC to be actually INV_IN_TRAN_RTL_AMT_LCL, and as per the ongoing standards the fields are named _LCL for the LCL values.  Please fix W_RTL_INV_IT_LC_DY_FV view script. The INV_IN_TRAN_RTL_AMT_LC column in W_RTL_INV_IT_LC_DY_FV view causes below error in OBIEE side:
While creating analysis in RMA As-IS and running a report on the OBIEE side, exception "ORA-00904: T963640.INV_IN_TRAN_RTL_AMT_LCL: invalid identifier at  OCI call OCIStmtExecute" is raised.

Steps to Recreate:

  1. Log in to OBIEE and create analysis in RMA As-IS
  2. Choose the following columns:  Item As-Was.Item Number, Organization
    As-Was.Loc Number, Business Calendar.Fiscal Date, Inventory Postion. EOH Qty,
    On Order Qty, In Transit Qty, EOH Retail, On Order Retail, In Transit Retail,
    EOH Cost, In Transit Cost, On Order Cost amd run the report
  3. Notice the error: ORA-00904: "T963640"."INV_IN_TRAN_RTL_AMT_LCL": invalid identifier at  OCI call OCIStmtExecute

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