This discussion is archived
1 Reply Latest reply: Nov 1, 2012 4:08 AM by 745476 RSS

Passing value to Importer

745476 Newbie
Currently Being Moderated
I have created custom Integrator to upload PO Receipts, for this a custom wrapper is developed to insert records into Interface tables like (RCV_HEADERS_interface, RCV_transactions_interface). Wrapper is successfully uploading records to interface tables. For import data from interface table to oracle base table I have created import as PL/SQL function in which there are two parameters one of the parameter value has to be taken from Interface Attributes.
I tried to pass Interface attribute value to Import parameters (PL/SQL) by $import$.P_GROUP_ID it’s passing to importer
even I tried by placing <Interface_name>.P_group_id


Any idea how to pass Interface attribute value to Importer parameter?
  • 1. Re: Passing value to Importer
    745476 Newbie
    Currently Being Moderated
    Now I am able to solve this by creating staging table, I am able to pass from interface attribute value to Importer(Successfully submitted concurrent request at the end of loading).
    this only works for Table Interface type, for API still its not working.

Legend

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