Fusion OTBI - ODBC Error For Costing - COGS And Gross Margin Real Time Subject Area

(Doc ID 2391984.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.13.18.02.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.17.11.0 version, Technology Management - Reports/Analytics

When attempting to run analysis based on Costing - COGS and Gross Margin Real Time, which includes Flex Fieldsthe following error occurs.

ERROR
-----------------------
[2018-03-23T04:31:03.260+00:00] [OracleBIServerComponent] [TRACE:7] [] [] [ecid: 005Q0n^EuzZB5EY5Prs1yd0003gs0002BD,0:3:1:9:5:1] [tid: 4578b700] [messageid: USER-37] [requestid: d42b0023] [sessionid: d42b0000] [username: rsubramanian@dazsi.com] -------------------- Query execution terminated: <> SQLBypass Gateway
[2018-03-23T04:31:03.260+00:00] [OracleBIServerComponent] [TRACE:7] [] [] [ecid: 005Q0n^EuzZB5EY5Prs1yd0003gs0002BD,0:3:1:9:5] [tid: 43623700] [messageid: USER-20] [requestid: d42b0023] [sessionid: d42b0000] [username: rsubramanian@dazsi.com] -------------------- Execution Node for logical request hash 7ceba449 : <> SQLBypass Exchange, Close Row Count = 0, Row Width = 0 bytes
[2018-03-23T04:31:03.261+00:00] [OracleBIServerComponent] [TRACE:7] [] [] [ecid: 005Q0n^EuzZB5EY5Prs1yd0003gs0002BD,0:3:1:9:5] [tid: 43623700] [messageid: USER-34] [requestid: d42b0023] [sessionid: d42b0000] [username: rsubramanian@dazsi.com] -------------------- Query Status: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-3010: The View Link "oracle.apps.scm.costing.coreSetup.costOrganizations.publicView.analytics.link.flex.CostOrgBookPVOToCostBookDffBIVo" cannot be used to join View Object "FscmTopModelAM.CostOrganizationAM.CostBookDffBIAM.FLEX_BI_CostBookDff_VI". [[
[nQSError: 43119] Query Failed:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create analysis as:

SELECT
  0 s_0,
  "Costing - COGS and Gross Margin Real Time"."Cost Organization Book"."Cost Book Description" s_1,
  "Costing - COGS and Gross Margin Real Time"."Cost Organization Book"."Cost Organization Name" s_2,
  "Costing - COGS and Gross Margin Real Time"."Cost Organization Book"."CST_COST_BOOKS_B_NAME_FLEX_CONTEXT_" s_3,
  "Costing - COGS and Gross Margin Real Time"."Cost Organization Book"."CST_COST_ORG_BOOKS_DESC_FLEX_CONTEXT_" s_4,
  "Costing - COGS and Gross Margin Real Time"."Cost Organization Book"."Currency Code" s_5,
  "Costing - COGS and Gross Margin Real Time"."Cost Organization Book"."Primary Book Flag" s_6,
  "Costing - COGS and Gross Margin Real Time"."Revenue"."Recognized Revenue" s_7
FROM "Costing - COGS and Gross Margin Real Time"
ORDER BY 1, 6 ASC NULLS LAST, 7 ASC NULLS LAST, 2 ASC NULLS LAST, 5 ASC NULLS LAST, 3 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 250001 ROWS ONLY

2. Run the analysis

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms