My Oracle Support Banner

Version History Page Error ORA-00904 BILLING_PLAN_HEADER_ID Invalid Identifier (Doc ID 2265827.1)

Last updated on FEBRUARY 20, 2019

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



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.