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
-
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… -
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
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…
-
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 … -
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 … -
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…
-
Iam trying to customize the existing standard Supplier Balance Aging ReportIam trying to customize the existing standard Supplier Balance Aging Report where i want to same and export sample data by inputting parameters against the same data mod…
-
Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher ReportSummary: Hi , I have a specific query regarding the feasibility of a dynamic feature: Is it possible to enable a function in BIP's RTF/Excel template where, upon clickin…
-
Transactions coming from external systemsHi We are defining lets say a tax rate 20% and not mentioning whether its inclusive or exclusive at the setup level. If transactions are coming from interfaces, is their…
-
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.
-
Oracle Analytics Cloud (OACS) Training for a BeginnerSummary: Oracle Analytics Cloud Training for a Beginner Content (please ensure you mask any confidential information): Hello, Can anyone recommend training or resources … -
Can we triggle process in OTBI dashboard?Summary: Can we triggle process in OTBI dashboard? Content (please ensure you mask any confidential information): For example, can we triggle "Create Accounting" process…