OTBI
Discussion List
-
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running: Import Oracle Fusion Data Extensions for Transactional Business Intelligence Output file shows this error: Why are we seeing these errors?. We a…Bo Tøpgaard 133 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
We want to use OTBI to get the date and time the purchase order was opened.Hello. We want to use OTBI to get the date and time the purchase order was opened. Now, we are using Communication Date column, but it only has the day and not the time … -
OTBI Subject Area for Transaction Tax Determinants in Order ManagementOTBI Subject Area for Transaction Tax Determinants in Order Management -
Transit time for a sales order in OTBIIs there any field available for Transit Time for a Sales Order line (calculated by the system) in OTBI Work Area. We would like to have a OTBI with Order, Requested Shi… -
Innovation Management - Retrieve Attachment DataSummary: We are working in the Innovation Management - Proposal module. Under the Attachment tab of Proposal module, user can upload image attachment(s) by Catergory (e.…Poh Chie 11 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
Innovation Management - how to customize the DefaultReportDataModel and DefaultProposalReportSummary: We are working on the Innovation Management - Proposal module, and the Proposal Action Menu consists of Export function which using the default data model and d…Poh Chie 21 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
How to report P2P transactions approval statuses and current approver?Summary: The aim is to report on the approval status and identify with whom the approval is pending. The subject area Human Capital Management - Transaction Administrati… -
Learning report not working - ORA-01652: unable to extend temp segment by 128 in tablespaceSummary: We are unable to run the attached learning analysis. This analysis was working without any issue and we didn't do any modifications. When we ran it recently it … -
UPDATE RECEIVABLES RECEIPT DFF using APII tried to update receipt DFF with the following Payload: single… -
Risk Matrix in MaintenanceSummary: During one of the discussions with a client who has several offshore platforms, they wanted to know if Oracle has any solution for Risk Managment and scheduling… -
How to default an Order Type when performing Return All TransactionSummary: How to default an Order Type when performing Return All Transaction Content (please ensure you mask any confidential information): We have a requirement to defa… -
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…NusratB 41 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I am looking for the field.Summary: Hi, I am looking for the column/field of "Does not meet the required criteria for the role" in ORC. Content (please ensure you mask any confidential information…Robb 61 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Analysis of employees assigned performance goals and not assigned performance goals for a goal plan?I have created an analysis using the Workforce Goals - Goals Status Overview Real Time subject area. I have selected the following subject areas and applied filters (scr…Adrian Clarke 71 views 2 comments 0 points Most recent by Adrian Clarke Reporting and Analytics for HCM -
How to default the Location of Logged In User in Dashboard PromptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 22 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Locator Name in Receiving - Purchase Receipts Real Time Subject AreaSummary: We have an OTBI report built using the subject area "Receiving - Purchase Receipts Real Time" and we have almost all the required columns except for the Locator…Rahul_M8SG8 21 views 4 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM -
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Is there a way I can concatenate addresses in HZ_LOCATIONS?In EBS, you could call a package (hz_format_pub.format_address()) which would concatenate the address elements when passed the location_id as an argument respective to t…Innovate.Matt 65 views 2 comments 1 point Most recent by Innovate.Matt Reporting and Analytics for ERP -
Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tabSummary Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tab What formula does the system/dashboard uses to calculate the On Time Delivery in …Maria Angelica Mendoza 51 views 2 comments 0 points Most recent by Maria Angelica Mendoza Purchasing -
SCORM ReportingContent Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. Many thanks MelissaUser_2025-02-06-11-18-47-896 34 views 13 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM -
Element Entries Subject Areas Not Working since Patch 24cSummary: We are patch testing 24c and a few of the subject areas are not producing any data. They are functioning correctly in Production, but not where the patch has be…Mark Stoker 211 views 17 comments 0 points Most recent by Danna Spencer Reporting and Analytics for HCM -
Report showing all ElementsSummary Need a report to show all element entries that have been created (Recurring and Non-Recurring)Content HI All, I hope this is a simple ask but I can't seem to fin…User_2025-02-04-08-51-08-912 1.3K views 9 comments 1 point Most recent by Muzaffaruddin Reporting and Analytics for HCM -
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI subject area for Document of Records descriptive flexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we created custom fields within document type and we mapped them in OTBI. Where ca…Valerio Curzi 502 views 6 comments 0 points Most recent by Becca Edwards Reporting and Analytics for HCM