My Oracle Support Banner

ARGTART: Receivables Transfer to Golden Tax Adaptor Fails with Error ORA-01422 (Doc ID 2525601.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Outsourced Mfg for Discrete Industries - Version 12.2 and later
Oracle Receivables - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Oracle Applications Tax Module

Standard program Receivables Transfer to Golden Tax ended with error.
Log shows below error message
Cause: FDPSTP failed due to ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.AR_GTA_CONC_PROG", line 241
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Run Receivables Transfer to Golden Tax


FND debug shows

ebtax l_proce_error_buffer:AR_GTA_MULTI_TAXLINE
exception registration numberAR_GTA_MULTI_TAXLINE
Transaction line '1' has multiple tax lines with 'VAT' tax Type. There should be only one tax line with 'VAT' tax type.


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

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