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 table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This … -
Skip Query in Oracle Fusion HCM BPM workflows is not workingSummary: Hi All, We want to skip the approval step if the approver is the CEO. We tried using the below query; however, it is neither skipping the hardcoded person nor w… -
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g… -
Inquiry on Table for Bursting Email TrackingSummary: Inquiry on Table for Bursting Email Tracking Content (please ensure you mask any confidential information): In accordance with the requirement report, emails ha…
-
Is there an easy way to pull all the notifications enabled in the systemSummary: Is there an easy way to pull all the notifications enabled in the system. Content (please ensure you mask any confidential information): Is there a way we can p…
-
REST APIs or SQL Queries to fetch the Fusion SAAS BI Report's list from "/Custom" FolderSummary: We have a requirement to fetch all Data Models & Report from "/Custom" folder in Fusion SAAS. Content (please ensure you mask any confidential information): Loo… -
Change Text format in dashboard BI publisherHi, is it possible change text format (size, format, color,…) in caption inside "Link or Image" in BI publisher dashboard ? Thanks, Han Xi Zhao
-
Is there any query to identify which flow generated the output file that included the given PNHi Team, Is there any query to identify which flow generated the output file that included the given person number. I want to identify which flows picked up the given pe…
-
I need a BIP/OTBI report If the rating in any of the question is 3 & below-BHR intervene & solve.Proposing to integrate three feedback forms into our HRMS, triggered automatically at the 30-, 60-, and 90-day milestones, to capture each new joiner’s onboarding experi…
-
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve… -
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit…
-
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W…
-
Has anyone created a costing by job report using the Payroll Run Costing Real TIme subject area?I need a report to show costing by job for last year. I've written one but can only get it to work for one person at a time, it does not produce results when I try to ru…
-
Leave balance ytd in oracle payroll run resultsSummary: Hi All, We have a requirement to get the Sick leave ytd balance in the report. Could you please help me to get the query for the same? or How can we get the Sic…
-
person security profile required to custom query to restrict location and email?Summary: Summary: threre is location page- hr1, hr2 and hr3 are DFF stored employee emails. suppose one of the employee login as HR , all location assoicated to hr emial…
-
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 …