R12: Past Due Invoice Report Has ORA-00904 Error When User Sets 'Balance Due Low' or 'Balance Due High' Parameters (Doc ID 2020388.1)

Last updated on JULY 08, 2015

Applies to:

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

Symptoms

Past Due Invoice Report has ORA-00904 error.
The error occurs when user sets 'Balance Due Low' or 'Balance Due High' parameters.

Error
========
 ORA-00904: "PS"."DUE_AMOUNT": invalid identifier
  SELECT Currency_Code , Salesrep , Trx_Id , DECODE ( upper ( : p_order_by )
, upper ( : p_balance_due ) , a . due_amount , 0 ) Balance_Due_Customer ,
Cust_Id , Customer_Name , Customer_Number , Invoice_Number , Type ,
Purchase_Order , Invoice_Date ,
 REP-0069: Internal error
 REP-57054: In-process job terminated:Terminated with error:
 REP-300: "PS"."DUE_AMOUNT": invalid identifier
  SELECT Currency_Code , Salesrep , Trx_Id , DECODE ( upper ( : p_order_by )
, upper ( : p_balance_due ) , a . due_amount , 0 ) Balance_Due_Customer ,
Cust_Id , Customer_Name , Customer_Number , Invoice_Number , Type ,
Purchase_Order , Invoice_Date ,

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