R12: AP/IBY: GDF Scritps Not Executing As Expected; Error ORA-04088 While Executing FIX script.
(Doc ID 3036377.1)
Last updated on JULY 23, 2024
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Generic Data Fix (GDF) fix script not performing as expected.
GDF script log file shows errors ORA-4088 while executing a trigger fired when updating the GDF affected base table.
For example: Executing script ap_Rel_Inv_frm_TermPPR_fix.sql of Doc ID 874862.1, the following error occurs while DELETE records from AP_SELECTED_INVOICES_ALL as part of the script.
ERROR at line 1:
ORA-12899: value too large for column
"APPS"."AP_SELECTED_INVOICES_BACKUP"."ZIP" (actual: 25, maximum: 20)
ORA-06512: at "APPS.AP_SEL_INV_TRIGGER", line 2
ORA-04088: error during execution of trigger 'APPS.AP_SEL_INV_TRIGGER'
ORA-12899: value too large for column
"APPS"."AP_SELECTED_INVOICES_BACKUP"."ZIP" (actual: 25, maximum: 20)
ORA-06512: at "APPS.AP_SEL_INV_TRIGGER", line 2
ORA-04088: error during execution of trigger 'APPS.AP_SEL_INV_TRIGGER'
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |