Create an extension that uses an extensible flexfield to cancel order lines in a sales order.

In this video, we will cover the below use case
Assume your customer places a sales order for items you can't fulfill because they are obsolete and your supplier no longer supplies them. You can use an order management extension to cancel lines that contain a value, such as Obsolete, in an extensible flexfield.
Refer other videos
How to create and use hold codes
• How to create Hold Cod...
• How to create Hold Cod...
• Order Management Order...
Execute the following SQL
SELECT DHA.SOURCE_ORDER_NUMBER ,
DHA.ORDER_NUMBER ,
DFLA.FULFILL_LINE_NUMBER,
DFLEB.CONTEXT_CODE ,
DFLEB.ATTRIBUTE_CHAR1
FROM DOO_HEADERS_ALL DHA ,
DOO_FULFILL_LINES_ALL DFLA,
DOO_FULFILL_LINES_EFF_B DFLEB
WHERE DHA.HEADER_ID = DFLA.HEADER_ID
AND DFLA.FULFILL_LINE_ID = DFLEB.FULFILL_LINE_ID (+)
AND DHA.SOURCE_ORDER_NUMBER = '&Source_Order_Number';
The following SQL can be used to define the Values passed in the Rule for:
SELECT fdst.DESCRIPTIVE_FLEXFIELD_CODE ,
fdsb.context_code ,
fdsb.segment_code ,
fdsb.SEGMENT_IDENTIFIER
FROM fusion.fnd_df_segments_tl fdst,
fusion.fnd_df_segments_b fdsb
WHERE fdst.APPLICATION_ID = fdsb.APPLICATION_ID
AND fdst.ENTERPRISE_ID = fdsb.ENTERPRISE_ID
AND fdst.DESCRIPTIVE_FLEXFIELD_CODE = fdsb.DESCRIPTIVE_FLEXFIELD_CODE
AND fdst.CONTEXT_CODE = fdsb.CONTEXT_CODE
AND fdst.SEGMENT_CODE = fdsb.SEGMENT_CODE
AND fdst.language = 'US'
AND fdst.descriptive_flexfield_code = 'DOO_FULFILL_LINES_ADD_INFO'
ORDER BY fdst.CONTEXT_CODE,
fdsb.Segment_code

[@mdabidraza7299]

Will this works on split line as well. Let see i have 100 qty i order 150 On time would 100 And peninding 50 I wanted to cancel pending qty is it possible?

[@FusionNexgenLearning]

Dear, Yes, it will work for split lines as well. As long as the extension values are populated in EFF correctly. Regards, Fusion NexGen Learning