OTBI
Discussion List
-
-
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …Helen Thomas 22 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
How to create the Deep link for ASN?I want to add the deep link to a BI Report for the ASN. How we construction this ? Best regards Michela -
How to schedule an OTBI report using agent if the report has two dates as prompt?Summary When we schedule this OTBI report with agent, it pulls all data which are not in the range of default valuesContent We have an OTBI report which has "from date" …Linda Huang 411 views 7 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
Headcount and Termination # for Turnover and ESG reportHi there, We are looking for the columns in subject area to display precise headcount and termination number for Turnover and ESG reports. Below are other numbers which …Yiming Xiong 11 views 2 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 21 views 1 comment 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
OTBI scheduled reports are not getting sent to recipientsReports are not getting delivered. Sometimes its just sending email notification but email doesn't stay in mailbox, it gets disappeared.Adeeba Akbar 31 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Maryellen_Gancena 11 views 3 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 118 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
How to achieve Locator level costing for Average costing in Oracle FusionSummary: Hi All, How to achieve Locator level costing for Average costing in Oracle Fusion. Kindly suggest a way to achieve costing details at Locator level Content (ple…
-
-
PO and PR approvers in OTBIWe are trying to make consolidated dashboard for PR, PO and project budget approvers. There seems to be no data of approvers for pending transaction in any subject areas…
-
-
While scheduling a OTBI report, run time parameters are not coming up in General TabSummary While scheduling a OTBI report, run time parameters are not coming up in General TabContent Hi Team, When i tried to schedule a report using OTBI, there are run …Harish Kumar Kovi 84 views 12 comments 1 point Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
Scheduled process listWe would like to know the list of ESS jobs are scheduled with start date, end date and email address of users. Oracle suggested to get the time using Oracle customer con…
-
Primary Beneficiary DetailsSummary: I need to create an OTBI analysis for to get details about one benefit plan including primary beneficiary details. I used the Benefit- Enrollment Real time subj…Ayesha Iroshani 51 views 4 comments 0 points Most recent by Mahesh Sharma Reporting and Analytics for HCM
-
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …
-
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 138 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
OTBI Reports CalculationSummary: Hello, We have resource assignment report and our aim is to join Project Resource Assignment and Worker Assignment, in order to calculate each employee ‘s proje… -
Termination report pulling last compensation of hourly associates but not salaried associatesSummary: Term report pulling last salary of hourly associates but not salaried associates Content (please ensure you mask any confidential information): Hi! I am in need…Ameya_J 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are … -
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
I've set my Prompt, how to I make it so Managers can see them to run their own report?Summary: I'm building custom reports for managers, but when the click on the report they can not pick the criteria they need to narrow the search. What am I missing? Or …
-
CASE WHEN Formula Not Displaying CorrectlySummary: CASE WHEN STATEMENT shows two different results pending the format export Content (required): I'm using the following CASE WHEN statement to label a value eithe…
-
Line Total Amount field in AR Transaction Real Time OTBI subject area is missingSummary: Could someone please let me know how can I have Line Total Amount field in my OTBI report? Content (please ensure you mask any confidential information): Versio…Rahul Kumar Gupta.-Oracle 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Diversity Report - multiple linesSummary How to report on the latest entry?Content Hi, The report attached works for me apart from 8 employees that are appearing with multiple lines of data. I've spoken…User_2025-02-05-22-44-35-842 125 views 28 comments 1 point Most recent by Cindy Hager Reporting and Analytics for HCM -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
Need to know Table names to get the offerings/Learning Initiative details from Learning Module in OrContent Hello All, I am developing a Report from Learning Module in Oracle Fusion HCM. I want to know the below details ,Please guide : 1) In OTBI Report: - i am using W…kanchana venkatasubramanian 1.7K views 3 comments 0 points Most recent by Kiran-HCM-Oracle Taleo Learn