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
-
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In… -
Send Payslip to Printer For Teminated employeesSummary: Hi Everyone, We have one requirement that we need to send Payslip for only terminated employees to Printer. I have created different template and add in deliver… -
Customizing the standard Negotiation Award Decision Notification doesn't work after upgradeSummary: I customized the standard Negotiation Award Decision Notification by: Adding new columns to the data model and using them in the layout. Adding new sections and… -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…
-
Is there any way to integrate BI Publisher bursting with Fusion’s notification frameworkSummary: We currently use BI Publisher bursting to send report outputs via email to users. This works fine, but we also want the same notification to appear in Oracle Fu…
-
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
Is there any REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM Demo ?I am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us…
-
Help Needed: REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM DemoI am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us…
-
We are having an issue with reports showing with trial balance for mexico report for occasional userSummary: When running the trial balance report for Mexico from the RFC, it does not display any data. This happens with a specific user. What could be the cause? The use…
-
how to update CLOB Column of Custom Object from OIC IntegrationHi, We have a Custom Object and we have create a field with Data Type "Long Text". We are not able to update the value in this field using REST API. We are using below U…
-
How to add filter to obtain prior financial period transactions?How do we create a filter on an OTBI analysis to return the prior financial period's transactions based on current date? Requirement: We need to schedule a report to del…
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…
-
BI Publisher – Unable to Set Default Parameter to Week Start (Sunday) and Week End Date (Saturday)We are trying to configure a BI Publisher report parameter in Oracle Fusion Cloud to automatically default to the start and end of the week Week Start = Sunday Week End …
-
How to remove username as the report owner in the BI Publisher reports.Currently user ABC is owner of /shared folders/custom so most of the content under /shared folders/custom showing ABC as owner. How to remove ABC name as the report owne…
-
Manage Production Calendar Exceptions Calendar TablesI am trying to find the table that saves the registries for shifts exceptions on maintenance production calendars in Oracle Fusion in order to use it for reporting in OT…
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
Does BICC query returns live data?Using the 'EXTERNAL" keyword, does the following BICC query returns live data from Oracle ERP? or uses an offline extracted source? select distinct TransactionEntitySour…
-
Requesting information for User Role Memebership Report for Audit requirementSummary: 1.Has the report design changed significantly (e.g., more than cosmetic changes or addition of fields) since 10/3/2024 ho wto find this information in Oracle ? …
-
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
-
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re…
-
RVIE Report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) Not Showing Any InvoicesHello everyone, I’m currently facing an issue with the RVIE report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) in OTBI. When executing the report for…