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: 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) ) ;
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.
Reference: (Doc ID 2274613.1) PRC: Interface Costs and PRC: Interface Expense Reports from Payables Error ERROR ORA-01426: NUMERIC OVERFLOW