My Oracle Support Banner

R12:AP: ORA-00913: too many values Error When Running GDF Fix Script (Doc ID 2962718.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

In an environment which was upgraded from 12.1.2 to 12.2.11, GDF patch 21616697-Invoices Locked by Invoice Validation Request That had Completed in Error was applied.

When the fix script ap_inv_val_prb_fix.sql was run

got the error below

Steps or events that lead to the issue occurring

Username provided :'User_name'

Responsibility provided :'Responsibility_name'

initializing apps for access and verfiication of user details

No of rows updated from ap_invoices_all :xx

Inserting the processed invoices in AP_TMP_DATA_DRIVER_9327208_BKP

Error is : ORA-00913: too many values

Changes

 Upgrade from 12.1.3 to 12.2.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.