Version History Page Error ORA-00904 BILLING_PLAN_HEADER_ID Invalid Identifier

(Doc ID 2265827.1)

Last updated on MAY 14, 2017

Applies to:

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


Receive error after patches with Version History Page.

After applying patches for following error was uncovered:
1. Apply Patch 23013963:R12.ONT.C for fix from : Sales Order Version History Not Showing Data For Earlier Versions <Note 2009097.1>
OEXFLINB.pls 120.31.12020000.20

2. Apply Patch 24835466:R12.ONT.C for fix from: Version History Is Capturing Incorrect Information And Version History Form Is Throwing Errors <Note 2084164.1>
OEXFLINB.pls 120.31.12020000.22

Error: ORA-00904: "BILLING_PLAN_HEADER_ID": invalid identifier
Error: ORA-01409: no data found

The issue can be reproduced at will with the following steps:
1.Responsibility: Order Management Super User
2. Navigate: Orders Workbench, Order Organizer > Query Sales Order, Open Version History >
3. Receive error ORA -00904 BILLING_PLAN_HEADER_ID" :Invalid Identifier


The issue has the following business impact:
Due to this issue, users getting error opening the version history from form.


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