Projects - EBS (MOSC)

MOSC Banner

Stock mouvement in Oracle Inventory not found in Projects

edited Nov 1, 2018 5:08AM in Projects - EBS (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center