Requisition Import: Why is deriving the SOURCE_ORGANIZATION_ID failing for certain users?
Requisition Import in EBS 11.5.10.2
Hello all,
we are importing Internal Requisition via interface table po_requisitions_interface_all. We are setting AUTOSOURCE_FLAG = 'P' (partially derived). For all columns we are filling, see an example in attachment (requisitions_interface_all.xlsx).
When running the program Requisition Import, parameter Import Source is INTERFACE. Therefore, we are expecting that SOURCE_ORGANIZATION_ID is derived by the program. Sourcing rules for the items are set up.
Now, the Requisition Import always works fine for some users.
For other users, the Requisition Import constantly fails for exactly the same records inserted. For an example see the attachments (po_requisition_interface_all_83164681.xlsx, po_interface_errors_83164681.xlsx). The errors message that seems to be the root problem says