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
-
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 -
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 …
-
Swift code for bank in fusionContent Where to provide Swift code for Banks in fusion? In EBS R12, SWIFT Code is entered at bank branch level and it should be entered in the field "Bank Identificatio…
-
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…
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
Customizing Data Model for GL and Subledger Account Analysis Report – Add/Remove ColumnsHi Everyone, Has anyone customized the data model for the General Ledger and Subledger Account Analysis Report in Oracle Cloud ERP? I'm looking to add new columns and po…
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…
-
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…
-
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…
-
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…
-
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…
-
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…
-
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…User_2025-02-10-15-12-48-631 265 views 4 comments 0 points Most recent by Global Customer Support | ASE-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…
-
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 ? …
-
Internet Speed requirements for Oracle ERP/HCM Cloud for connectivity through cell phone network 4gSummary What is the minimum speed required to connect Oracle ERP/HCM Cloud using cell phone network 4g?Content With more people working remote or work from home because …
-
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…
-
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…
-
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…
-
Need BICC PVO to get per_location_details_f tables Additional attributesSummary: Need BICC PVO to get per_location_details_f tables Additional attributes Content (please ensure you mask any confidential information): Version (include the ver… -
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…
-
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…
-
FRS Report is opening in multiple tabs for some users and not for others. Is there a specific setup?Hello, We have created a consolidated FRS report for one of our clients and when the user downloads the report, it opens in multiple tabs in excel for one users. For oth…
-
Assistance required to create Requisition Bucket with Bar graphHello, I am seeking assistance in developing a Requisition Aging Bucket in OTBI. The goal is to create a bar graph to present summarized requisition data on a dashboard.…
-
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… -
Fixed Assets Report Showing Data from Financial Book but Not from Tax BookWhen generating a Fixed Assets report, the output displays information from the Financial Book, but no data appears from the Tax Book. Could this issue be related to a m…
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…
-
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…