EBS on Oracle Cloud Infrastructure (MOSC)

MOSC Banner

OTBI - Order Management - Fulfillment Lines Real Time - Last Update DateS

OTBI using the subject area 'Order Management - Fulfillment Lines Real Time' to extract all Order data using DataSync.

However this need to be changed from a full to an incremental load, however there is only one Last Update Date available to extract the data and that's the one on the order header (DOO_HEADERS_ALL) which doesn't reflect and is not the same as the Last Update Date on the Order Lines (DOO_LINES_ALL) and Order Fulfill Lines (DOO_FULFILL_LINES_ALL).

Note: easy to check when a line is split via the delivery lines


Where are these last_update_dates available in OTBI or how to do an incremental load of the orders?

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