My Oracle Support Banner

Error "ORA-00904" On Order Head CFA Screen During View/Edit Orders And While Searching Partner in Partner Screen (Doc ID 2679449.1)

Last updated on JUNE 17, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.

Symptoms

Getting below error on Customer Flex Attributes(CFA) ORDHEAD screen during edit/view orders and while searching Partner in Partner screen

"ORA-00904: "NUMBER_11TRAN": invalid identifier."


Scenario 1:
1. Go to Tasks- > Orders -> Manage Order.
2. Input Order No and click on search.
3. Edit/View the order number.
4. Click on Other attribute and go to CFA screen.
5. Note the above error.


Scenario 2:
1. Login to RMS UI.
2. Foundation Data -> Suppliers and Partners -> Manage Partners.
3. Give the partner_id then click on search.
4. In Partner screen, click on More Actions-> Other Attributes -> Partner Attributes.
5. Note the above error.

Changes

 

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.