Reports With Project Costing - Actual Costs Real Time Are Failing After Upgrade To Release 13 19c
(Doc ID 2606472.1)
Last updated on MAY 18, 2023
Applies to:
Oracle Fusion Project Costing Cloud Service - Version 11.13.19.07.0 and laterInformation in this document applies to any platform.
Goal
Reports with Project Costing - Actual Costs Real Time are failing after upgrade to release 13 19c
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 28113, message: ORA-28113: policy predicate has error at OCI call OCIStmtExecute. (HY000)
State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT 0 s_0, "Project Costing - Actual Costs Real Time"."Expenditure Type"."Expenditure Category Name" s_1, "Project Costing - Actual Costs Real Time"."Expenditure Type"."Resource Type Name" s_2, "Project Costing - Actual Costs Real Time"."Expenditure Type"."Revenue Category Code" s_3, "Project Costing - Actual Costs Real Time"."Project"."Project Number" s_4, "Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Burden Cost in Transaction Currency" s_5, "Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Quantity" s_6, "Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Raw Cost in Transaction Currency" s_7 FROM "Project Costing - Actual Costs Real Time" WHERE ("Expenditure Item and Cost Distribution Details"."Cost Distribution Provider Project Accounting Date" BETWEEN date '2019-07-01' AND date '2019-09-30') FETCH FIRST 75001 ROWS ONLY
Solution
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
Goal |
Solution |
References |