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
-
Incomplete information in the dashboard Customer Listing ReportSummary: Site Purpose Source Reference field does not always display record information Content (please ensure you mask any confidential information): In the dashboard C… -
Moved: FR WEB: What is the audit option in FR EPBCS?This discussion has been moved. -
How to find the BI reports that are using Excel TemplateHi, Referring to Doc ID 2990643.1, the BI reports that are using Excel Template are getting the corrupted output while scheduling it. Could anyone please let me know is …
-
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
Moved: Period Inventory Valuation Report has no RecordsThis discussion has been moved. -
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
Moved: Manage Internal Supplier Profile Change ApprovalsThis discussion has been moved. -
how to store burden rate details to table gms_ffr_indirect_expensesSummary: Where do data come from for the Federal Financial Report table gms_ffr_indirect_expenses Content (please ensure you mask any confidential information): Version …
-
Moved: Problem of report object after convert from FR report and export to ExcelThis discussion has been moved. -
Can I apply a Receivables Credit Memo while referencing the Invoice Transaction number in FBDI?Summary: While uploading Receivable credit memos via FBDI, I aim to automatically apply open invoices by providing references in the sheet. I'm aware of using the Refere…
-
Why is barcodes not getting scanned in RF-Smart handheld scanner ?We have modified the standard Print Pick Slip report to add a custom template, type RTF and output PDF, and added barcodes to it with IDAutomationC128S as the font style…
-
Arabic text not displaying properly when generating pdf outputSummary: Arabic text not displaying properly when generating pdf output Content (please ensure you mask any confidential information): Hi Experts, In Invoice Print Templ…
-
How to Join Multiple Subject Area in OTBISummary: Hi All, Need suggestion on OTBI report. Content (please ensure you mask any confidential information): We have requirement to build an OTBI report to show trans…
-
Need a Solution to restrict Parameters with respect to a Date RangeSummary: In the specified business scenario, users are restricted from selecting dates in the "GL Journal Date From" parameter between the 1st day of the month at 12:00 …
-
How do I update the User Distinguished Name?I am working on building a report that references the PER_USERS table in our ERP environment? However, I have noticed that the USER_DISTINGUISHED_NAME column has inconsi…
-
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…
-
Read-only Access for download reportSummary: How to create a read-only access for downloading the report in the Report & Analytic, Schedule Process and Financing Reporting Center? Content (please ensure yo…
-
Line Total Amount field in AR Transaction Real Time OTBI subject area is missingSummary: Could someone please let me know how can I have Line Total Amount field in my OTBI report? Content (please ensure you mask any confidential information): Versio… -
How to display the German Umlaute like, ä, ö, ß in invoice templateSummary: Unable to display the German Umlaute like, ä, ö, ß in invoice template Content (please ensure you mask any confidential information): We have a requirement for …
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en… -
Intercompany Activity in FRSSummary: Intercompany Activity in FRS Content (please ensure you mask any confidential information): Hello - We have a requirement to be able to identify the Intercompan…
-
Unable to find subject area to fetch FAI Required field for OTBI reportSummary: Hi, we have a requirement to fetch FAI Required field but unable to find the subject area for OTBI report. Content (please ensure you mask any confidential info…
-
Moved: ORDER MANAGEMENT ANALYSISThis discussion has been moved.
-
Account is outside of report range message for Receivables to General Ledger ReconciliationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Excel Bursting issues with Payables Payment Register reportSummary: Strange behavior in custom Payables Payment Register report Content (please ensure you mask any confidential information): I have customized the seeded 'Payable…
-
How to implement FTP Bursting for Print Receivables TransactionsSummary: How to implement FTP Bursting for Print Receivables Transactions Content (please ensure you mask any confidential information): How to implement FTP Bursting fo…
-
FRS report Grid IssueI am trying to create FRS report with Grid1 and Grid2. I have lots of columns and detail in Grid1, I would like to copy same detail from Grid1 to Grid2. I am not able to…
-
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…
-
OTBI report for Subject Area Procurement - Purchasing real time giving no dataSummary: We have a custom Buyer role with BI Author and Purchase Order Transaction Analysis Duty role and the required grants on Purchase document header tables. The rol…
-
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…