Posts

  • 1-6 of 6
  • Richard Beet
    Adding and embedding BI content into Fusion Cloud...315.0
    Topic posted August 15, 2017 by Richard BeetRed Ribbon: 250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding and embedding BI content into Fusion Cloud Applications
    Summary:
    Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content into
    Content:

    Hi All,

    Our client wants to be able to add some BI content to the Payables > Invoices page in Oracle Fusion Financials Cloud. Ideally they would like to add their own custom Infolet-like report to this page, but I am not sure this is possible...

    I was thinking that a potential option would be to use the Page Integration wizard to add a new tab to the Payables > Invoices page and include a custom BI report that displays the desired information.

    I have setup the tab in the Page Integration wizard and have confirmed that the new icon appears to the left of the Payables > Invoices page. However, when I go to Customize Page and select 'Add Content', it is not providing me with the option to select a report from the Oracle BI Presentation Catalog.

    - Does anyone know if we can embed BI content on this page?

    - Does anyone have any guidelines on exactly which pages we can add/embed BI content to in Fusion Cloud Applications?

    Thanks,

    Richard

  • Richard Beet
    Can BI Publisher Enterprise on-premise connect to Fusion ERP...1
    Topic last edited September 11, 2019 by Richard BeetRed Ribbon: 250+ Points, tagged Reporting in Oracle Analytics public
    Title:
    Can BI Publisher Enterprise on-premise connect to Fusion ERP Cloud?
    Summary:
    Can BI Publisher Enterprise on-premise connect to Fusion ERP Cloud?
    Content:

    Hi All, 

    Is it possible to point at Oracle ERP Cloud (SaaS) as a data source from an on-premise instance of BI Publisher Enterprise?

    Thanks,

    Richard

  • Richard Beet
    EPBCS Capital - Calculate Depreciation on Existing Assets2
    Topic posted February 12, 2018 by Richard BeetRed Ribbon: 250+ Points, tagged PBCS, Planning in Enterprise Performance Mgmt > Planning public
    Title:
    EPBCS Capital - Calculate Depreciation on Existing Assets
    Summary:
    Calculating depreciation on Existing Assets with a Purchase / In-Service Date in the past
    Content:

    Hi All, 

    We have an issue in calculating depreciation on Existing Assets with a Purchase / In-Service Date in the past.

    e.g. if the current Fiscal Year is FY18 and we import an Existing Asset with a Useful Life of 5 years that was purchased and put into Service 1 year ago in FY17, we need the application to calculate the Net Book Value for the remaining 4 years of the asset's life. 

    If the Purchase / In-Service is in the past, the depreciation does not calculate. 

    Anyone with any advice on loading Existing Assets into the EPBCS Capital framework?

    Thanks, 

    Richard

  • Richard Beet
    EPBCS Workforce - UK Employer NI Tax3
    Topic posted February 12, 2018 by Richard BeetRed Ribbon: 250+ Points, tagged Workforce in Enterprise Performance Mgmt > Planning public
    Title:
    EPBCS Workforce - UK Employer NI Tax
    Summary:
    Calculating UK Employer NI Tax within Workforce
    Content:

    Hi, 

    Our client requires the UK Employer NI Tax adding to their Workforce Framework. 

    As there are certain thresholds associated with the tax, i.e. taxable at 13.8% for those employees over the age of 25, and that the 13.8% only applies on the difference between basic salary and the tax free allowance (circa £8000), we cannot see how the out-of-box tax calculations will work for our UK-based customer. 

    Does the Workforce framework deliver an out-of-box calculation for UK Employer NI rather than having to go down the route of creating a custom formula? Anyone else encountered similar issues in calculating UK tax within Workforce? 

    Thanks, 
    Richard 

  • Richard Beet
    OTBI: Find the number of Working/Business Days between two...4
    Topic last edited July 19, 2017 by Richard BeetRed Ribbon: 250+ Points, tagged Analyses, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports in General OBIEE public
    Title:
    OTBI: Find the number of Working/Business Days between two dates and exclude Public Holidays
    Summary:
    OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holidays
    Content:

    Hi All, 

    My client is an Oracle Fusion SaaS customer and are currently developing a number of reports in OTBI. 

    They have a requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holidays. 

    I have two logical OBIEE formulas that exclude Weekends, both of which seem to be working fine, and I have pasted them below. The big issue we've got is excluding Public Holidays from this calculation. 

    Is there any way of doing this in OTBI for Fusion Cloud customers?

    Are there any custom calendars we can create in Fusion and map into our OTBI subject areas?

    Formula 1 to exclude weekends:

    -TIMESTAMPDIFF(SQL_TSI_DAY,TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFWEEK(TIMESTAMPADD(SQL_TSI_DAY, 5, "- General Information"."Invoice Entered Date"))-1),TIMESTAMPADD(SQL_TSI_DAY, 5, "- General Information"."Invoice Entered Date")), TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFWEEK(TIMESTAMPADD(SQL_TSI_DAY,6,"Payables Payments - Payment History Real Time"."- Payment Information"."Check Date"))-1),TIMESTAMPADD(SQL_TSI_DAY,6,"Payables Payments - Payment History Real Time"."- Payment Information"."Check Date")))/7*5+ MOD(7-DAYOFWEEK("Payables Payments - Payment History Real Time"."- Payment Information"."Check Date"),6)+CASE WHEN DAYOFWEEK(TIMESTAMPADD(SQL_TSI_DAY, 5, "- General Information"."Invoice Entered Date"))-2>5 THEN 5 ELSE DAYOFWEEK(TIMESTAMPADD(SQL_TSI_DAY, 5, "- General Information"."Invoice Entered Date"))-2 END

    Formula 2 to exclude weekends:

    CASE WHEN DAYOFWEEK("Submission Dates"."Submission Created Date") > DAYOFWEEK("Submission Dates"."Offer Accepted Date") THEN CASE WHEN DAYOFWEEK("Submission Dates"."Submission Created Date") = 7 THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Created Date", "Submission Dates"."Offer Accepted Date") - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Created Date", "Submission Dates"."Offer Accepted Date")/7)*2)-1 ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Created Date", "Submission Dates"."Offer Accepted Date") - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Created Date", "Submission Dates"."Offer Accepted Date")/7)*2)-2 END ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Created Date", "Submission Dates"."Offer Accepted Date") - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Created Date", "Submission Dates"."Offer Accepted Date")/7)*2) END

    Happy days for excluding weekends... but how can we account for and exclude Public Holidays too?

    Thanks, 

    Richard

  • Richard Beet
    Fusion Cloud - Where do Fusion BI Publisher report outputs...
    Topic last edited September 11, 2019 by Richard BeetRed Ribbon: 250+ Points in Oracle Analytics public
    Title:
    Fusion Cloud - Where do Fusion BI Publisher report outputs get saved to by default?
    Summary:
    Fusion Cloud - Where do Fusion BI Publisher report outputs get saved to by default?
    Content:

    Hi All,

    My client is a Fusion Applications Cloud R12 customer. What I am trying to get to the bottom of is... where do Fusion BI Publisher report outputs get saved to by default?

    In EBS we ran Concurrent Jobs that generated an output, which would result in a record being created in the FND_CONC_REQ_OUTPUTS table. I also believe the actual output file was stored in a directory on the Oracle Server?

    What is confusing me slightly is that with Fusion BI Publisher, a connection to an Oracle provisioned UCM server has already been configured by default: FA_UCM_PROVISIONED. Early in the project we were experiencing issues with running some BI Publisher reports from ESS Jobs (we were seeing Remote Region Errors), which was resolved by virtue of Oracle bouncing the UCM server.

    So, when we run a BI Publisher report in Fusion Cloud, does the resulting output get stored in:

    • A directory on the Oracle Fusion Cloud server?
    • As a record in the Fusion database?
    • Or routed directly for storage on the UCM server?

    Wise words greatly appreciated!

    Thanks,

    Richard