My Oracle Support Banner

Portugal Localization : Error There is an error in the transfer to temporary table. => BEGIN FOR R IN (SELECT * FROM CLE_AP_SUPPLIERS_EXT (Doc ID 2564990.1)

Last updated on AUGUST 14, 2019

Applies to:

EMEA Add-on Localizations - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Reported Issue
----------------
Error observed in supplier page on clicking apply on CLE: Additional Info on suppliers . 

ERROR
-----------------------
There is an error in the transfer to temporary table. => BEGIN FOR R IN (SELECT * FROM CLE_AP_SUPPLIERS_EXT WHERE DFF_ID1={@VendorId}) LOOP UPDATE CLE_F220_EXT_FLEX_EDITION_GT CEFE SET CEFE.ATTRIBUTE2 = R.ATTRIBUTE2, CEFE.ATTRIBUTE1 = R.ATTRIBUTE1, CEFE.ATTRIBUTE_CATEGORY = R.ATTRIBUTE_CATEGORY WHERE CEFE.EXT_FLEX_EDITION_ID = 2437; END LOOP; END; +=+=+=+User-Defined Exception

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Define Supplier and supplier site information.
2. Click on CLE: Additional Info on Suppliers.
3. Notice the error message.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the supplier setups required for SAFT Reporting.

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.