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
-
Analysis - SQL expressionSummary: How to get first month of previous date - SQL Expression (Criteria ) Content (required): We have created a Analysis report and business needs to schedule this a… -
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe… -
Understanding BI Extender and Import Oracle Fusion Data Extensions for Transactional Business ess joSummary: Hi Team, When using the columns of Entity(Balancing Segments) individually using balances real time subject area, it is generating correct result. However, when…
-
What is SQL Receipt Accounting join to source_id_int_1 column from xla_transaction_entities?Summary: Trying to go from GL through Subledger Accounting to Receipt Accounting in Data Model SQL. Didn't find any documentation or hints on this. Content (required): V… -
Is it possible for an analysis to link to a dashboard prompt?Hello, I would like to link one analysis to the prompts on a dashboard which will then update another analysis. Is that possible? Thank you, Julia Oracle Fusion v23A -
How do I combine multiple subject areas in a one report?I am a Fusion Financial Customer and I am trying to write a simple report connecting Invoices to Payments. I need to include in my report the AP Routing and the Payment …
-
Can I have multiple logos for 1 only income statement FRS report?Kindly find the below: The client want more than one logo used in the same income statement created in financial reporting center is there any way? thanks for help, Rega…
-
is it possible to have access for specific entities in FRS report(income statement)?Dear all, Kindly find the below: the client want to have access in the FRS income statement for each entity to not show all the income statements available in the financ…
-
OTBI Dashboard combining two subject areas of two different modulesSummary: We want to prepare an OTBI dashboard having 2 analysis. First analysis will pull the data from Procurement contracts module for lets say 10 suppliers and then s…
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …
-
How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?Summary: Just like the title says, we are having trouble find that information. I wrote the SQL Below which does return the required information but in XML/BLOB Format. …
-
Disable online Output view for BIP reportsSummary: Disable online output view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report op…
-
Disable online Output view for BIP reportsSummary: Disable online view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report option fo…
-
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment… -
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
View Contract Authoring Party in OTBI?Summary: We are trying to see which contracts were created with an "external" authoring party or an "internal" authoring party, as well as which contracts had the contra… -
Error Code : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Hi All, I created a custom OTBI report. I have used two subject area : Subledger Accounting - Journal Real Time and Payables Invoices- Transaction Real Time The…
-
Moved: BI publisher custom notification needs to be consolidatedThis discussion has been moved. -
Oracle Fusion - Process monitor - Process "NAME"Summary: Hi All, I am working on creating a report to have the list of job failed in a specific date range. I am able to get the required information from the ess_reques…
-
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …
-
Ability to create a Analysis report in OTBI from Manage External fileSummary: Hi How can we implement a process where a third party stores/sends/puts a file in a designated place, and we pull data from that file to create an OTBI report? …
-
Moved: Need to know the Accounting Status identifier from Projects expenditure/costing tablesThis discussion has been moved.
-
How to see DFF fields in the OTBI Subject Area : Procurement - Requisitions Real TimeSummary: New DFF fields were created in the Requsition UI but not found as a field in the OTBI Requisitions Line Detail Content (required): New DFF fields were created i…
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi… -
Subject Area - Payables Invoices - Transactions Real Time - distribution amountSummary: Using Payables Invoices - Transactions Real Time, The Invoice Distribution is getting incorrect amount after adding Overridden account concatenated segments Col…
-
Missing data in some columns in FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVSummary: Hi We can see all our columns in our COA, but there is only data in segment1. What do we need to do in order to see more data? Content (required): Version (incl…
-
Moved: repeate notes for each purchase orderThis discussion has been moved.
-
Customize create accounting jobHi, We have more than 50 ledgers and would like to schedule a create accounting program for all the ledgers. Ledger is a mandatory field while submission of the program …
-
Moved: Customer Aging Report for Secondary IFRS ledger.This discussion has been moved.
-
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…