My Oracle Support Banner

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 DECEMBER 08, 2020

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

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
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.