Reporting - EBS (MOSC)

MOSC Banner

report error messages from custom integratror from Importer PL/SQL back to the rows.

edited Apr 21, 2020 6:37PM in Reporting - EBS (MOSC) 7 commentsAnswered

I need to report error messages from custom integratror from Importer PL/SQL back to the rows. I tried two approaches

1)  Approach One

I tried to use the below statements in the PL/SQL called in the importer and used the return Type as FND Message Code. But this does not return any error message. I did define the message using application developer

fnd_message.set_name('BNE','WEB ADI ERROR');

fnd_message.set_token('MSG',l_msg);

  fnd_message.raise_error;

2) Approach Two

I defined the Error Row Definition to define the error rows and the the error message rule. With this approach the parameters passed from the interface table is not being recognized in the error message lookup rule.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center