My Oracle Support Banner

Reports With Project Costing - Actual Costs Real Time Are Failing After Upgrade To Release 13 19c (Doc ID 2606472.1)

Last updated on NOVEMBER 12, 2019

Applies to:

Oracle Fusion Project Costing Cloud Service - Version 11.13.19.07.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.