My Oracle Support Banner

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 AUGUST 20, 2021

Applies to:

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


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:

APP-ONT-250274- No  Manual Discount Available

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

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.

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


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


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

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