Hi Guys,
I'm defining custom Web ADI following suggestions from document (to get the custom error message to be displayed in Web ADI excel sheet):
How to Define an Importer Returning Error Messages to the Oracle Web Applications Desktop Integrator Document (Doc ID 1475566.1)
When I run my Web ADI it fails with following error message:
"An error has occurred while running an API import. 50000:XXDNVGLRAWCOSTRATES_ERRL SQL statement returned no rows when values are expected"
-
Interface table based.
-
There is no content section define for it because I do not need it.
-
Document Row Interface Attribute Mapping is implemented in the following way which defines row in eb ADI excel and intarfec table in unique way in my opinion:
All of above values are required during data upload and must be provided in Excel.
- Error Row Definition is defined in following way
The parameter value is: XXDNVGL_PA_RAW_RATES_STG.RUN_ID
- Error message lookup is implemented in following way
The source for ERROR_CODE parametr is column XXDNVGL_PA_RAW_RATES_STG.ERROR_CODE from intarfec table.
Everything seems to be setup correctly. Am I missing anything? Is something done incorrectly?
Apart from returning custom message to Web ADI file everything is working as expected. When I run above SQls from SQl*Developer they return rows. Data in my interface table are properly updated with errorc_code as expected.
I've also did the test concatenating meaning with the value of bind variable $PARAM$.ERROR_CODE in error message lookup like below:
SELECT
MEANING||$PARAM$.ERROR_CODE
FROM
FND_LOOKUP_VALUES
WHERE
LOOKUP_TYPE = 'XXDNVGL_PA_RATES_UPLOAD_ERROR'
AND LOOKUP_CODE = 'ERR1' -- when ERR1 is one of the codes defined in the lookup.
In this test Web ADI shows the error meaning in the excel sheet as expected instead of error "An error has occurred while running an API import...." .
However the value of binde variable $PARAM$.ERROR_CODE is null and this seems to be a problem why originally SQL of error message lookup does not return any data.
In the bne log i'm finding something like thie:
BneAbstractBaseImporter.runSQLStatementNoValidation%2C+start
4/17/18 11:22 AM Web ADI Upload Job 2674552 TRACE BneAbstractBaseImporter.runSQLStatementNoValidation%2C+tmpSQL%3ASELECT+MEANING+%0D%0AFROM+FND_LOOKUP_VALUES+%0D%0AWHERE+LOOKUP_TYPE+%3D+'XXDNVGL_PA_RATES_UPLOAD_ERROR'+%0D%0AAND+LOOKUP_CODE+%3D+%24PARAM%24.ERROR_CODE
4/17/18 11:22 AM Web ADI Upload Job 2674552 TRACE BneAbstractBaseImporter.runSQLStatementNoValidation%2C+query%3ASELECT+MEANING+%0D%0AFROM+FND_LOOKUP_VALUES+%0D%0AWHERE+LOOKUP_TYPE+%3D+'XXDNVGL_PA_RATES_UPLOAD_ERROR'+%0D%0AAND+LOOKUP_CODE+%3D+%3ARSQLP1
******
No idea what is behind "+%3ARSQLP1" I guess the value is null and this is why SQL fails
Thanks a lot of any help or sugegstions!!