APXINWKB ORA-01403 FRM-40735 ORA-01861 Creating AP Invoices For CIS Registered Suppliers on 29-FEB (Doc ID 1434113.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Public Sector Financials (International) - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2013***
Form:APXINWKB.FMB - Invoice Workbench


Symptoms

While creating CIS invoices, when enter the Invoice Date then press tab, the following error occurs.

ERROR
-----------------------
FRM-40735: when-new-item-instance trigger raised unhandled exception ORA-01861
ORA-01403: no data found

The invoices go through even though the error message is displayed
This only happens for CIS enabled suppliers.
When enter invoices for suppliers who are not CIS enabled then the message no longer appears.
The problem only happened on 29-FEB-2012, it no longer occurs.

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