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 later
Information in this document applies to any platform.
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)
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'
name: Zurückfordern -- This is German for Reclaim
window prompt: Zurückfordern
value set: Yes_No
checked - freeze flexfield definition
compiled DFF - the flexfield was compiled successfully
Add value "No" for DFF as noted above
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".
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