Version History Page Error ORA-00904 BILLING_PLAN_HEADER_ID Invalid Identifier
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>
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>
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