My Oracle Support Banner

When OM Transaction Type Enforce Price List = Yes, Cannot Import Orders With Pricing Using Oe_order_pub (Doc ID 2789362.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

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

Goal

When OM transaction type Enforce price list = Yes, users cannot import orders with pricing using oe_order_pub

Business is working on a project to stop OM users from being able to change prices on the Order lines.  The OM: Discounting Privileges is set to FULL and checked the Enforce Price List option on the transaction type. This stopped users from being able to update prices on an order. Results as we expected.

Project #2 is to import electronic orders using the oe_order_pub.Process_order API. With the setup from the previous project, users are getting error below when running the API: "message is: Item and EA not on Price list". The API creates the order but does not price the line. Goal is to price the  imported line.

Confirmed if users remove the enforce price list check box on the transaction type the API does work as expected.
 

Solution

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
Goal
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.