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
-
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… -
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…
-
why the BIP Report does not consider the template while generating the output in CSV Format ?Req : Generate CSV output format with specific column names. Hi Team, I have designed an Etext template for the purpose of generating output in CSV format. Etext Templat…
-
REST Data Source Fetching Only 25 Records in Oracle APEX – How to Retrieve All Records?Summary: I am currently working on building a dashboard in Oracle APEX using a REST Data Source to fetch data from an Oracle Database. However, I am facing an issue wher…
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Asset Rollforward Report ExamplesSummary: Looking for any fixed asset rollforward report examples or suggestions. Content (please ensure you mask any confidential information): We were hoping to create … -
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…
-
How to display the latest value (Contract Agreed Amount)?Summary: I am creating an OTBI report for contracts including the contract agreed amount field. Because the contract has revisions, the contract agreed amount is display…
-
Drill down on balances in SA General Ledger - Transactional Balances Real Timehttps://us.v-cdn.net/6034893/uploads/YZLQDXKKCO5W/sawreport-xmlnssaw-3dcom-siebel-analy.txt Summary: We have created a an OTBI analysis using SA General Ledger - Transac…
-
CDC capabilities of BICC extractsA few questions about the CDC capabilities of BICC extracts, particularly around how they handle deletions and intraday changes - such as multiple status updates occurri…
-
CDC capabilities of BICC extractsa few questions about the CDC capabilities of BICC extracts, particularly around how they handle deletions and intraday changes - such as multiple status updates occurri…
-
Need Support for Missing Notifications in Fusion Expenses: Manager Reject and Audit Complete EmailSummary: Hi, We identified two missing email notifications in Fusion Expenses and need clarification on whether these events are supported as standard functionality: Man…
-
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…
-
Grouping sections in a report created in Financial Reporting Web StudioPlease let us know if it's possible to collapse and expand the report information by section. For example, in this report, we need the accounts listed below the COST OF … -
Create custom role to files in UCMI need the ability to view files in UCM, we have a report which runs via an ESS job but its erroring because users don't have the relevant privileges to access UCM. The …
-
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer… -
Restrict sending attachment in email burstingSummary: We have a requirement that client does not want email attachment to go to the end user and should not be part of the mail body as well. We created a deeplink fo… -
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o…
-
Suppress Outputs from showing under Output & Delivery after burstingSummary: We have a BI report that needs to be scheduled to run. The report will send multiple emails, and it also generates one output which contains summarized detail o…
-
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…
-
Date Incorrect in Report OutputSummary I can't get the date to be correct in the Excel outputContent I have a report that is pulling from the AP tables. The date fields are set to True for Ignore User… -
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…
-
created_by or last_updated_by - how to find username on those fieldsSummary created_by or last_updated_by - how to find username on those fieldsContent in gl.created_by and gl.last_updated_by I get a number or email address. How do i get…
-
Form Personalization Column HideWe have a form personalization requirement to hide the Distribution combination field if the Invoice type is 'Prepayment' from the AP invoice lines in create Invoice pag…
-
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 …
-
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.…
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…
-
List of all seeded reports for SCM , Procurement and Procurement contractsI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…
-
Accounts Payable OTBI AnalysisSummary: Adding a field to an "Analysis" Content (please ensure you mask any confidential information): I would like to add the Oracle assigned file number to the list o…