Category 81
Discussion List
-
BIP Report to get Employees with Bank Accounts not assigned in a Payment MethodSummary: Hello everyone, I am trying to create a report where I want to get a list of employees who have bank accounts that are not tied to any Personal Payment Method. …Tom John Bontoyan 61 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…Praveen D 163 views 5 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
Approval Path- Info is locked- Recruiting.Summary: Is there a way to see the approval flow on pending requisitions. Right now, only the person who submitted it is able to see where it is in the approval path, No… -
REQUISITION_POSTED State Code Giving Strange Resultshttps://us.v-cdn.net/6034893/uploads/SEVJVQA956IF/u-s-req-posting-time.txt Hello, I have a need to find the most recent date a requisition was posted and unposted. For c… -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 48 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to edit and disable delivery option of Oracle HCM Fusion HCM Extract in 24BWe would like to disable the delivery option of HCM Extract and edit one of the Data group filter in 24B. As we do not have Advance edit option enable.Bindu Janoti-Oracle 91 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Identify Hire Dates that are any date in the Next WeekSummary: I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE…
-
Migration of Fast Formula, Lookup, UDT in bulk from one instance to another.I am migrating Fast Formula, Lookups, UDTS from one instance to another in bulk, what we need to select under deployment method while creating task, please suggest?
-
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc.
-
No Results custom message not updatedSummary: No Results custom message not updated. Design Sample: Parameter selected: Absence Type parameter selected = Purchase Day. No Results message expected to be prin…
-
Aor QuerySummary: Hi Expert, I have to add an AoR query in my almost five different BI reports. As of now, it shows all data, however, we need to reduce the results based on the …
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…Henry Imgrund 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Multiple School Districts and Multiple Cities per GeocodeSummary: When trying to build an OTBI Data Model for Tax Withholding, we are finding multiple cities in a Geocode (HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS), and multipl…ChicagoConsultant 21 views 2 comments 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
Repeating RowsSummary: I am creating a report that will show job requisitions, the candidates who applied along with their education and previous employment information. Due to multip…UserAA_2026 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 121 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM
-
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
Tracking relatives in the same companySummary: I'm interested to know if anyone has tracked relatives or other relationships of employees working in the same company. We want to avoid having relatives workin…Rose_BOH 21 views 6 comments 0 points Most recent by Anna Klapisz-Oracle Reporting and Analytics for HCM -
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…Patrick Scally 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…Ankush_Jadhav 11 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th…
-
Average salary by compensation zone (getting sum instead of average)Summary: I am trying to create a report that will show Minimum, Average and Max salary for each compensation zone (Market A,B,C,D) using Compensation - Salary Details Re…Ameya_J 41 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…Deepak Bhatt 21 views 1 comment 0 points Most recent by Asmita Barman Reporting and Analytics for HCM -
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dynamic Date parameter in OTBISummary: I have a requirement to get output depending on date parameter user will provide from prompt . how can i achieve this in OTBI report Content (required): Version…Sudipta007 591 views 8 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 521 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
How to pull only one field for Person Legislative Information > CountrySummary: I am attempting to pull an employee file that includes which country an employee lives in. I am using the subject area "Workforce Management - Person Real Time"…joshvanlaan 21 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Logic to calcuate LOP days including the public holidays and weeklyoffsHi , I able to find of the absent days of employee for a month. Now i need help in deriving the logic to include weekly off and holiday if these days falls in between 2 …
-
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, https://us.v-cdn.net/6…
-
Disable and Migrating BI Publisher JobsGood Day, For OTBI Agents, we can set it to disable if we do not want it to run. How about for BI Publisher Jobs? Is there a way to disable it? I cannot find any option …