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
-
Need to print the User Name on a Template; Need UserName from Global, HCM, or ASCMSummary: Need to print the User Name on a Template Content (please ensure you mask any confidential information): I am new to Oracle Fusion and FDI. I need to print the … -
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b… -
Annualized TurnoverSummary: Does anyone have a report for annualized turnover? I see questions from the past on this same topic and have not found one in the shared reports. The seeded fie…
-
ICP start date in fast formulaSummary: How to restrict start date in ICP page. We want to restrict employee entering the back dated changes for their pension contributions. Have any one done these ty…
-
Unable to find Employee and Manager comments in OTBI for Performance documentUnable to find Employee and Manager comments for Performance document in oracle fusion HCM. We are using Subject Area - " Workforce Performance - Performance Rating Real…
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
per_personSummary: We could see lot of system users are exists in oracle fusion. We would like to build a report to identify only the actual users in oracle fusion. FUSION_APPS_AM… -
Work Email is visible but Personal Email is blank for specific usersHi, We are experiencing an issue in Oracle HCM where a report that includes both Work Email and Personal Email behaves differently depending on the user running it. When…
-
How to Migrate DFF and EFF Flex Fileds?Summary: we have the DFF and EFF setup in one instance. we need to migrate that setup in new instance. Could you please provide the steps to migrate flex field setups mi…
-
when inactive development the approval rules get failedSummary: When we inactive the development goal the approval is going for transaction and it is getting failed. Below is the approval rule that we are using ((transaction…
-
How to set up taxes as calendar year when application is fiscal year in EPBCS workforce module ?Summary: The application is set up as a fiscal year (Apr - Mar). However, there are certain taxes which the client wants to setup at calendar year level. We went to the …
-
How to hide fields on a DOR approval notification page-redwood.Summary: Hiding fields on Document of Record Approval Notification Page. Content (please ensure you mask any confidential information): We have a requirement to hide few…
-
Latest Talent Ratings OTBISummary: We are required to create a prompted OTBI analysis that includes each of the worker's latest talent profile ratings. How can this be achieved? Version (include … -
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
OTBI Workforce Management - Person Real Time - Person Work Permit "Checked By"Summary: Adding "Checked By" to a work permit report severely degrades performance. Though the report will run when prompted on a single department, it times out when ru…
-
Update permission of report with custom roleSummary: We want to limit the visibility of some reports only to specific user roles. We tried to add permission but we are not able to see the custom roles. We can add …
-
How To Update the Position Effective Start Date in HCM?Summary: We have HCM integration with our legacy payroll system (Chris21). Position data was loaded via Oracle HDL format at implementation time. The position effective …
-
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For …
-
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20A -
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
query to fetch 9box data assignmentSummary: select p.person_id,c.content_item_code, pi.item_number_1 BOX_NUM,pi.section_id FROM HRT_PROFILES_VL P, HRT_PROFILE_ITEMS PI, HRT_CONTENT_TYPES_VL CT, hrt_conten…
-
TimecardApprovalNotificationReportSummary: I am getting the below error when i try to view the data model of TimecardApprovalNotificationReport HCM folder. Can anyone please suggest the solution. ORA-009…
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …
-
How to obtain the history of when a role is assigned and revoked to a userSummary: Hello All, As an Audit Requirement we need the complete history of when access is provisioned to a role and it is revoked. The following table ASE_USER_ROLE_MBR…
-
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…
-
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …