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
-
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and… -
Moved: Advanced Search hyperlink within LOV for VBCS screenThis discussion has been moved. -
Unable to retrieve information stored in the user session variables can be retrieved via SQLSummary: We are creating custom infolets and deploying them on the landing page as a part of our implementation. These infolets have parameter prompts. We wanted to popu… -
AFLOG enabled at site level post 23DSummary: We see that AFLOG profile option is enabled at site level in all of our environments post 23D update by Oracle. We would like to know if this change was done as… -
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' … -
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C… -
Alert or Notification for sandbox mode in oracle erp cloudSummary: Hi Team, wanted to know if there is any alert or notification configuration available in ERP Cloud to notify if a particular user login in sandbox mode reaches … -
How do I connect SmartView to ERP Cloud?Hi, It's been a long time. In the past when Cloud ERP was fairly new(4yrs ago). I remember on a project we connected SmartView to Cloud ERP. If I remember right, ERP spi… -
OTBI Remove All Rows SummarySummary: Content (please ensure you mask any confidential information): When exporting an OTBI analysis in the format of xlsx, the last row is a merged and centered tota… -
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i… -
I couldn't find the user entities that included the work structure dataSummary: I used HCM extract to extract person assignment and work structure data, but I couldn't find the user entities that included the work structure data (position,l…Salma Mohamed Salem 41 views 1 comment 0 points Most recent by Simona Chircu - Support Oracle-Oracle -
Default user name in ESS job parameter LOVSummary: We have created custom ESS job to invoke OIC integration using datamodel type - http. We need to pass logged in user's user_name as query parameter to integrati… -
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when … -
What is Retention period for audit trail reportSummary: We wanted to know the retention period for audit trail report. Content (please ensure you mask any confidential information): Version (include the version you a… -
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Moved: Trying to submit HCM extract but no run results appear.This discussion has been moved. -
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha…
-
Oracle Fusion Cloud Financials 24A patch scheduling detailsSummary: Please suggest on the scheduling of Oracle Fusion Cloud Financials 24A patch. Is it going to be applied in may along with 24B patch? Content (please ensure you … -
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ? -
Conflict in defenition of Finance and HR business unitsRegarding Finance and HR business units: there is a Conflict between HR and erp team about the definition of business unit. Given the following what would be the best pr… -
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co… -
Moved: Need help for getting Average cost of an item column in OTBI Subject areaThis discussion has been moved. -
OTBI Analysis Subject Area to Extract Employee Data for Customer CreationSummary: What subject area(s) can be used to extract a list of Employees created in HCM who have not yet been setup as Customers in Receivables? Content (please ensure y… -
Custom FolderSummary: We have created a folder named "Reports " - it is not in the custom folder - will this folder be preserved when doing an upgrade or do we need to put all custom… -
How can we identify the list of BIP/scheduled reports that are currently being transmitted to FTPSummary: We need a list of reports from Fusion that are currently being transmitted to the FTP server as part of the requirement to transition to a more secure SFTP serv… -
General journals - transaction IDSummary: Hi all - within OTBI is anyone able to let me know where I can find a transaction ID or a global GL transaction number or similar? I'm trying to add it into an … -
Discard the email addresses of all customers in our lower test instance in ARSummary: We are currently seeking a solution to discard the email addresses of all customers in our lower test instance. The objective is to prevent any email triggers d… -
Moved: OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI t…This discussion has been moved.
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide… -
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I …