Hi Experts,
We are loading data from csv file to Requisitions using Interface Process.
In our csv file we are getting required information along with GROUP_CODE where we are loading the data into PO_REQUISITIONS_INTERFACE_ALL after our validations and then we are running 'Requisition Import' program.
Requisitions are getting created without any issues.
Lets say, in our csv file for few records we are giving GROUP_CODE as ‘ABC’ and for remaining we are giving as ‘XYZ’. So, 2 requisitions are getting created for each GROUP_CODE.
But, in base tables we are not able to see any column which holds this GROUP_CODE value. But, we are expecting this GROUP_CODE to be available in any of the base tables of Requisitions.
Can anyone please help me on how to achieve this.
FYI, we are using R12.2.8
Thanks in Advance,
Bommi