Posts

Posts

  • Amar
    How to avoid special characters from rtf2
    Topic posted September 11, 2019 by AmarBlue Ribbon: 750+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    How to avoid special characters from rtf
    Content:

    How to avoid new line feed coming as special symbols from rtf template.?

    Ex.. text entered to item description from application is like 

    line 1. <no text> press Enter
    Line 2. 'Amarnath(..)' then press enter..

    the output coming as below

    Amarnath(...) <then>
     )?>

    Note: XML file doesn't have special chracters, it is occuring from rtf template.

    Regards,

    Amar.

     

     

    Version:
    11.1.1.9.0
  • Jennifer Bruce
    Procure-to-Pay RT subject area - approver name1
    Topic posted September 6, 2019 by Jennifer BruceBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Procure-to-Pay RT subject area - approver name
    Summary:
    Procure-to-Pay RT subject area - approver name
    Content:

    I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject area didn't exist when I wrote my initial reports, so they currently run in BIP across the following tables:

    "FUSION"."POR_REQUISITION_HEADERS_ALL" "POR_REQUISITION_HEADERS_ALL",
     "FUSION"."POR_REQUISITION_LINES_ALL" "POR_REQUISITION_LINES_ALL",
     "FUSION"."HZ_PARTIES" "HZ_PARTIES",
     "FUSION"."POZ_SUPPLIERS" "POZ_SUPPLIERS",
     "FUSION"."GL_CODE_COMBINATIONS" "GL_CODE_COMBINATIONS",
     "FUSION"."PO_LINE_LOCATIONS_ALL" "PO_LINE_LOCATIONS_ALL",
     "FUSION"."PO_DISTRIBUTIONS_ALL" "PO_DISTRIBUTIONS_ALL",
     "FUSION"."PO_HEADERS_ALL" "PO_HEADERS_ALL",
     "FUSION"."PO_LINES_ALL" "PO_LINES_ALL",
     "FUSION"."AP_INVOICE_LINES_ALL" "AP_INVOICE_LINES_ALL",
     "FUSION"."AP_INVOICES_ALL" "AP_INVOICES_ALL"

     

    The subject area seems to have most of the information that I need, but I can't see a field for the requisition approver name (we are able to bring this back through our BIP data model).  Has anyone else found it, or is this something that hasn't been made visible in the subject area?  It's a critical bit of information for us, as the requisition approver will be the person being held to account for requisitions created after the invoice date. 

     

    Thanks for any help you can offer

    Jenny

     

     

  • Cristian Betancur
    Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom...
    Topic posted September 3, 2019 by Cristian BetancurRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data Model
    Summary:
    Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data Model
    Content:

    Hi

    I have LACLS Colombia reports into Oracle ERP Cloud. 

    However, they do not show information, because HZ_GEOGRAPHY_IDENTIFIERS_VL view does not show geography code type as I created and associated it to the geography hierarchy. 

    This is SR where we found this issue: SR 3-20756472981 : Error in LACLS Colombia Reports. 

    We want to know if I cannot see information in this view because I have not run any process or I do not have role related with it. 

    Thanks. 

    Cristian.

    Version:
    Oracle Fusion Release 13 19B
  • Nathanael Dryden
    Prompt Variables Not Being Passed
    Topic posted August 23, 2019 by Nathanael Dryden, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, OBI Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Prompt Variables Not Being Passed
    Summary:
    Selections from Prompt variables are not passed
    Content:

    I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas, "Payables Invoices - Transactions Real Time" and "Procurement - Procure To Pay Real Time." In order to provide for user input I have included several prompts in the query with are then referenced as Request Variables in a Prompt built within OTBI. SQL is attached. Unfortunately, when I select an item from the Prompt list, the value does not get passed through to the query (as validated by reviewing the result set and the Manage Sessions screen).

    Version:
    11.1.1.9.0
    Code Snippet:
  • Marybeth Snodgrass
    Supplier Profile syntax has been excluded from the most...5.0
    Topic posted August 22, 2019 by Marybeth SnodgrassBronze Trophy: 5,000+ Points, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper. Ancillary document found
    Content:

    Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most recently been updated to include syntax for all new actions advertised as being delivered with 19c (PDF uploaded, and also referenced in a related post - https://cloudcustomerconnect.oracle.com/posts/cbb022f02b?commentId=276014#276014)

    After much searching and going around in circles, I found a very hidden ancillary document that details how to navigate to Supplier Profile. (PDF uploaded).

     

    As an aside, it would be great if Oracle had one central location in which all white paper documents were located and kept up to date as documents are added and edited. That this support feature is lacking is actually quite incredulous.. 

  • Amar
    OTBI-Parameter-Dependent3
    Topic posted August 19, 2019 by AmarBlue Ribbon: 750+ Points, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    OTBI-Parameter-Dependent
    Summary:
    OTBI-Parameter-Dependent
    Content:

    All-> Can we show the parameter values based on another parameter from OTBI?

    Example: Subject Area: General Ledger - Journals Real Time.

    Parameter 1: Accounting Period Name

    Parameter 2: Accounting Date.

    How to automate accounting Date based on  Accounting Period Name.?

    Regards,

  • Amar
    OTBI - YTD -For - Period Name1
    Topic posted August 14, 2019 by AmarBlue Ribbon: 750+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    OTBI - YTD -For - Period Name
    Summary:
    YTD
    Content:

    All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter?

    Financial Year: Jun-19 to May- 20 and one Adjacent period.

    Ex: When user selects period name as May-19, Then the total Amount from Jun-18 to May-19 should show from that column. Can we achieve this by passing Period Name as a Prameter? because we cannot iterate Period name from and To using OTBI? t

    Even though we pass Period Name as Parameter do we need to calculate based on Accounting Date..?

    Kindly advice.!!

     

    Version:
    11.1.1.9.0 (Build 11.1.1.9.0BIFNDN-FAREL13-BP_LINUX.X64_190422.0800 64-bit)
  • Sumanth Kunimakki sathyamurthy
    View future scheduled ESS jobs in SaaS4
    Topic posted July 18, 2019 by Sumanth Kunimakki sathyamurthy, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, Reports in Reporting and Analytics for ERP public
    Title:
    View future scheduled ESS jobs in SaaS
    Summary:
    We have a requirement to extract the future scheduled jobs for a user.
    Content:

    Test Case: Admin wants to know what are the future jobs scheduled for a user. In case if an employee leaves the company he wants to cancel the future jobs scheduled by that user. Customer is looking for an extract that will show these details.

    ESS_REQUEST_HISTORY table is not giving me the future scheduled jobs, it is giving me the details of already run jobs

  • Senthilrajan Vaithianathan
    Adding extra filters to Infolets (Order Management -...1
    Topic posted July 12, 2019 by Senthilrajan VaithianathanGold Medal: 3,500+ Points, tagged Fusion Procurement reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding extra filters to Infolets (Order Management - Seeded Infolets)
    Summary:
    Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'
    Content:

    Currently the system allow users to filter and view Infolet data based on the values you can select in 'View By' prompt (Source System) in Order Management landing page, we want to add additional filter criteria's like Buyer, Business Unit, Supplier, Sales Channel etc...

    Navigation

    Oracle Fusion --> Spring Board --> Order Management --> Order Management --> Filter data in Infolets by selecting 'View By' prompt.

    • How to add a new filter in the Order Management landing page to filter the existing infolet data based on 'Sales Channel' similarly like existing filter 'Source System' under 'View By' filter tab?
    • Do we have any other option to filter the Infolet data with these additional filters?
    • Where the Infolets are stored and can we edit those Infolets ?
    Version:
    Oracle Cloud Application 19B (11.13.19.04.0)
    Image:
  • Ratna Elete
    OTBI Custom Report Scheduling -- Date Parameter Increment1
    Topic posted July 1, 2019 by Ratna EleteBlue Ribbon: 750+ Points, tagged Fusion Procurement reporting, OTBI in Reporting and Analytics for ERP public
    Title:
    OTBI Custom Report Scheduling -- Date Parameter Increment
    Summary:
    How to increment date parameter to run with sysdate for Scheduled OTBI report
    Content:

    OTBI Custom Report has PO Date which is a parameter with in between operator  to choose 2 values

    1.  From-Date = Defaulted to '01-01'2017'

    2.  To-Date = Sysdate.

    Users should have the flexibility to choose the values when run on adhoc but when scheduled it should run from '01-01-2017' to current_date.

    I used 'Procurement-Procure To Pay" subject area.

    I also found this note on metalink "Fusion OTBI: How To Use System Date & Auto Passing Of Dates In OTBI Report (Doc ID 2103487.1)"  but I did find some notes from previous posts on the similar topic where the control is on the parameter itself than on the filter as mentioned in the above KM but looking for suggestions too

    Please advise.

     

    Thanks,

    Ratna

     

     

    Version:
    19B