My Oracle Support Banner

Batch Pricing (OMBATCHPRICE) Fails With Error: ORA-00904: "P_BOOKED_ORDERS": Invalid Identifier (Doc ID 2809075.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

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

Symptoms

On : 12.2.10 version, Pricing, Discounting & Charges

Batch Pricing concurrent program completes with below error when executed with 'Booked Order' parameter

ERROR
-----------------------
Others error in OE_BATCH_PRICING.PRICE : ORA-00904: "P_BOOKED_ORDERS": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order management super user
2. Reports,Requests > Run Batch Pricing program concurrent program

3 Input parameter 'Booked Order'

Changes

 Upgrade to 12.2.10

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.