R12 AP: Payables Invoice Workbench Gives Error: App-SQLAP-10000: ORA-14400: Inserted Partition Key Does Not Map To Any Partition (Doc ID 2272909.1)

Last updated on JUNE 01, 2017

Applies to:

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

Symptoms

Payables 12.1.3 version, Invoices => Entry => Invoices

Create an invoice.

Try to create Lines and get the error window:
 

ERROR
-----------------------
App-SQLAP-10000: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "APPS.AP_INVOICE_LINES_ALL_AIP", line 16
ORA-06512: at "APPS.AP_INVOICE_LINES_ALL_AI", line 1
ORA-04088: error during execution of trigger 'APPS.AP_INVOICE_LINES_ALL_AI' occured in AP_AIL_TABLE_HANDLER_PKG.Insert_Row<-APXINLINE.Line_Sum_Folder_Block_DML2.Insert_Row

with parameters (&PARAMETERS)

while performing the following operation:

Insert into ap_invoice_lines_all

         (OK button)

 
Also, when importing invoices, no lines are created.

Changes

 None.  Everything worked fine the day before.

EX.  Exactly after midnight, 31-May-2017, no more invoices can be entered or updated.

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