OBIA 11g : PURCH_RQSTN_ITEM Of Table W_PURCH_COST_F Is Defined As Double
(Doc ID 2341073.1)
Last updated on MAY 15, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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)
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