Posts

Posts

  • MShrini
    The tool 'OracleBIOffice.exe' is not available after...24.3
    Topic posted September 23, 2017 by MShriniBronze Crown: 15,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Online Layout Editor, OTBI, Report Delivery, Reports, Sample Reports, Setup, Setup/Administration, Upgrades in General OBIEE public
    Title:
    The tool 'OracleBIOffice.exe' is not available after R12 upgrade
    Summary:
    The tool 'OracleBIOffice.exe' is not available after R12 upgrade
    Content:

    We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspace as error message is returned.   Kindly help us in this regard as we have to build OTBI  report on smartview

  • Peter Kirwan
    Time in role report2
    Topic posted February 2, 2017 by Peter KirwanBlue Ribbon: 750+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Core HR, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Reports, SQL in General OBIEE public
    Title:
    Time in role report
    Summary:
    I need to create a time in role report
    Content:

    I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Employee filtered by a Job Title.

    Can someone help?

  • Shalindra Singh
    To Extract Order Header and Line details using OTBI5.0
    Topic posted November 26, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, tagged Analyses, OTBI, Reports, Sample Reports in General OBIEE public
    Title:
    To Extract Order Header and Line details using OTBI
    Summary:
    looking for Sample query that works to get Header and line details of available orders using OTBI
    Content:

    Hi,

    Can someone please provide me working sample query for OTBI. I am sure I am missing something because when I provide below query I do not get error but I also do not get any records while I know for the facts that orders do exits in the application as I also created few of them.

    select_physical

    headerId, OrderNumber

    from "FscmTopModelAM.DooTopAM.Header"

  • Walter de Wit
    TODATE Function not working in 'Budgetary Control -...35.0
    Topic posted April 16, 2019 by Walter de WitGreen Ribbon: 100+ Points, tagged OTBI in Reporting and Analytics for ERP public
    Title:
    TODATE Function not working in 'Budgetary Control - Balances Real Time')
    Summary:
    TODATE Function not working as expected in mentioned SA
    Content:

    When using the TODATE() Function in Subject Area 'Budgetary Control - Balances Real Time' an errors occurs:

     Error
      View Display Error
     
    Odbc driver returned an error (SQLExecDirectW).
      Error Details
    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: 43119. [nQSError: 43119] Query Failed: (HY000)
    State: HY000. Code: 14078. [nQSError: 14078] This query requires the External Expression to be set in the physical Complex Join FscmTopModelAM.FinGlCalAccAM.GLFiscalPeriodPVO_FscmTopModelAM.FinCcControlEnginePublicModelAM.BalancePVO. (HY000)
    SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Budgetary Control - Balances Real Time"."Control Budget Account"."Concatenated Segements" s_1, "Budgetary Control - Balances Real Time"."Control Budget"."Control Budget Name" s_2, "Budgetary Control - Balances Real Time"."Time"."Budget Period Name" s_3, "Budgetary Control - Balances Real Time"."Time"."Budget Year" s_4, DESCRIPTOR_IDOF("Budgetary Control - Balances Real Time"."Control Budget"."Control Budget Name") s_5, SORTKEY("Budgetary Control - Balances Real Time"."Time"."Budget Period Name") s_6, "Budgetary Control - Balances Real Time"."Budget"."Total Budget" s_7, TODATE("Budgetary Control - Balances Real Time"."Budget"."Total Budget","Time"."Budget - Fiscal Calendar"."Fiscal Year") s_8 FROM "Budgetary Control - Balances Real Time" FETCH FIRST 75001 ROWS ONLY 

    The logical query used is:

    SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT
       0 s_0,
       "Budgetary Control - Balances Real Time"."Control Budget Account"."Concatenated Segements" s_1,
       "Budgetary Control - Balances Real Time"."Control Budget"."Control Budget Name" s_2,
       "Budgetary Control - Balances Real Time"."Time"."Budget Period Name" s_3,
       "Budgetary Control - Balances Real Time"."Time"."Budget Year" s_4,
       DESCRIPTOR_IDOF("Budgetary Control - Balances Real Time"."Control Budget"."Control Budget Name") s_5,
       SORTKEY("Budgetary Control - Balances Real Time"."Time"."Budget Period Name") s_6,
       "Budgetary Control - Balances Real Time"."Budget"."Total Budget" s_7,
       TODATE("Budgetary Control - Balances Real Time"."Budget"."Total Budget","Time"."Budget - Fiscal Calendar"."Fiscal Year") s_8
    FROM "Budgetary Control - Balances Real Time"
    ORDER BY 1, 5 ASC NULLS LAST, 7 ASC NULLS LAST, 4 ASC NULLS LAST, 3 ASC NULLS LAST, 6 ASC NULLS LAST, 2 ASC NULLS LAST
    FETCH FIRST 75001 ROWS ONLY

    The column formula used is:

    TODATE("Budget"."Total Budget", "Time"."Budget - Fiscal Calendar"."Fiscal Year")

     

    For Subject area 'General Ledger - Transactional Balances Real Time' the TODATE function is working. Used with column formula:

    TODATE("Base"."Period Net Activity", "Time"."Date - Fiscal Calendar"."Fiscal Year")

    Logical query for the analysis is:

    SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT
       0 s_0,
       "General Ledger - Transactional Balances Real Time"."Account"."Concatenated Segments" s_1,
       "General Ledger - Transactional Balances Real Time"."Time"."Fiscal Period" s_2,
       "General Ledger - Transactional Balances Real Time"."Time"."Fiscal Year Number" s_3,
       SORTKEY("General Ledger - Transactional Balances Real Time"."Time"."Fiscal Period") s_4,
       "General Ledger - Transactional Balances Real Time"."Base"."Period Net Activity" s_5,
       TODATE("General Ledger - Transactional Balances Real Time"."Base"."Period Net Activity","Time"."Date - Fiscal Calendar"."Fiscal Year") s_6
    FROM "General Ledger - Transactional Balances Real Time"
    WHERE
    ((DESCRIPTOR_IDOF("General Ledger - Transactional Balances Real Time"."Scenario"."Balance Type") = 'A') AND ("Natural Account Segment"."Natural Account Segment Code" BETWEEN '40000' AND '40100'))
    ORDER BY 1, 4 ASC NULLS LAST, 5 ASC NULLS LAST, 3 ASC NULLS LAST, 2 ASC NULLS LAST
    FETCH FIRST 75001 ROWS ONLY

     

    Why is it not working with the budget data?

     

    Thanks in advance!

    Version:
    Business Intelligence in Oracle Applications Cloud 18C
  • Emre Kuscu
    Total Purchases for Tier I Suppliers1
    Topic posted February 26, 2018 by Emre KuscuGreen Ribbon: 100+ Points, tagged BI Publisher, Costing, Dashboards, Order Management, OTBI, Procurement, Reporting and Analytics, SCM in Reporting and Analytics for SCM public
    Title:
    Total Purchases for Tier I Suppliers
    Summary:
    I need to create an analysis that shows total purchases for specific suppliers.
    Content:

    I need to create an analysis that shows purchase order line details such as quantity and line description for some suppliers (Tier I Suppliers) in a certain timeframe (In last 6 months).

    For example:

    Supplier Name / PO Number / PO Creation Date / Item Description  / Quantity

    Can anybody help me creating this?

    Thanks in advance!

    Emre

  • Gopinath Kartheesan
    Trading Community Model DFFs (Eg, HZ_PERSOn_PRFILES)...3
    Topic posted June 19, 2016 by Gopinath KartheesanBronze Trophy: 5,000+ Points, tagged Fusion Financial reporting, OBI Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Trading Community Model DFFs (Eg, HZ_PERSOn_PRFILES) not visibile in OTBI
    Summary:
    DFFs that were enabled for the respective regions under Trading community Model module are not visible in OTBI
    Content:

    We have some DFFs defined under some of the regions like HZ_PERSON_PROFILE (Person) or Customer Account or Customer Account sites etc.  While defining DFFs for these regions, there are no "BI Enabled" flag.  The same DFFs are not available in OTBI Real time subject areas.  Are these DFFs supported in OTBI or not?

  • Joy Hanneman
    Trailing Spaces in OBIEE2
    Topic posted October 30, 2019 by Joy HannemanGreen Ribbon: 100+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Reports, SQL in General OBIEE public
    Title:
    Trailing Spaces in OBIEE
    Summary:
    formatting question
    Content:
    Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish.

    I have a report where I need to create trailing spaces and have fixed character length columns. I have leveraged casting as VARCHAR, overriding the default value to plain text (don't break spaces) and using the prefix in the advanced tab of

    SET VARIABLE DISABLE_RIGHTTRIM_FOR_VARCHAR=1,

    DISABLE_RIGHTTRIM_ON_LENGTH_FOR_VARCHAR=1;

    I'm still not getting the results I am expecting. When I export it no matter the file type, its still trimmed and the trailing spaces are gone.

    Do you know what I am doing wrong?

    I really appreciate any advice! I haven't had much luck with the knowledge database and using on site resources to get this figured out.
     
    The specificity of this formatting is due to a file we are sending off to a vendor where they have fixed character length columns included in the requirements.

    Thanks!

    Joy Hanneman
    Code Snippet:
  • Dev Thota
    Transaction time in the report and in Payables Application...4
    Topic posted September 6, 2018 by Dev ThotaGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBIEE Answers, OTBI, Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Transaction time in the report and in Payables Application are different
    Summary:
    Transaction time in the report and in Payables Application are different
    Content:

    Hi all,

    Developed a report using Payables -transactions real time subject area.In that Invoice Creation time in the report and in the Payables Application are  different. Please find the screen shot attached?

    Image:
  • Giuseppe Botta
    Translate SQL of OTBI in ApplicationDB HCM1
    Topic posted November 6, 2017 by Giuseppe BottaSilver Medal: 2,000+ Points, tagged BI Publisher, BI Publisher Data Models, OBIEE Answers, OTBI in General OBIEE public
    Title:
    Translate SQL of OTBI in ApplicationDB HCM
    Summary:
    How to Translate SQL of OTBI in ApplicationDB HCM?
    Content:

    Hello,

    I have verified that in SA of OTBI there aren't some value that I want to use in a report. I found this in Application table and I want to create a new BI publisher.,I verified that the join between OBIEE dataset and ApplicationDB dataset is very slow. I want to convert my OBIEE data sets in ApplicationDB, is there a tools that extract from my OTBI the physical query with the tables of ApplicationDB?

    Thanks

    Giuseppe

  • Tausif Mulla
    Translation report for Foreign Currency Translation Reserve...3
    Topic posted January 28, 2019 by Tausif MullaBronze Medal: 1,250+ Points, tagged Configuration, Discussion Forums, Financials, Fusion, General Ledger, Help Center, OTBI, Reports, Sample Reports, Search, Security, Setup, Setup / Administration, Subledger Accounting in Reporting and Analytics for ERP public
    Title:
    Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.
    Summary:
    Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.
    Content:

    Hi,

    Is there any report in Oracle cloud ERP for Foreign currency translation reserve reconciliation ? This will be part of translation process.

    Please suggest !