Error: "There is an error in the transfer to temporary table" When Trying To Access "CLE: Additional Info on Tax Rate" Localization Descriptive Flexfields
(Doc ID 3030978.1)
Last updated on JUNE 28, 2024
Applies to:
EMEA Add-on Localizations - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to access "CLE: Additional Info on Tax Rate" LDFF (localization descriptive flexfields),
the following error is displayed in form:
There is an error in the transfer to temporary table. => BEGIN FOR R IN (SELECT * FROM CLE_ZX_RATES_B_EXT WHERE
DFF_ID1=) LOOP UPDATE CLE_F220_EXT_FLEX_EDITION_GT CEFE SET CEFE.ATTRIBUTE15 = R.ATTRIBUTE15,
CEFE.ATTRIBUTE7 = R.ATTRIBUTE7, CEFE.ATTRIBUTE9 = R.ATTRIBUTE9, CEFE.ATTRIBUTE8 = R.ATTRIBUTE8,
CEFE.ATTRIBUTE1 = R.ATTRIBUTE1, CEFE.ATTRIBUTE6 = R.ATTRIBUTE6, CEFE.ATTRIBUTE11 = R.ATTRIBUTE11,
CEFE.ATTRIBUTE12 = R.ATTRIBUTE12, CEFE.ATTRIBUTE13 = R.ATTRIBUTE13, CEFE.ATTRIBUTE16 = R.ATTRIBUTE16,
CEFE.ATTRIBUTE17 = R.ATTRIBUTE17, CEFE.ATTRIBUTE3 = R.ATTRIBUTE3, CEFE.ATTRIBUTE10 = R.ATTRIBUTE10,
CEFE.ATTRIBUTE2 = R.ATTRIBUTE2, CEFE.ATTRIBUTE4 = R.ATTRIBUTE4, CEFE.ATTRIBUTE5 = R.ATTRIBUTE5,
CEFE.ATTRIBUTE_CATEGORY = R.ATTRIBUTE_CATEGORY WHERE CEFE.EXT_FLEX_EDITION_ID = 2340; END LOOP;
END; +=+=+=+User-Defined Exception
DFF_ID1=) LOOP UPDATE CLE_F220_EXT_FLEX_EDITION_GT CEFE SET CEFE.ATTRIBUTE15 = R.ATTRIBUTE15,
CEFE.ATTRIBUTE7 = R.ATTRIBUTE7, CEFE.ATTRIBUTE9 = R.ATTRIBUTE9, CEFE.ATTRIBUTE8 = R.ATTRIBUTE8,
CEFE.ATTRIBUTE1 = R.ATTRIBUTE1, CEFE.ATTRIBUTE6 = R.ATTRIBUTE6, CEFE.ATTRIBUTE11 = R.ATTRIBUTE11,
CEFE.ATTRIBUTE12 = R.ATTRIBUTE12, CEFE.ATTRIBUTE13 = R.ATTRIBUTE13, CEFE.ATTRIBUTE16 = R.ATTRIBUTE16,
CEFE.ATTRIBUTE17 = R.ATTRIBUTE17, CEFE.ATTRIBUTE3 = R.ATTRIBUTE3, CEFE.ATTRIBUTE10 = R.ATTRIBUTE10,
CEFE.ATTRIBUTE2 = R.ATTRIBUTE2, CEFE.ATTRIBUTE4 = R.ATTRIBUTE4, CEFE.ATTRIBUTE5 = R.ATTRIBUTE5,
CEFE.ATTRIBUTE_CATEGORY = R.ATTRIBUTE_CATEGORY WHERE CEFE.EXT_FLEX_EDITION_ID = 2340; END LOOP;
END; +=+=+=+User-Defined Exception
The issue can be reproduced at will with the following steps:
1. Navigate to Tax Manager responsibility.
2. Go to Tax Configuration > Tax Rates.
3. Query a tax and try to open "CLE: Additional Info on Tax Rate" LDFF.
4. Notice the error displayed in form.
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 |