My Oracle Support Banner

When PTO Model Or Kit Order is Cancelled With Option Item First The Open Flag of Model Remains 'Y' When Model Line Is Cancelled (Doc ID 2793022.1)

Last updated on AUGUST 28, 2024

Applies to:

Oracle Order Management - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

An issue is being faced while cancelling order lines of a PTO Model or Kit order. After the lines have been booked, If child lines are cancelled prior
to cancelling the model line then the child lines cancelled flag reflects correctly as Y, however the open flag also remains as 'Y' and does not get updated to 'N' in the oe_order_lines_all table.


The issue can be reproduced at will with the following steps:

1. Login to Oracle Applications.
2. Go to Order Management Super User Responsibility.
3. Navigate to MENUPATH > Orders, Returns
4. Open the Sales Order Form.
5. Query the Order having the PTO Model or Kit item associated.
6. Go to Line Items tab.
7. Place the Cursor on Line in Awaiting Shipping status
8. Cancel the Sales Order Line Via Actions > Cancel.
9. Enter the Cancel Reason and Comment.. Click on OK.
10. Find that Line's status is Cancelled, cancelled_flag and open_flag are Y (in table oe_order_lines_all).

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.