Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

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

Content

Hi,

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.

Register

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