How to access Customer Import (RACUST) Errors
Hello,
I am writing a Customer Conversion program for a client and the Apps Release is 12.1.1. I have written a custom PL/SQL package which is registered as a Concurrent Program. This program reads data from the staging tables, validates them and loads the successfully validated data into the Customer Interface tables. It then launches the Customer Import Program (RACUST) using FND_REQUEST.SUBMIT_REQUEST.
My requirement is to capture the errors returned by RACUST for records that have failed. Since I am using FND_REQUEST.SUBMIT_REQUEST to launch RACUST, I do not see the program in SRS and hence cannot look at the Output file which is generated with the errors. The interface has concatenated error codes for each record that has failed, but how do you get the corresponding error message associated to each error code?
I am writing a Customer Conversion program for a client and the Apps Release is 12.1.1. I have written a custom PL/SQL package which is registered as a Concurrent Program. This program reads data from the staging tables, validates them and loads the successfully validated data into the Customer Interface tables. It then launches the Customer Import Program (RACUST) using FND_REQUEST.SUBMIT_REQUEST.
My requirement is to capture the errors returned by RACUST for records that have failed. Since I am using FND_REQUEST.SUBMIT_REQUEST to launch RACUST, I do not see the program in SRS and hence cannot look at the Output file which is generated with the errors. The interface has concatenated error codes for each record that has failed, but how do you get the corresponding error message associated to each error code?
0