My Oracle Support Banner

R!2 AP: FRM-40735 Post-Query Trigger Raised Unhandled Exception ORA-01403 When Query or Create Invoice For Specific Supplier (Doc ID 2478412.1)

Last updated on SEPTEMBER 16, 2024

Applies to:

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

Symptoms

When attempting to query or create an Invoice for a particular Supplier, the following error occurs:

FRM-40735:  Post-Query trigger raised unhandled exception ORA-01403.

 

Steps to reproduce:

  1. Log into Oracle Applications using a Payables responsibility.
  2. Open the Invoice workbench
    (N) Invoices > Inquiry > Invoices
  3. Query an Invoice for the problem Supplier.
  4. The Error raises.

 

A FND Debug Log of the issue reproduced, shows the following information:

iby.plsql.IBY_DISBURSEMENT_COMP_PUB IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : ERROR: Exception occured during call to API
iby.plsql.IBY_DISBURSEMENT_COMP_PUB IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : SQLerr is :ORA-01841: (full) year must be between -4713 and +9999, and not be 0
end_date for this supplier is dd/mm/yyyy.

 

 

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
References


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