Hi Experts,
We are fetching the data from cloud and loaded into stage table. And after validating the data, we are loading the data into interface table, MSC_RELEASE_LINES_INT. And in same package after loading into interface table we are calling the Import Oracle Supply Chain Planning Cloud recommendations program. This program is calling the Requisition Import program which actually creates PRs in EBS.
Now, we have a requirement to fetch the PR# and store into stage table. We are not able to figure out how to fetch the PR#. Because, while Requisition Import program was submitted from main program, there is no link. I mean, the Requisition Import program is not storing the PARENT_REQUEST_ID.
Can anyone please help me on how to achieve this.
Thanks in Advance,
Srivathsava