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.8K 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… -
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …
-
The expiry period for Email NotificationsSummary: Hi, I would like to understand the expiry period for email notifications received for approval requests in Oracle Fusion. When users receive an approval email, …
-
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…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
SQL Query or table for User CategorySummary SQL Query or table for User CategoryContent I need to create a query that extracts the information of the user and the user category it's under
-
line managers are unable to view any data from my team - team skills centerSummary: line managers are unable to view any data from my team - team skills center although one of his directs has skills data be he is even unable to view his directs…
-
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o… -
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi…
-
Is event organization missing from subject area Project Billing - Event Real Time??I can't find it in the list of fields available, but it seems a bit odd for the event organisation to be missing. It also seems to be unavailable to add to View Columns …
-
Job Set in Cloud Financials, how to copy report parameter values from one report to the next report?Summary: We defined a custom Job Set for two Cloud Assets reports, Asset Additions Report FAS420 and Journal Entry Reserve Ledger Report FAS400. When running the job set…
-
what is column for Taxpayer Identification Number (TIN) for customers in OracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…
-
What are the differences between Enterprise Set and Common Set?Summary: What are the differences between Enterprise Set and Common Set? Content (required): What are the differences between Enterprise Set and Common Set? Version (inc…
-
Replicating a few dozen Fusion tables to ADB for heavy reporting: what worked and what brokeThere was an error rendering this rich post.
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
BI Publisher empty column missing from csv outputSummary: 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 customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…
-
Understanding the 'Disallow Previous Password' in Oracle fusion ERP password policy setupSummary: We are enabling the password policy in our system and needed to understand below regarding the field 'Disallow Previous Password' in password policy setup: How …
-
sql query to fetch bank account details that are linked to supplier addressSummary: Hi all, I would require an sql query to fetch bank account details that are linked to supplier address levle Content (please ensure you mask any confidential in…
-
Need Lease Accounting White Paper and DocumentationSummary: Hi Team, could you please share the latest Lease Accounting white paper for Oracle Fusion Cloud or guide me to the appropriate documentation? Your assistance wo…
-
How to create a custom table in Oracle fusion SAASSummary: How to create a custom table in Oracle fusion SAAS Content (please ensure you mask any confidential information): How to create a custom table in Oracle fusion … -
ERP Finance: Do we have any subject area that represents the data in XLA_ACCOUNTING_ERRORS tableSummary: We would like to understand is there any subject area that showcases the create accounting warnings/errors, majorly looking for XLA_ACCOUNTING_ERRRORS. MESSAGE_…
-
Dynamic Deep Link URL in BI Publisher Report not workingSummary: I have a RTF template that shows details of AR Invoices. I have inserted a link on Invoice Number to take the user to the transaction in the application using D… -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
Add Supplier and PO Total Amount in Approval WorklistSummary: Creating an Idea tag field is not display a selected list
-
How can i suppress report parameter by hardcoding the valueSummary: How can i suppress report parameter by hardcoding the value Content (please ensure you mask any confidential information): How can i suppress report parameter b…
-
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. … -
How to call a OBTI dashboard from Page Entry (Structure in Sandbox)Summary: I try to do this. But URL is https://fa-etfp-test-saasfaprod1.fa.ocs.oraclecloud.com/FSCMAnalytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FCustom%2FReport%20Da…
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…