My Oracle Support Banner

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

Last updated on MARCH 24, 2022

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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