OBIA 11g : PURCH_RQSTN_ITEM Of Table W_PURCH_COST_F Is Defined As Double
(Doc ID 2341073.1)
Last updated on SEPTEMBER 26, 2022
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and laterInformation in this document applies to any platform.
Symptoms
On: Oracle Business Intelligence Applications
- The out of the box field PURCH_RQSTN_ITEM of table W_PURCH_COST_F is defined as double in the Repository while the source EBS field is string which is sending the string values as well.
- This results in below error in any report which uses "Purchase Requisition Line Number" in the report(the presentation level field derived from the mentioned physical level field)
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: invalid number at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)
Changes
NA
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 |