We Need to know why the Organization id not get populated in PA interface table
The source organization id is missing from the Projects import table for the Purchase Price Variance(PPV) between two Inte Organization Locations.
1. Internal Shipment Transfered to Projects.
2. Line is stuck in Transaction Import that relates to PPV.
3. In Projects Review Transaction form shows error as : - 'You must enter an employee or organization'
select * from APPS.pa_transaction_interface_all where
organization_name is null and transaction_rejection_code ='EMP_OR_ORG_MAND' ( output attached, filename - pa_transaction_interface_all.xls)
In Inventory the Material Transaction shows the organization id
select * from mtl_material_transactions
where 1=1 and transaction_id in('2744575','2614180') ( output attached, filename - mtl_material_transactions.xls)
1. Internal Shipment Transfered to Projects.
2. Line is stuck in Transaction Import that relates to PPV.
3. In Projects Review Transaction form shows error as : - 'You must enter an employee or organization'
select * from APPS.pa_transaction_interface_all where
organization_name is null and transaction_rejection_code ='EMP_OR_ORG_MAND' ( output attached, filename - pa_transaction_interface_all.xls)
In Inventory the Material Transaction shows the organization id
select * from mtl_material_transactions
where 1=1 and transaction_id in('2744575','2614180') ( output attached, filename - mtl_material_transactions.xls)
0