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
-
<?ref:xdo0053?> for XML tags for LARGE form field size seeded RTF templateSummary: Current seeded template not meeting client requirements so having issues for seeded template of on making changes of adding additional fields Content (please e… -
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s… -
Recruiting Audit Report neededSummary: Recruiting Audit report needed Content (please ensure you mask any confidential information): We are looking for a Recruiting Audit report. Showing Requisition-… -
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea… -
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar… -
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)… -
How to edit contents within a Data Model Report?Summary: Need to update our disclosure form that is a data model thru OTBI connected to Our New Hire Journeys. Is it possible to upload the new data model or edit the co… -
Report for onboarding buddySummary: In which table can I find the oboarding buddy? I need a query to extract it in a report BI. Version (include the version you are using, if applicable): 24A -
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c… -
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas… -
Subject area to fetch Legal Employer Seniority Date at Work Relationship LevelHi, We have moved to Seniority Dates V3 version. We tried to use OTBI to create reports to fetch the Legal Employer Seniority Dates at Work Relationship level. The subje… -
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo… -
FAW reportingHi everyone, I was wondering where I could find a list of all the kinds of reportings that can be done with FAW (in the fied of Human Resources )? Thank you -
OTBI reports new calculated item based on the result of a previous created calculated item?In OTBI reports is it possible to create a new calculated item based on the result of a previous created calculated item? -
BIP Report Job History RetentionSummary: Hi, How far back can we view Report Job History in Oracle Fusion? Is this the right answer? I want to be able to download the reports like in first picture. I h… -
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a… -
Is there any audit report or query to identify who enter/modify time card.Summary: Is there any audit report or query to identify who enter/modify time card. Content (please ensure you mask any confidential information): We tried to use Create… -
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, Shanmukhi -
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be… -
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC. -
How to divide 2 column values from different group in rtf templateHi Experts, I have below xml file in which in want to divide (gender/empcount) from 2 different groups(G_1 and G-2) in simple we want to divide 2193/3399 and 1201/3399 t… -
Pull a list of custom OTBI and BIP reportsSummary: Hello everyone, Is there a way to pull a list of custom OTBI and BIP reports? Thanks and REgards Content (please ensure you mask any confidential information): … -
Need formula for anniversary date on 1st of month instead of day of hireSummary: I need to calculate anniversary dates so that they are the first day of the month they fall in instead of the annual hire date. I have got it partway there but … -
Parent manager 2 job tileFrom the Worker Assignment Real Time Subject Area I could get the Parent Manager 2 Name. How do I get the Parent Manager 2 Job Title ? -
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p… -
How to extract on BIP the field Coments from Progress Summury Recruiting (HCM)Hi, I need a help to extract on BIP the field Coments from Progress Summury Recruiting. Could someone help me please? I can't find it in any table -
Is there an option to redact information, including PII data, in Cloud attachments?Summary: We have a requirement to redact information, including but not limited to PII data, in attachments that may be requested by outside sources. Are there any capab… -
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t… -
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al… -
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.