Reporting - EBS (MOSC)

MOSC Banner

How to get bne:import value in PLSQL code

edited Sep 12, 2015 10:00AM in Reporting - EBS (MOSC) 1 commentAnswered

Hi All,

  I have custom integrator interface based on PL/SQL procedure TYPE.

Part of the PL/SQL package i validate the data and insert it into staging table if validation is successfully.

Problem i have is  when i select Upload Parameter "Validate Before Upload" it validates the data and insert into staging table

once validation is successfully, i select "Automatically Submit Import" option and submit it.  This process  again validate it and insert another set of records into the staging table which is creating duplicate in staging table

How can i prevent this

Thanks,

Jay

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