This discussion is archived
1 Reply Latest reply: Sep 10, 2013 5:40 AM by Srini Chavali-Oracle Branched from an earlier discussion. RSS

Web ADI - How to return concurrent request number to excel sheet msg column

SanketZ Newbie
Currently Being Moderated

Hi Uday,

 

I am returning the concurrent request id in this scenario via the importer script as below.

 

Insert into BNE_PARAM_DEFNS_TL

   (APPLICATION_ID, PARAM_DEFN_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, DEFAULT_STRING, DEFAULT_DESC, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

Values

   (20025, 'LL014_SUCCESS_MESSAGE', 'US', 'US', 'LL015 SUCCESS MESSAGE', 'LL: PO Pay Item Upload Interface - Request ID $import$.requestid', 'Success Message returned upon successful import', -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), -1, TO_DATE('01/18/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);

END;

 

 

 

This will give the concurrent request id back in the excel.

Request ID $import$.requestid

 

Now i have a requirement where i have to return the Purchase order number that is being created by the standard PO import program.

Can some one please suggest if this is possible in webadi to return PO number that is getting created after submitting import when user upload the data.

 

Regards,

Sank

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points