For Release 12.2.9 + Order Import Errors With Update Not Allowed As At Least One Line Is Picked Or Shipped When Attempting to Add a New Line To Orders Created Prior to Release 12.2.9
(Doc ID 3050927.1)
Last updated on OCTOBER 16, 2024
Applies to:
Oracle Order Management - Version 12.2.13 and laterInformation in this document applies to any platform.
Symptoms
Order Import fails with the below error when trying to add a new line to an existing order with a new Orig sys line ref with another item.
The existing order has one closed order line with related delivery details that are shipped and fully interfaced.
Update not allowed as at least one line has been already Picked or Shipped.
------
In Order Import Log file:
In Defaulting Package : ONT_D1_CANCEL_UNSHIPPED_LIN
l_rule_id : 588
SV::l_rule_id before goto RETURN_VALUE : 588
SV::l_return_value before goto RETURN_VALUE : N
Def::The defaulted value for field:g_record.CANCEL_UNSHIPPED_LINES=N
CANNOT POPULATE DERIVED COLUMN ORG_ID...
in CHECK_DERIVED_FLAGS , operation : UPDATE
cancelled flag : G_MISS_CHAR*
------
In Order Import Log file:
In Defaulting Package : ONT_D1_CANCEL_UNSHIPPED_LIN
l_rule_id : 588
SV::l_rule_id before goto RETURN_VALUE : 588
SV::l_return_value before goto RETURN_VALUE : N
Def::The defaulted value for field:g_record.CANCEL_UNSHIPPED_LINES=N
CANNOT POPULATE DERIVED COLUMN ORG_ID...
in CHECK_DERIVED_FLAGS , operation : UPDATE
cancelled flag : G_MISS_CHAR*
The issue cannot be reproduced at will as it is data corruption.
1. Order Management Super User Responsibility
2. Run Order Import
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 |