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
-
Moved: Is changing PER_ABS_PLAN_ENTRY_ID normal behaviour?This discussion has been moved. -
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr… -
OTBI : Line Managers not retrieved in Workforce Management - Workforce Trend Real Time Subject AreaSummary: We are creating a dashboard which shows attrition rate based on different aspects like country, departments, etc. We were fetching the query from OTBI analysis …
-
OTBI Subject Area/SQL to fetch HCM Approval Delegation detailsContent Hi, Does anyone know the OTBI subject area/Table names which can fetch the details of HCM Approval delegation in Person's Account Management page. Best Regards D…
-
Sending fails when encrypted PDF is being sentHello, I've to send a PDF file format with pgp encryption to SFTP server. I already uploaded the pgp key in BIP. When testing the file's sending, I am getting an error m…
-
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, Nivya -
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR… -
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…
-
Creating a Report in OTBI for New Hires, Name changes, LOAs, and TerminationsSummary: Hello, I need to create a report in OTBI for New Hires, Name changes, LOAs, and Terminations but I am unsure if this can all be on one report or if I would need…
-
Oracle BI analysis - Relative deep links in interaction actionsSummary: Relative deep links in interaction actions Content (required): We are trying to add relative deep links to a big number of performance counter tiles. How can we…
-
BI Publisher RTF template with Excel output merging rowsSummary: I have a HCM Extract which outputs as Excel via an RTF template. However on the output it is merging 3 rows for each row of data (see below screenshot). Does an…
-
Custom SQL reports don't return data in another language anymoreSummary: Four users with the same security roles and Area of responsibility ran a report. 2 English-speaking users saw data, while the 2 French-speaking users no longer …
-
SQL Query to display OTL Calculated Hours/Reported HoursPlease I want a query or tables to search in to get the reported hours and calculated hours, except for those tables (HWM_TM_REC , HWM_TM_REP_ATRB_USAGES ,HWM_TM_REP_ATR…
-
Ethnicity causing Workforce Trend SA to produce inaccurate headcountWhen adding ethnicity to the Workforce Trend SA it causes the Period Start and End headcount to double/triple for those that have selected two or more races. I have atta…
-
Schedule Agent to run report last day of each monthSummary cannot select report to be sent on last day of each month.
-
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont… -
How to show Other compensation in the Job offer through OTBISummary: Unable to show Other compensation (Individual Compensation) present in the Job offer in OTBI. Content (required): We are unable to show Other compensation (Indi…
-
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…
-
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…
-
We need department and cost center details with effective state date in BI or OTBISummary: Hi Team, we need department and cost center details with effective state date. i tried in worker assignemnet real time but no effective start date. only two clo…
-
"Number of Job Application changed to..." Code NeededDoes anyone know the code behind the following columns? For example, when viewing the numbers, the highlighted "Number of Job Application changed to Job Offer Phase" fie…
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…
-
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro…
-
OTBI Report for Department ChangeSummary: Hi Team I want to create the department report ,where employee's department changed from any department to a specific set of department. Report to pull both the…
-
OTBI - Pull up Job before Effective DateSummary: Making an OTBI report where I need to pull up historical data Content (required): I'm working on a retirement report using OTBI, (which I am completely new to).…
-
Still we implemented Query level RTF templates, how can we implement in RTF level changesSummary: HI Team, Still we implemented Query level RTF templates, how can we implement in RTF level changes as per requirements . Any on help me on to learn RTF level . …
-
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi…
-
OTBI: Hidden Scheduling AgentSummary: I can't seem to find some currently running scheduling agents Content (required): Hello, In OTBI, I get 2 running agents I don't see. Others I see, but not thes…
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup… -
What filtering should be used to show Active for a specified assignment category AND show terms...Summary: Using Subject Area WFM - Worker Assignment Real Time, I have a report that is required to show details of Active Limbo employees AND show terminations within th…