You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Delta Type column in DOO_FULFILL_LINES_ALL table

Received Response
edited Jul 23, 2020 7:08PM in Order Management 3 comments


Purpose of the column of Delta_Type in the table "DOO_FULFILL_LINES_ALL"



We got a requirement to identify the operation (create,update,delete,cancel) carryout on the given sales order in fusion so we will push that specific change to the downstream system using integration cloud.So we are using the order fulfillment request web service (being called in custom DOO) to capture the order details where we come across one of the column called "DELTA_TYPE" at fulfillment line level.

When I did select distinct delta_type from DOO_FULFILL_LINES_ALL, I got the below list. Please help me understand what are these codes and corresponding meaning. 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!