OTBI
Discussion List
-
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 85 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 41 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.6K views 3 comments 0 points Most recent by Kiran-HCM-Oracle Taleo Learn
-
Total row should have same color according to the stage respectivelySummary: Total row should have same color based on the stage. Kindly check the screenshot. Content (please ensure you mask any confidential information): Version (includ…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
-
Forecast line additional information doesn't appear in analysisSummary: I have specified some additional information to the Forecast line , and all are BI enabled the issue is that none of them appears in the OTBI analysis meanwhile…
-
-
Need Expense table that stores the itemization detailsContent I am trying to create a BIP report that shows the Itemization data for accommodation expense type like Hotel Room Rate , Hotel Room Tax etc where the daily room …
-
Query to find the email recipients of the scheduled BI ReportsSummary: Hi, Is there any Query to find the recipients of the BI Scheduled Report using Job. If I knew the Report name, I can get this details by Jobs History -> Edit . …Faqir 261 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Keri N 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…