RAXINX: Invoice Exception Report Complete in Error ORA-00904: "DIST"."GL_DATE": invalid identifier (Doc ID 2742264.1)

Last updated on MAY 20, 2024

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

RAXINX:Invoice Exception report completed in Error when the report is run with Gl Date parameters.

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation: Requests > Run
Submit
Invoice Exception Report

Enter parameters
GL Date From
GL Date To

Submit the report.

The log file shows the following error

ORA-00904: "DIST"."GL_DATE": invalid identifier
SELECT /*+ INDEX(trx ra_customer_trx_n5) INDEX(dist RA_CUST_TRX_LINE_GL_DIST_N6) */ decode ( type . post_to_gl , 'Y' , : Yes , : No ) C_POSTABLE , money . currency_code C_CURRENCY_CODE , trx . trx_number C_INVOICE_NUMBER , SUBSTR ( arpt_sql_func_ut
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: "DIST"."GL_DATE": invalid identifier
SELECT /*+ INDEX(trx ra_customer_trx_n5) INDEX(dist RA_CUST_TRX_LINE_GL_DIST_N6) */ decode ( type . post_to_gl , 'Y' , : Yes , : No ) C_POSTABLE , money . currency_code C_CURRENCY_CODE , trx . trx_number C_INVOICE_NUMBER , SUBSTR ( arpt_sql_func_ut