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
-
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.2K views 79 comments 9 points Most recent by Pratiksha Sawandkar -
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… -
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… -
customize a seeded dashboard with otbiSummary: I want to add three parameters in trial balance report which is a seeded dashboard I have customized it but not able to add the parameters that are cost center …
-
Encountering below error while adding Segment Description columns.Summary: Encountering below error while adding Segment Description columns. State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFSer…
-
Feasibility check: OTBI report for supplier registration resubmissionsSummary: Hi Team, We received a customer requirement to understand which suppliers have the most difficulty during the supplier registration process, along with their vo…
-
Access restriction for userSummary: Access restriction for user Content (please ensure you mask any confidential information): Hi, Would like to restrict user that normal user - only can read and …
-
GL Transaction - OTBISummary: We are exploring an OTBI alternative, or reviewing the limitations within the subject areas, as a result of ongoing issues with the current report in BI publish…
-
Audit report for Assets: Asset Source LinesSummary: We want to know if we enable Asset Source Lines , will it impact system performance (based on audit report records). Looking for list of audit objects & descrip…
-
Prune Time for Hourly BICC ExtractsSummary: We have BICC Extracts running hourly and prune time set to 60. But the downstream applications have issues with the number of duplicates generated in every run.…
-
Issue With Notification Templates - Logo Breaks Approve, Reject, and Request Info ButtonsSummary: Editing the Logo in the Workflow Notification Subtemplate referenced in other notification reports e.g. Journal Approval Notification Report causes the approve/…
-
Procurement - Procure To Pay Real Time subject area: No data showing for Invoice MeasuresSummary: No data is coming for Invoice Measures for few users. Content (please ensure you mask any confidential information): Hi, OTBI report has been built using "Procu…
-
Person Number column is blank when creating an analysis using Project Costing Subject AreaSummary: Wehave created a report using the Project Costing Actual Costs Real Time subjectarea. In that report we have selected the Person Number and Person Name fields,b…
-
where can we find the PDF document OTBI_Cross_Subject_Area_Reporting_Guidelines ?Summary: this document is mentioned in few conversations but the link is broken ; Please provide a valid link to the PDF Content (please ensure you mask any confidential…
-
Can you please investigate why we cannot use the permissions against folders in OTBI ?Summary Why we cannot use the permissions against folders in OTBI ? what happens now is: when we got enough access, we can set up a specific permission at a certain leve…
-
Custom template is not reflected in ap invoice approval notificationSummary: Custom template is not reflected in ap invoice approval notification Content (please ensure you mask any confidential information): We've customized the AP invo…
-
How can we change the default template for the ESS Job Print Receivable TransactionSummary: I want to use another RTF for the standard ESS Job Print Receivable Transaction job Content (please ensure you mask any confidential information): Version (incl…
-
Which table store the ESS Scheduled Process frequency, actual schedule start date and end dateSummary: We have requirement to get the ESS Scheduled Process frequency, actual schedule start date and end date details. I have validate the fusion_ora_ess.request_prop…
-
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens…
-
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…
-
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…
-
Require logic to fetch month end exchange rate while generating revenue in Projects Billing ModuleSummary: Urgent!!!!!! Client requires the Revenue in Projects Billing to have month end exchange rate even if the Event Completion date is mid month. Example, event was …
-
Training Suppliers Details OTBI report not providing all the data in the UIHi, I have created the Training Supplier Details OTBI report from Workforce Learning - Learning Management real time subject area. However the records retrieved through …
-
Which FUSION tables OTHER than per_email_addresses per_ldap_users hz_parties store user emailSummary: I need to find the table(s) where user email addresses exist in Fusion. I've checked per_email_addresses,per_ldap_users and hz_parties tables but none of them c…
-
E-Signature BPM Rule for Miscellaneous TransactionsSummary: We have a requirement to configure an Approval BPM rule for Miscellaneous Transactions. Our requirement is as follows: If the transaction type is selected as Mi…
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
Why Relative to Prompt for AccountingPeriod offset by -11 is working fine to get Previous year?Summary: FRS report - Doubt on Relative to Prompt for AccountingPeriod offset by -11 Content (please ensure you mask any confidential information): I am running a report…
-
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in…
-
How to fetch a comma separated string into separate columns in Oracle fusionSummary: We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK". When we have multiple approvers for a transaction and those will appear in the "Ap…
-
"View History" section doesn't work when update bank account number through Personal Payment MethodsSummary: Hi, We are developing a BI Publisher report to monitor changes in various system attributes, including the Bank Account Number. Enabling auditing was a necessar…
-
Merging 12 Business Units into 6 new Business Units. What is the correct setups and proceduresSummary: We have 12 business units that need to be merged into 6 new business units. We are currently utilising AR,AP, GL, CM, EPM and need to understand what is the pro…
-
Can we add Custom P_LANGUAGE Parameter for template translations in fusionSummary: Hi Team, Can we add customer language parameter to select templates and translations based on xliff loaded using language paramter in Oracle BIP. Its working wi…
-
Procurement Procure to Pay real time subject area no data showing on purchase order measurements colProcurement Procure to Pay real time subject area no data showing on purchase order measurements Ordered Amount, Delivered Amount and Open Ordered Amounts User has AP ro…