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
-
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen… -
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …
-
How to create a From-To Account prompt with "Code - Description" list in GL Balances Tree Report?Summary:Need a From-To dropdown prompt showing "Code - Description" sorted by numeric code for a KFF tree report. Content (please ensure you mask any confidential inform…
-
FRS default previewSummary: FRS reports are opening in HTML view by default when "Default Preview Mode" in preferences set to PDF Content (please ensure you mask any confidential informati…
-
Is there a way to get a pop box with a statement on clicking on Save on Create Payables InvoiceSummary: While Creating an Payables Invoice in Classic UI, there are fields like Invoice Currency and Payment currency, so when user enters the same currencies in both t…
-
Approach to accurately identify active reports in Oracle Fusion CloudWe are trying to build an accurate inventory of all custom reports used in Oracle Fusion SaaS, including BI Publisher (BIP), OTBI, and Financial Reporting Center (FRC) r…
-
Can we build a custom report or dashboard in FDI to view requisitions by locationSummary: Can we build a custom report or dashboard in FDI to access and view requisitions by location? Content (please ensure you mask any confidential information): Hel…
-
CoA Hierarchies in GL Balances Real Time Subject AreaSummary: I need to be able to show both the code and description in the CoA Hierarchies in the GL Balances real time subject area. From what I can tell, the detail level…
-
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is …
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…
-
Query to bring the BU to which a Customer Account Site is associated toSummary: Content (required): I need a query to retrieve the BU name associated to the Account Site . Thanks. Version (include the version you are using, if applicable): … -
How to set parameter in BICC job payload from SOAP UI to set the extract date ?We are calling BICC job from OIC for a particular PVO ,it gives us incremental data every time. Is there a process to reset it to full extract in every run. -
unable to find the ESS Job while creating Request setSummary: Hello, We are creating a request set for an ESS Job. But while creating the request set the ESS Job name is not able to see. Kindly suggest on this for possible…
-
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically …
-
Is there a REST API to get the submission and completion time details of an ESS Job ?Summary: Is there a REST API to get the submission and completion time details of an ESS Job ? Please provide pointers if available. Dhruv -
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
Audit Trail in Procurement and Self Service ProcurementSummary: Currently in Procurement its possible to see only Supplier Audit History. Requisiton and Purchase Orders don't have any detailed history data available. Content… -
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 … -
poz_supp_site_requests not having an entry for Supplier Site pending approvalSummary: we have a need to create a BI Report and list all supplier and it's sites that are pending approval on profile changes or any other changes. we try to display p…
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
OTBI Subledger Reconciliation Report with GL - ReportSummary: OTBI Subledger Reconciliation Report with GL - Report Content (please ensure you mask any confidential information): Hello The Company have the below subledgers…
-
Data Extraction Using Read-Only Replicated Data - 26B ReleaseHas anyone successfully enabled the 26B feature: Data Extraction Using Read-Only Replicated Data? (Feature ID: F44066). The step to Enable Security Console External Appl…
-
Mailto links not workingSummary: I am trying to embed a mailto: action link in a report to create an email to a requester where they need to take action, for example where they have an invoice …
-
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm… -
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…
-
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
How can i get the underlining sql query for this PVONeed the backend query for this HcmTopModelAnalyticsGlobalAM.HCMExtractAM.AssignmentBiccExtractAM.AssignmentSupervisorExtractPVO in ISSUE SQL it's not coming for this
-
How to report when a pay batch was approved in Incentive CompensationSummary: I need to create a report for a weekly integration that only will pass data for pay batches that were approved during current week. "Last updated date" is too u…
-
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …