My Oracle Support Banner

ARGTIMP Golden Tax Invoice Import Program fails with Error 原因:由于 ORA-01422: 实际返回的行数超出请求的行数 ORA-06512: 在 "APPS.AR_GTA_CONC_PROG" (Doc ID 2831268.1)

Last updated on DECEMBER 31, 2021

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Oracle Outsourced Mfg for Discrete Industries - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Golden Tax Invoice Import request complete with error message:

ERROR
-----------------------
[02-12-2021 02:14:57]: **Starts**
[02-12-2021 02:14:57]: **SQL error and free**
[02-12-2021 02:14:57]: FDPSTP 中存在 ORACLE 错误 1422
原因:由于 ORA-01422: 实际返回的行数超出请求的行数
ORA-06512: 在 "APPS.AR_GTA_CONC_PROG", line 764
ORA-06512: 在 line 1
 导致 FDPSTP 失败。


It happens for a single Invoice only.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Golden Tax Invoice Import for an AR Invoice.
2. Request will fail with an Error
3. Review the log file for error.

FND debug of the Request shows following relevant lines:

ar.plsql.AR_GTA_CONC_PROCImport_GT_invoices.begin Procedure begin
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..Import_invoices.begin Enter procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..read_GT_Line.begin Enter procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..read_GT_Line.End Exit procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..read_GT_Line.begin Enter procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..read_GT_Line.End Exit procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..read_GT_Line.begin Enter procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC..read_GT_Line.End Exit procedure
ar.plsql.AR_GTA_TXT_OPERATOR_PROC.Import_invoices.OTHER_EXCEPTION -1422ORA-01422: 实际返回的行数超出请求的行数
ar.plsql.AR_GTA_CONC_PROCImport_GT_invoices.OTHER_EXCEPTION -1422ORA-01422: 实际返回的行数超出请求的行数

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


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