Projects - EBS (MOSC)

MOSC Banner

Validating Imported Transactions using the Pre-Processing Extension

edited Jul 20, 2010 4:38AM in Projects - EBS (MOSC) 3 commentsAnswered
I have created a custom Transaction Source and custom PL/SQL package procedure which I specify as the "pre-processing extension" for this source in the Transaction Source setup form.  When I import transactions of this source, my custom PL/SQL package validates these transactions (it performs validations which the standard import program would not perform).  If any transaction fails this "pre-processing" validation, I update all of the transactions in the batch being imported with the status "PO" (in the column TRANSACTION_STATUS_CODE, per the instructions in the Projects User Guide).  I then want the import program to leave these transactions in the PA_TRANSACTION_INTERFACE_ALL table without importing

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