OTBI
Discussion List
-
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 63 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 21 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 62 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 471 views 6 comments 0 points Most recent by Becca Edwards Reporting and Analytics for HCM -
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 112 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Person Seniority Real Time not showing resultsSummary: The "Person Seniority Real Time" subject area is not returning any results, even though we're currently using the Seniority Dates V3. Does anyone have a solutio…Martijn van den Berg 22 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Payment History Transaction amount getting doubled OTBISummary: We are selecting columns (Supplier Number, PPR Name, Payment method, Payment number Payment status, Payment History Transaction amount, Payment History Transact…Panduleni Kadhepa 31 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Summary Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Content Hi AllWe have a requirement to build Employment letter, letter is in …Naveen Jayaraman-48236 25 views 8 comments 0 points Most recent by Bhardwaj Yash Reporting and Analytics for HCM -
Select highest value only for duplicate rowsContent I have a table of data in OTBI but some employees have duplicate rows. This is because they have 2 different values in a certain column. For these employees, how…
-
Deeplink for labor distribution scheduleIs there a deep link available for the labor distribution schedule? I am developing a custom dashboard to assist the team in monitoring labor distribution activities and… -
Deeplink to Inquire on Detail BalancesSummary: We want to link from a BI Publisher and OTBI Report directly on the Inquire on Detail Balances Page with filled out parameters. It should be the same like it is…Yves Chassein 86 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Report to get list of all ESS jobs scheduled in FusionSummary Looking for a resuable report or query which can fetch details of all scheduled ESS jobsContent Looking for a resuable report or query which can fetch details of…MandeepKGupta 3.1K views 16 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
The PO E-Mail notification cannot be delivered to the recipientsSummary: When all buyers create PO's, all suppliers can't receive PO email notification and send an email to the buyers as shown in the image below Hope to get a solutio…