Interface Expense Reports from Payables are failing with errors

ERROR

PRC: Interface Supplier Costs and PRC: Interface Expense Reports from Payables are failing with errors:

03:46:45: log messages from transaction import

03:46:45: transaction import failed with sqlcode =

03:46:45: -20003

03:46:45: ORA-20003: import1_prog:ORA-01426: numeric overflowIn stage 2
Updated count to T = 0

03:46:45: Within main logic of tieback

 Error found in code G_adj_item_id := l_AdjTxnEiIDTab(l_AdjTxnInterfaceIdTab(j) ) ;

SOLUTION

To implement the solution, please execute the following steps:

Step 1. Download and review the readme and pre-requisites for patch:
Patch26100044:R12.PJC.B – 1OFF:26036932:PRC INTER SUPPLIER COSTS ERROR ORA-01426:                                 NUMERIC OVERFLOW AFTER P

Step 2: Ensure that you have taken a backup of your system before applying the recommended patch.

Step 3: Apply the patch in a test environment.

Step 4: Confirm the following file versions:
pa patch/115/sql PAXTTRXB.pls 120.78.12010000.99

Step 5: Retest the issue.

Step 6: Migrate the solution as appropriate to other environments.