Posts

Posts

  • Sathish Ravichandran
    Drill down in fusion BIP Reports35.0
    Topic posted November 27, 2019 by Sathish RavichandranGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Reports in Reporting and Analytics for ERP public
    Title:
    Drill down in fusion BIP Reports
    Summary:
    Using drill down functionality in BIP Reports (using BIP template and output in excel)
    Content:

    Hi,

    Does anyone use drill down functionality in BIP Reports (using BIP template and output in excel)?
    We tried and excel hyperlink works fine if number of rows is less than 65536. When it cross this limit excel gets corrupted and prompts for recovery when we open excel.
    Did anyone overcome this issue?
    As a workaround oracle SR suggested to use excel template instead of BIP template and split the output into multiple sheets. Our customer don't want this, as it restricts output format to only excel and also don't want to work with multiple sheets of 65k.

     

    Attached image will give you idea where we are passing deep link in BIP template and error we are facing while opening excel.

     

    Version:
    Oracle Cloud Application 19C (11.13.19.07.0)
    Image:
    Document:
    error.png (87KB)
  • Sudhakara Rao Kovuru
    Payments and Batch details should pull into single row with...15.0
    Topic posted November 26, 2019 by Sudhakara Rao KovuruBronze Crown: 15,000+ Points, tagged BI Publisher in Reporting and Analytics for ERP public
    Title:
    Payments and Batch details should pull into single row with eText template
    Summary:
    Payments and Batch details should pull into single row with eText template
    Content:

    Hi Friends,

    eText payment template file using different groups where always have one to many relation ( ex: 1 payment batch has 10 invoices) , I see some challenge to handle it. 

    Hope someone might gone through, so could you please review and help. 

    Use case :- 

    1) Few columns from PaymentInstructionInfo/InstructionReferenceNumber

    2) Other columns from OutboundPayment/DocumentPayable

    Actual Data :- 

    ACCOUNT_NUMBER; PAYMENT_TYPE; TRANSACTION_DATE; CURRENCY; AMOUNT; PAYMENT_BATCH_ID

          1291475270;        TRF;                      11/26/2019;              USD;                    500.01;

          1291475270;           TRF;                   11/26/2019;               USD;                    2000;

           1291475270;        TRF;                      11/26/2019;              USD;                     20000;

           ;699003

     

     

    Expected Data :- 

            ACCOUNT_NUMBER; PAYMENT_TYPE; TRANSACTION_DATE; CURRENCY; AMOUNT; PAYMENT_BATCH_ID

                     1291475270;        TRF;                      11/26/2019;                     USD;              500.01;   699003

                     1291475270;        TRF;                      11/26/2019;                    USD;               2000;      699003

                    1291475270;        TRF;                      11/26/2019;                    USD;                20000;    699003

     

    Thanks,

    -Sudha.

     

    Version:
    19D
    Document:
    Document:
  • Fahad Cader
    How to secure ESS LOV by Business Unit
    Topic posted November 26, 2019 by Fahad CaderRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Reports in Reporting and Analytics for ERP public
    Title:
    How to secure ESS LOV by Business Unit
    Summary:
    How to secure ESS LOV by Business Unit
    Content:

    How to secure ESS LOV by Business Unit.

     

    i.e. There are two Business Units ->    BU1  and BU2

    I have access only to BU1.

    How can I create a LOV for a ESS job, so I can only see BU1 in the LOV.

  • Dilip Kuchipudi
    SKIP ROW based on an attribute in one sheet of a multi sheet...7
    Topic posted November 25, 2019 by Dilip KuchipudiRed Ribbon: 250+ Points, tagged BI Publisher, Reports in Reporting and Analytics for ERP public
    Title:
    SKIP ROW based on an attribute in one sheet of a multi sheet excel template
    Summary:
    I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.
    Content:

    I have inserted the following in Data Constraints of the XDO_METADATA.

    <xsl:if test="number(.//COST_DIFF)!=0"> <xsl:value-of select=".//COST_DIFF"/> </xsl:if>

    COST_DIFF is in the Detail sheet and the rows to be suppressed from display are in the Detail sheet only.  However it's not applying this because I think somewhere we should say this condition is for the detail sheet.

    Any ideas are much appreciated.

    Dilip

     

  • Rajanikanth Mohanraju
    Combing OTBI Output in one row1
    Topic posted November 25, 2019 by Rajanikanth Mohanraju, tagged BI Publisher, Fusion Project reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Combing OTBI Output in one row
    Summary:
    Combing OTBI Output in one row
    Content:

    I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Lines. The trouble is DRs are CRs are resulted in 2 separate rows. I wonder if anyone have attempted to result the data in a single row albeit in separate columns? 

    The below is the SQL issued for this OTBI Report. Concatenated Segments field hols Accounting KFF values.

    If so please advise.

    --------------------------------

    SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
       0 s_0,
       "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Apps Document Currency Code" s_1,
       "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Expenditure Comment" s_2,
       "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Expenditure Item Date" s_3,
       "Project Costing - Actual Costs Real Time"."Expenditure Item"."Expenditure Item" s_4,
       "Project Costing - Actual Costs Real Time"."Expenditure Type"."Resource Type Name" s_5,
       "Project Costing - Actual Costs Real Time"."General Ledger Account"."Account Type" s_6,
       "Project Costing - Actual Costs Real Time"."General Ledger Account"."Concatenated Segments" s_7,
       "Project Costing - Actual Costs Real Time"."Original Source References"."Transaction Source Name" s_8,
       "Project Costing - Actual Costs Real Time"."Processing Details"."Expenditure Item Expenditure Group Name" s_9,
       "Project Costing - Actual Costs Real Time"."Project"."Project Name" s_10,
       "Project Costing - Actual Costs Real Time"."Project"."Project Number" s_11,
       "Project Costing - Actual Costs Real Time"."Task"."Task Name" s_12,
       "Project Costing - Actual Costs Real Time"."Task"."Task Number" s_13,
       DESCRIPTOR_IDOF("Project Costing - Actual Costs Real Time"."General Ledger Account"."Account Type") s_14,
       DESCRIPTOR_IDOF("Project Costing - Actual Costs Real Time"."Task"."Task Name") s_15,
       "Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Raw Cost in Transaction Currency" s_16
    FROM "Project Costing - Actual Costs Real Time"
    ORDER BY 1, 10 ASC NULLS LAST, 9 ASC NULLS LAST, 5 ASC NULLS LAST, 12 ASC NULLS LAST, 11 ASC NULLS LAST, 14 ASC NULLS LAST, 16 ASC NULLS LAST, 13 ASC NULLS LAST, 6 ASC NULLS LAST, 4 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 7 ASC NULLS LAST, 15 ASC NULLS LAST, 8 ASC NULLS LAST
    FETCH FIRST 500001 ROWS ONLY

    -----------------------------------------------

  • Ashish Gupta
    Fetch large volume of data in BI publisher report75.0
    Topic posted November 21, 2019 by Ashish GuptaRed Ribbon: 250+ Points, tagged BI Publisher in Reporting and Analytics for ERP public
    Title:
    Fetch large volume of data in BI publisher report
    Summary:
    Fetch large volume of data in BI publisher report
    Content:

    HI 

    We have a requirement to extract data for GL code combinations using BI publisher and burst the output. In our case, gl code combination table has more than 10 million of rows and we have extract whole dump.

    We tried using BI publisher but it is getting error out.

    Please share your expertise on handling such large volume.

     

    Regards

    Ashish

    Version:
    19c
  • Srekan
    case insentive in BI publisher text box parameter3
    Topic posted November 20, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    case insentive in BI publisher text box parameter
    Summary:
    how to get data when passing case insentive in BI publisher text box parameter
    Content:

    Hello All,

    i have BI publisher report with parameter "Name" text box. when user enters name for example Tom, it has to pull all Tom records. 

    when user enters any other format / combination in the text box value Tom, it has to pull records.

    possible combinations to enter in name text box are Tom, TOM, ToM, tom, tOM etc.

     

    Regards,

    Joe

    Version:
    BI publisher 12c
  • nathan morgan (at Client)
    What is catalog folder Extension?5.0
    Topic posted November 20, 2019 by nathan morgan (at Client)Bronze Medal: 1,250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Setup, Setup/Administration in General OBIEE public
    Title:
    What is catalog folder Extension?
    Summary:
    Does anyone know the purpose of the empty shared folder Extension in the catalog?
    Content:

    The folder is empty.

    A duty role exists for it, BI_EXT_REPORTING_DUTY, but unlike the other folders, the permissions on this folder have not been updated so that only people with that role see this folder.

    I had been doing the following configuration to assign folder reporting duty roles to role

    Custom BI Webcat Reporting Duty

    CONFIGURE NEW BI REPORTING DUTY ROLES TO HIDE THE FACTORY CATALOG FOLDERS

    Cloud Readiness Common Technologies and User Experience
    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098

    Nathan

    Version:
    19C (11.13.19.07.0)
    Image:
    Code Snippet:
  • Tessy van Engelen
    Report 'Receipt Accrual Balances'5.0
    Topic posted November 19, 2019 by Tessy van EngelenBlue Ribbon: 750+ Points, tagged BI Publisher, BI Publisher Reports, Inventory, SCM, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO in Reporting and Analytics for SCM public
    Title:
    Report 'Receipt Accrual Balances'
    Summary:
    Report similar to 'Adjust Receipt Accrual Balances' menu
    Content:

    We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Balances menu'.

    It has to show the amounts that are displayed in this screen per reference date, PO and business unit.

    Desired columns:

    - Business unit     

    - Purchase order

    - Accrual Adjustment

    - Item Price    (net received and invoiced)

    - NonRecoverable tax (net received and invoiced)

    - Recoverable Tax (net received and invoiced)

    - Total Receipt Value (net received and invoiced)

    - Accrual Balance Quantities (Net received and invoiced)

    - Quantity Difference

    - Supplier

    - Supplier Site

    - Inventory Organization

    - Item

    - Item Description

     

     

    Version:
    19C
  • Ling Xiang
    OTBI Customer Survey15.0
    Topic posted November 18, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Data Visualization, Reporting and Analytics in Sales > Reporting and Analytics for Sales public
    Title:
    OTBI Customer Survey
    Content:

    Oracle BI development is planning OTBI feature improvements.  To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting an OTBI customer survey.  Please take 10-minutes to complete this 10-question survey to share your feedback, thoughts and ideas ->   https://cloudcustomerconnect.oracle.com/pages/d549eddf75

    Thank you for your time!

    Ling Xiang

    Oracle OTBI Product Management