You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Budget vs. Actual Cost Comparison by Business Unit with sql error

Received Response
33
Views
2
Comments

Summary:

unable to execute Budget vs. Actual Cost Comparison by Business Unit with the error

Error Codes: OPR4ONWY: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: 27002. [nQSError: 27002] Near <SET>: Syntax error (HY000)

State: HY000. Code: 26012. [nQSError: 26012] . (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Project Currency'; SELECT 0 s_0, "Project Costing - Actual Costs Real Time"."Currency Exchange Details"."Apps Common Currency Code" s_1, "Project Costing - Actual Costs Real Time"."Project"."Current Project Manager" s_2, "Project Costing - Actual Costs Real Time"."Project"."Project Business Unit" s_3, "Project Costing - Actual Costs Real Time"."Project"."Project Number" s_4, IFNULL("Project Control - Budgets Real Time"."- Budget Cost Measures"."Current Budget Cost",0) s_5, IFNULL("Project Control - Budgets Real Time"."- Budget Cost Measures"."Current Budget Cost",0)-IFNULL("Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Cost",0) s_6, IFNULL("Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Cost",0) s_7,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!