To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
End User gets the option of EDIT for custom OTBI reportSummary: Hi Team, We created and OTBI report using General Ledger -Journals real time subject area, In the permissions window we have given full access only to BI admini… -
How to connect General Ledger Tables to AR Cash Receipts Tables?I'm trying to build a report that includes GL data and AR Cash Receipts data. I've figured out how to connect the GL_JE_BATCHES table to the XLA_DISTRIBUTION_LINKS table…
-
Intercompany Payable and Receivable representation in FRS reportsHi, Currently we are maintaining only one natural account for Intercompany Receivable and Payable. In other terms, if the account has a positive balance, it will be cons…
-
Rest API/SOAP API to check if particular folder exists on analytics catalogHi Team, I am searching for API to check 1.if a particular folder exists on particular path 2.to upload/replace a folder in BIP Please help me out if there are any?
-
Need to fetch user preferred date format for excel templatesDescription: We need to incorporate the user-preferred date format in Excel reports. Please refer to the attached screenshot of the UI from which the date format needs t…
-
FRS Report not displaying any output (Blank screen on execution)Summary: While executing the FRS report for a specific accounting period, the output page appears blank despite correct parameter selection and confirmed data availabili…
-
sample xml file to add column for workflow email notification not workingSummary: sample xml file to add column for workflow email notification not bringing columns to add to the email notification report Content (please ensure you mask any c…
-
Procure To Pay real time Subject Area issuesSummary: Need help to triage Procure To Pay real time Subject Area issues Content (please ensure you mask any confidential information): I am currently validating the da…
-
Need SQL Query to Extract Seeded and Custom Audit Report DetailsHi Team, I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the follow…
-
Is there any table that stores user categories and password policy in fusion ERP?Hi, Can I create a BI report where I would be able to fetch the User Categories and Password Policy details in Oracle Fusion. Regards, Jahnavi
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:
-
Embed new UAE dirham currency symbol in oracle query or PDF reports (Fusion BI Publisher)Dear All, we need to embed the new UAE dirham currency symbol in all our report outputs. So far what we know is no Unicode or AASCI character is available for the same. …
-
Can we populate currency based on the ledger currency in FRS Report in Oracle FusionHi, We are currently building a financial report using Financial Reporting Studio (FRS) in Oracle Fusion/ERPCS, and we are exploring options to dynamically populate the …
-
Getting an error when trying to add another column in OTBI Rep for a DFFSummary: There is a custom field (DFF) on the Customer Sites (Receivables) which we are trying to add to an existing OTBI Report. After adding it to the report, getting …
-
custom customer master reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Oracle pbcs report (drill down support)Hi, I’m creating a report in the Reports section of Oracle PBCS. I’ve added the zoom option to enable drill down on the data. Currently, in the column for the Total dime…
-
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single Row
-
How to control or restrict OTBI access?Summary: We need to control OTBI access from accidental deletion of a folder/report and moving reports from one folder to another from business users? Content (please en…
-
Lease Accounting - Generate Full Amortization Schedule on DemandHi ERP Reporting Gurus! I'm trying to build a report that effectively recreates the full lease detail report that is generated when you create the lease or make an amend… -
OTBI display duplicates while query don'tHi everyone, We use OTBI to extract some data in Excel to feed an home-made FBDI requisition process. The report included 11 queties, linked by their record_number to ge…
-
Oracle fusion FDI in data actions How to provide the authentication for REST APII'm trying to get the invoice attchemnt url in FDI using data actions type HTTP API by call the REST API. but facing an issue to authenticate the REST API. We have enabl… -
How can we pull last day of current month in eText templateSummary: How can we pull last day of current month in eText template Content (please ensure you mask any confidential information): Hi Team, Our bank wants last day of m…
-
Copied/Renamed OTBI Report Not Showing in Scheduled Process ListI copied an out-of-the-box OTBI report to my custom folder and renamed it. However, when I try to run it from Scheduled Processes, the report doesn’t appear in the list …
-
Report Rendering Failure – IO Exception "19 >= 19"Summary: Hi, We're encountering a rendering issue with a BI Publisher report in our Oracle Fusion environment. Upon execution, the report fails with the following error:… -
How to print prompted value as a header text in FRS report?In a custom FRS Balance Sheet report I have a requirement to print the prompted values as a selected parameter in the header section as a text value. Also I want to show… -
Is there anyway to extract Essbase cube data to connect with Powerbi beside smartview File?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …
-
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report History
-
Delivery Filename in BIP Bursting definitionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to perform drill-down directly within an Oracle PBCS report?Hi, I’m working on Oracle PBCS in the Reports section and I was wondering if it’s possible — and if so, how — to enable drill-down functionality directly within a report…