My Oracle Support Banner

Error You are not Allowed to Update Freight Terms Because Line Has Been Pick Confirmed/Staged When Attempting to Delink A Configured Item (Doc ID 2931466.1)

Last updated on MARCH 06, 2023

Applies to:

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

Symptoms

On : 12.2.9 version, Trx Changes & Cancellations

Unable to delink/cancel a configure item  on line 1.1.0 when other configured/star item on line 2.1.0 is in Picked status.
When line 92.1.0 is shipped, then the application is allowing changes to line 1.1.0.
The below error is raised in the form:

"You are not allowed to update freight terms. because line has been pick confirmed/staged."

The following errors are seen in the OM debug log file:


ERROR
-----------------------

ENTERING PROCEDURE CLEAR_GLOBAL_STRUCTURE
LEAVING OE_MSG_PUB.COUNT_AND_GET 1
delink_item: oe_config_util.delink_config returnedE
delink_item: Expected error in OE_CONFIG_UTIL.delink_config procedure....
LEAVING OE_MSG_PUB.COUNT_AND_GET 1
delink_item: ERROR: CTOCITMB.delink:650ONT G_MISS_CHAROE_PC_UPDATE_FIELD_VIOLATION G_MISS_CHARN G_MISS_CHARATTRIBUTE G_MISS_CHARFreight Terms G_MISS_CHARN G_MISS_CHARREASON G_MISS_CHARLine has been pick confirmed/staged. G_MISS_CHAR
delink_item: ERROR: CTOCITMB.delink: appl_name ONT
delink_item: ERROR: CTOCITMB.delink: error_name OE_PC_UPDATE_FIELD_VIOLATION

ENTER OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , COLUMN:FREIGHT_TERMS_CODE
CONSTRAINT ID:18
VALIDATION PKG :OE_2PC2_LINE_SHPCNF RESULT :0
VALIDATION PKG :OE_SHIPPING_INTEGRATION_PVT RESULT :1
ADD CONSTRAINT MESSAGE
LEAVING OE_MSG_PUB.ADD
EXIT OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , RESULT:1
Action performed code : 0
Audit Trail enabled
Audit Trail enabled for booked orders only ...
Exit OE_LINE_Security.Attributes



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

1. OM Super User Responsibility
2. Order Orfanizer
3. Query affected order
4. Go to Lines tab and select line
5. Attempt to cancel line

 

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.