Order Management - EBS (MOSC)

MOSC Banner

Issue in extraction of data in drop ship case

edited Feb 27, 2018 4:00AM in Order Management - EBS (MOSC) 7 commentsAnswered

Hi Experts/Gurus,

We have problem related to Drop Ship (EBS ver R12.1.3)

We are unable to extract the single record for Drop Ship Record.

For Example :

There is a Sales Order Line with Quantity = 10 and corresponding PO Line with Quantity = 10

We are taking a partial receipt ( Say Receipt Qty = 2 ) .

It will create a new Sales Order Line with Quantity = 8  and Sales Order Line with Quantity = 2 is closed.

Now, I want to fetch the record of Sales Order line as well of PO Receipt for this txn but it gives multiple lines

becuase po_header_id, po_line_id, po_line_location_id are same.

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