R12: ZX: ORA-20003: ORA-00913: Too Many Values When Running Zx_funcl_backup.sql 13365761:R12.ZX.B (Doc ID 2173892.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Oracle Payables, when a user attempts to run the selection script zx_funcl_backup.sql the following error occurs:

ERROR

Enter value for invoice_id: &YOUR_ INVOICE_ID
Enter value for from_date: &YOUR DATE
DECLARE
*
ERROR at line 1:
ORA-20003: ORA-00913: too many values ERROR OCCURRED
ORA-06512: at line 131


Steps or events that lead to the issue occurring

Enter value for invoice_id: &YOUR_ INVOICE_ID
Enter value for from_date: &YOUR DATE
DECLARE
*
ERROR at line 1:
ORA-20003: ORA-00913: too many values ERROR OCCURRED
ORA-06512: at line 131

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