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
-
Position trend real time Subject Area - how to find Position Incumbent?Summary: Hello. I'm trying to build a report of open positions and their previous position incumbents. Is it possible to create this report using a new subject area 'Pos… -
per_pos_tree_node_rf and PER_POS_TREE_NODE_RF tables empty, though it is visible from frontendSummary: I am developing an HCM Extract to send Position Structure data external source. One of the required fields is the Parent Position Code for each position. When n… -
How to report on job subfamily?Hi, Is there a way to run a report with the job code, job name, associated job family and associated job subfamily in BI publisher? -
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to …
-
Pay Period End date Retroactive CostingFor reporting on payroll costing, how are people populating pay period start and end date for payroll actions Retroactive Costing, Estimate Costing or Balance adjustment…
-
Rational for the 14day record retention limit on successful HCM AlertsSummary: What is the rational why successful Alert records are saved to the tables for only 14 days? Content (please ensure you mask any confidential information): We wo… -
Unable to create report using Workforce Management - Assignment Action Occurrence Real TimeWe have a custom role mapped to the Human Resource Specialist role, with a new requirement to grant access for creating reports using the Workforce Management – Assignme…
-
not able to view future dated hires in my reportSummary: not able to view future dated hires in my report. I added the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='2050-12-31' but still not showing Content (please ensure…
-
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat… -
Scheduled Processes > Import Costs: Generate Output ReportHi, When accessing the Scheduled Processes page, we search for the Import Costs: Generate Output Report process, as shown in the screenshot. This occurs when the posting…
-
How to see ESS log messages/files in a Global Absence Ceiling fast formulaI have configured a few ESS log messages within my Global Absenece Ceiling fast formula, however the formula doesn't get triggered when the Calculate Balances and Accrua…
-
Custom Approver Logic in BPM – Validating User Email/Access via BIP or Alternative ApproachSummary: In Oracle Fusion BPM, approval routing is typically based on predefined rules such as user, supervisory hierarchy, AOR, or role. However, we have a requirement …
-
Excel report is not printing the parameter when used with burstingSummary: Excel report is not printing the parameter when used with bursting Content (please ensure you mask any confidential information): Hello All, I have an Excel tem…
-
Getting Invalid format excel format requested error using RTF templateSummary: Getting Invalid format excel format requested error using RTF template Content (please ensure you mask any confidential information): Hi, I have a report that I…
-
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 …
-
Disciplinary and GrievanceSummary: I have a report meant to capture both active and inactive records for a specific value in the subject area of personal real time. Because the criteria is set to…
-
Requirement for Encrypted File Generation in UCM via BIPSummary: Hi, We are currently using Bursting in BI Publisher, where a .csv file is generated as the output and placed in the UCM Content Server. However, we have a requi…
-
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…
-
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…
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti… -
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 …
-
SQL Query - Absence entries to Payroll Calculation CardSQL Query - Absence entries to Payroll Calculation Card: This query can be helpful for all users to validate that recent all absence hours are properly synced with the P… -
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…
-
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… -
In which table candidate position stored?Summary: I am looking for HCM table in which canidate position information stored ? Content (please ensure you mask any confidential information): Version (include the v…
-
Area of Responsibility subject area does not return latest changeSummary: We created a simple analysis to return AOR but do not get the latest change. Does the subject area return the same values as what's seen in the UI Content (plea…
-
Learning OTBI reports does not retrieves data when item has no access view modeHello, I'm trying to build a report from the subject area Workforce Learning - Learning Management Real Time to extract learning history of workers (completed courses). … -
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…
-
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 …