After Upgrade / Patch Application Unable To Manually Override Price At Line Level - Error: APP-ONT-250274- No Manual Discount Available (Doc ID 1311411.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Quick Sales Order Form

.
Checked for relevance on 24-JUN-2015
.


Symptoms

On : 12.1.x version, Pricing, Discounting & Charges

Cannot override the unit selling price on an order line.  Also when attempting to select a modifier using actions > view adjustments on the sales order header, the following errors occur:


ERROR
-----------------------
APP-ONT-250274- No  Manual Discount Available

FRM-40735: WHEN- NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-04162


NOTES
-----------
Upgraded from 11.5.10 to 12.1.x
It worked fine in 11.5.10. In 12.1.x it works in quoting, but not in Order Management.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate to: Orders, Returns> Sales Orders
3. Query order
4. Do Actions > View Adjustments
Place cursor on the modifier number and pull up the list of values
Error is shown: FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-04162

Changes

 This issue can sometimes occur when any pricing patch is applied.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms