My Oracle Support Banner

ORA-00904 Error on Buyer Worksheet screen (Doc ID 3062630.1)

Last updated on DECEMBER 09, 2024

Applies to:

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

Symptoms

When working in the Buyer Worksheet, user checked the scaling totals and Saved and Closed the screen. When going back into the screen, selecting the same items, and checking the scaling totals again they were presented with an error - ORA-00904 - "SUPPLIER" Invalid Identifier.

Steps :

 1. Filter to a supplier site/location/date on Buyer Worksheet
2. Review the ROQs and make some changes in the Actual column
3. Select the rows they intended to push to a worksheet PO and click the calculator icon to see the total and the scaling constraints to compare the total to. It is already in range, so click save and close to make sure that the Actual values that have been updated were saved.
4. Go back into Buyer Worksheet and filter the same way
5. Select the same items and click the calculator icon to make sure that nothing has changed. This produces the error.

Diagnosis: In order to speed the resolution of your issue, Oracle Support requires structured information in order to begin the troubleshooting process. Perform the steps in the following document to provide necessary information to your Support engineer:

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
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.