This content has been marked as final. Show 2 replies
Your requirements will be taken care if you can group the requisitions by Owning Division right..did you consider/try adding a new segment in the Purchasing Category which will hold Owning Division?
To handle complicate grouping requirements, it is best to use the group_code field in po_Requisitions_interface_all. All requisitions with the same value in the GROUP_CODE column are grouped in one req. So you can write a d/b trigger or some custom code to update the group_code according to your business logic.
Look at Nagmohan's post for some code in Requisition Import Program and at
A better solution is to use the oracle provided custom hook (po_reqimp_pkg.post_validate_user_extensions) for requisition import to populate the GROUP_CODE column in PO_REQUISITIONS_INTERFACE table. The logic inside the hook will populate appropriate interface records with the same GROUP_CODE. The logic you put here is supported by Oracle and will survive upgrades/patches.
Hope this answers your question
Independent Techno-functional Consultant