Procurement - EBS (MOSC)

MOSC Banner

PO Receipt of Multiple Distribution lines

edited Sep 27, 2019 5:09AM in Procurement - EBS (MOSC) 4 commentsAnswered

Hello Expert/Guru,

We have oracle ebs R12.1.3.

PO Shipment has multiple Distribution lines.

For example:

PO Line = 100 Qty

PO Shipment  = 100

po Distribution1 = 60 Qty  for    Project = P1    Task = T1

po Distribution2 = 40 Qty  for    Project = P1    Task = T2

After taking the receipt of PO Distribution1, the project_id, Task_id & Po_distribution_id   remains null for Transaction_Type = RECEIVE ,

PO_DISTRIBUTION_ID is stored in RCV_TRANSACTIONS for Transaction_type = DELIVER only

hence it gives me 2 lines instead of 1 line for po receipt SQL.

Any expert can guide me to identify the single specific record for po receipt ?

Thanks

Regards

Sanjay

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