Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
SQL Query to get Value Set ListSummary SQL Query to get Value Set ListContent Hi Team, Could you share me any BI/SQL query to fetch the all list of Value sets using in HCM Instance like Dependent, Ind… -
How can parameters values be be linked to depend on each otherIs there a way the list of values in BIP report parameters be linked such that selecting values in one determines the values that show up in another especially when they… -
OTBI: How can we run a report with the previous month start and end dateSummary: How can we programmatically run an OTBI analysis report with the previous month start and end date? Content (please ensure you mask any confidential information… -
Filter query using NVL not workingSummary Unable to save query when trying to use the NVL command with a logical sqlContent Hi All, I hope someone is able to help me with an issue that I am having. I hav…
-
Decimal number issue in etext templateSummary: Etext template - When I use if clause to compare two numbers without decimal positions is working fine, but it is not working if one of the number has decimal p…
-
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Most recent date paidSummary: I have an OTBI report that runs every other Thursday pulling earnings. The Effective Date field uses the below advanced SQL filter to pull only the current date…
-
how to create ORC otbi hires based on nationalitySummary: We have requirement to create otbi report for hired list based on nationality in ORC module. Content (please ensure you mask any confidential information): Vers…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…
-
Overtime period field on payroll relationshipSummary: What table(s) can I find the Overtime Period field on the payroll relationship. I am being pointed to HWM_RP_TM_PERIODS_TL but this table does not seem to have …
-
How to report on workers with termination date in last two monthsSummary: Content (required): I'd be grateful for some help with a filter on an OTBI report. The report is quite basic, showing employee name, person number, position, lo…
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Employee / Employer Pension Contribution Report for a specific durationSummary Employee / Employer Pension Contribution Report for a specific durationContent Hi, May I check if anyone has any OTBI / BIP report for Employee / Employer Pensio… -
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…
-
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the… -
Table name/Report for Structure (Navigation Configuration)Summary : We require a report or table name that contains the configuration for the 'Navigation Structure.' This information will be necessary to ensure consistency in t… -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver… -
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…
-
Connect Query Tool to Oracle CloudSummary New to reporting in the Cloud and am interested in finding more efficient ways to view the contents of our tables.Content We are in the process of transitioning …
-
Position Costing with Incumbent ReportSummary: Does anyone have a report that includes both Position costing, with position number, and the position incumbent. We don't have the skills on the team to build a… -
BI table name to fetch Module from Manage common lookup screenContent Hi Experts, I have a requirement to fetch module from manage common lookup screen. Please help with relevant BI query. Thanks Sandip -
Tables used in "User Password Changes Audit Report"Hi team, would like to know the tables used in the User Password Changes Audit Report program and do we have any standard report for user account name changes in oracle …
-
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…
-
Is it possible to report on payroll costing data with the position that the cost relates to?Summary: We have a business need to be able to separate out costs for a position change and to be able to report on them separately, but the data table only holds the as…
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. Sowmya
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…
-
Management Levels on OTBISummary: We have Management Levels defined on Job definitions. (Screen shot attached). For a person we would need to capture the management levels against the job on the…
-
Is it possible to deliver xml within body of email via BI Publisher?Content (please ensure you mask any confidential information): I understand this is possible by setting the delivery method as HTML via bursting, however is there a way … -
UK Payslip: Is there any approach to trigger payslip only for employees who have work email.Summary Payslip Process Completed with Warning : Many employees do not have email id and we are trying to send payslip as email through bursting option, in such scenario…