Stock mouvement in Oracle Inventory not found in Projects
HI all
We have a stock mouvment in Oracle Inventory that should have been interfaced to Oracle Projects.
The material_transactions table indicated that the mouvment has been transfered.
select PM_COST_COLLECTED , PM_COST_COLLECTOR_GROUP_ID
from
mtl_material_transactions
where inventory_item_id = 500006
and transaction_id = 47671263
NULL , 47672176
Looking into PA , I cant find the expenditure
select *
from
pa_expenditure_items_all
where orig_transaction_reference = TO_CHAR ('47671263')
no records
Its not in the interface table either
select
*
from
pa_transaction_interface_all
where orig_transaction_reference = TO_CHAR ('47671263')
Any ideas ?
Thanks
John HALL