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
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.7K views 87 comments 10 points Most recent by ERP & EPM Cloud -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Where can I get OTBI sample seeded financial reports?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…
-
Financial Reporting Center - Define Tags (GL_FRC_USER_ACCESS_REPORT_TAGS)Summary: Is anyone using the GL_FRC_USER_ACCESS_REPORT_TAGS table in a BI Publisher report? How are tags defined? https://docs.oracle.com/en/cloud/saas/financials/26c/oc… -
How to add dynamic logo to an OTBI analysis ?Summary OTBI Analysis & Dynamic LogoContent Good People, Is there anyway we can add dynamic logo to an OTBI Analysis ? Thanks, Soumya -
Facing performance issue with a query on gl_periods and per_calendar_events tables.On Fusion ERP I have a BIP report with complex query which involvers among others GL_PERIODS and PER_CALENDAR_EVENTS tables. Report parameters are GL Period From and GL … -
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust…
-
Clarification on Oracle AI Vector Search support within Fusion OTBI, FR and BI Publisher reportsWe are seeking clarification on the use of Oracle AI Vector Search (Vector Database capabilities) within Oracle Fusion reporting solutions. Specifically, we would like t…
-
Query to fetch the report columns name in oracle fusion.Is there any query to find the Report columns Name , Report Path, Report Name Oracle fusion. There are various kinds of report present in the instance such as BI report …
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.
-
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…
-
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …
-
Guidance Required – Executing Dynamic SQL in Oracle BI Publisher ReportSummary: We have a requirement where business users will maintain extract configurations through a custom Oracle VBCS screen. For each vendor, the users will configure d… -
Is there any way to identify the last usage date of a role assigned to a user in Oracle Fusion CloudHi Team, We have a requirement to identify the last usage date of a specific role assigned to a user in Oracle Fusion Cloud SaaS. We are looking for a way to determine: …
-
How to map new custom data model and Separate Remittance Advice template to PPR process.Summary: I have created new custom data model & template and added it in Disbursement Separate Remittance Advice Formats report. But when run the payrun, still output is…
-
Why OTBI Report export into csv does not keep custom formatted date in output csv fileTitle: OTBI CSV Export Does Not Retain Custom Date Format (MM-dd-yyyy) Description: Hi Team, I have developed an OTBI Analysis report and configured the Invoice Date col…
-
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje…
-
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
List of FDI seeded ERP groups and users neededSummary: I need below information for FDI, what are the seeded groups & users, will there be any native user and if any service account is required in FDI for integratio…
-
How to get the Fiscal year budget balance based on accounting period promptSummary: We have an FRS report requirement to display the fiscal year budget amount based on the accounting period prompt selected by the user. We have a source budget w…
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionHow to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO PDF. The …
-
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…
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO …
-
Unable to produce an OTBI report that include Cost Centre DescriptionSummary: Unable to include CostCentre Description in a report in OTBI. I am using Workforce Management - Worker Assignment Real Time subject area as we don't use the fin…
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Uploaded Daily Rates QuerySummary: Need to create a report for the uploaded conversion daily rate in the GL. Content (please ensure you mask any confidential information): Hello, We have a requir…
-
pasteItem2Summary: Which value of flagACL I should use to correspond to the ACL option 'Create'? Content (please ensure you mask any confidential information): Unarchive the BIP c…
-
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu… -
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …