My Oracle Support Banner

ORA-00900 When Applying Receipt To Invoice (Doc ID 2530152.1)

Last updated on JULY 13, 2020

Applies to:

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

Symptoms

When applying Receipt to Invoice error is raised:

ERROR
-----------------------
ORA-00900: invalid SQL statement
ORA-06512: at "APPS.ARP_PROCESS_APPLICATION", line 4488

FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-00900.


FND debug shows:
ar.plsql.ARP_APP_CALC_PKG.calc_applied_and_remaining EXCEPTION: ARP_APP_CALC_PKG.calc_applied_and_remaining()ORA-00900: invalid SQL statement
ar.plsql.ARP_APP_CALC_PKG.calc_applied_and_remaining EXCEPTION: ARP_APP_CALC_PKG.calc_applied_and_remaining: Wrapper: ORA-00900: invalid SQL statement
ar.plsql.ARP_APP_CALC_PKG.calc_applied_and_remaining EXCEPTION: arp_ps_util.update_invoice_related_columns
ar.plsql.ARP_APP_CALC_PKG.calc_applied_and_remaining EXCEPTION: arp_process_application.receipt_application

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
References


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