I have a requirement where I need to validate the records after user uploads to Oracle from Excel(ADI) and if all records are pass the validation I need to post them to Misc Inv Trx. If any one of the row fails I need to throw error in Excel. Can you please help me how can I achieve this through custom integrator?
I can only write the validations in PLSQL as they depends on items, Qty which involves complex coding.
not sure if this can suit your needs.
Web ADI has an option to call a concurrent request after import intointerface tables, and return the output to desktop.
the information is stored I beleive into the IMPORT_TYPE column of the BNE_INTEGRATORS_B table.
Actually we need to show the error while uploading it self and user can't wait more than 2 mins that is the requirement. I tried PLSQL importer with Procedure, Function but ended up with JDO errors and ADI has not allowed to go further. I am working on R12.1.3 version of eBS.
If you have any other thoughts can you please suggest?