Loading Advanced Pricing ECC Fails With Error ORA-00903: Invalid Table Name
(Doc ID 2944652.1)
Last updated on MAY 17, 2023
Applies to:
Oracle Advanced Pricing - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to load the Advanced Pricing ECC (Pricing User Dashboard), the following error occurs and is shown in ECC log file.
-----------------------
Failed as one of the load rules failed which is [id = 23,671, QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO]. Please check the load rule audit entry
There is Exception while applying load rule for dataset qp-headers for job 25,329. Exception details ORA-00903: invalid table name oracle.jdbc.driver.XXXXXXX11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.XXXXXXX11.processError(XXXXXXX11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a DFF segment with a ' ü ' within the name for DFF on modifier header record.
This is a non-English character
enabled DFF for 'Additional info for List Headers'
added segment
name: Zurückfordern -- This is German for Reclaim
window prompt: Zurückfordern
column: ATTRIBUTE8
value set: Yes_No
saved
checked - freeze flexfield definition
compiled DFF - the flexfield was compiled successfully
Query modifier
Add value "No" for DFF as noted above
Save.
2. Oracle Pricing User responsibility > Advanced Pricing > Pricing User Dashboard
Finds that at this point, the above error message is shown.
WHAT DOES WORK
-------------------------------
Renaming the flexfield from "Zurückfordern" to "Zurueckfordern".
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 |