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.5K views 87 comments 10 points Most recent by ERP & EPM Cloud -
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… -
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… -
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Documents about multiple reporting tools in Fusion and their usesSummary: There are several reporting tools available in Fusion (OTBI, BIP, FRS, FDI etc.). Is there any document available from Oracle which helps explain when these too… -
Is there a function to get lookup meaningsSummary: I am creating a report and the users require the displayed values for the lookups, I know I can do multiple links to the fnd_lookup_values_vl view (see code sni…
-
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …
-
Requirement to have 7 buckets in Customer Statement reportSummary: Client requires 7 buckets in Customer Statement Report. We have defined a statement aging method to have 7 buckets but only 5 buckets are visible in the report …
-
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
I Cant find the Flexfield AR_CASH_RECEIPTS in OTBIContent Hi All, I did add Descriptive Flexfield to account receivable - Receipt Screen - under Additional Information ( global segment - Descriptive Flexfield name ( AR_… -
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…
-
create customer statements ESS job output in Excel formatSummary: Requirement is to generate Statements in PDF and Excel format for the standard ESS job "Create Customer Statements". No option to select output type as Excel. A…
-
LUHN check digitHI All We use LUHN check digit part of the check numbers and transaction numbers extract from ERP to the client payment systems. This is a common requirements in the pay… -
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne…
-
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc… -
Joint Venture Setup and Contributions AnalysisSummary: It seems there is only an OTBI subject area for the Joint Venture module Transactions and Distributions details. There does not seem to be a way to report on an… -
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct…
-
campaign emails are still not being delivered to employeesSummary: Hi Team, I am facing an issue with HCM Communicate campaign email delivery in our DEV environment. I created and activated the campaign successfully, scheduled … -
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…
-
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…
-
Send Dunning Letter Job getting errored out while trying to load new templateSummary: Hi Team, Send Dunning Letter Job getting errored out while trying to load new template. Attached the error details. Thanks. Vidhya Content (please ensure you ma…
-
Missing time cardWe would like to see missing time cards. We have specified Compliance also and existing report related to compliance OTBI gives time entry is missing if anyone creates a…
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…
-
Guidance for copying seeded report for customizationSummary: As someone new to OTBI, I'm hoping to copy a seeded report (Payables Trials Balance Report) to run for specific vendors. I've copied the report, but don't know …
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…
-
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running Import Oracle Fusion Data Extensions for Transactional Business Intelligence for pillar ERP. The process completes in Warning and logs: BI extend…
-
In reports and analytics, from which table I can get engineering change order approver's name?Trying to get this info to build a report for the customer. Table EGO_CHANGE_ACTIONS_B is supposed to show the change events, but independently of the event, it always g…
-
Can the column count of each BICC extract be captured?Summary: We have an ask from audit to confirm that each BICC extract contains the complete dataset for a period of time and that no data was missed and that the file is … -
Add "manage autopost criteria" to task panelSummary: In Oracle Fusion Financials, we need to add "Manage Autopost Criteria Set" to task panel for the standard role "General Accounting Manager". I mean I create a c…
-
Redwood Impact for Oracle Cloud FinancialsWe have been working on the HCM side for the Redwood updates and wanted to confirm the impact that Redwood will have on the Oracle Cloud Finance side. Please let us know…