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
-
We have onboarding 30days questionarie BI report, issue is not showing status in reportSummary: Hi Team, We have onboarding 30days questionarie BI report, issue is not showing status in report some of employess empty coming. I observed that employess statu… -
After Global transfer the existing Contract Info under Employment Info is not displaying in the OTBISummary: After Global transfer the existing Contract Info under Employment Info is not displaying in the OTBI report Content (required): After Global transfer the existi… -
Getting the value of Enable Position Synchronization field from Legal employer setupSummary: Getting the value of Enable Position Synchronization field from Legal employer setup Content (required): Hi Team, Greetings! Is there a report or diagnostic or … -
How to use Calendar chart in OTBI analysisSummary: I am using Detailed Calendar Report in OTBI analysis. I want to present the vacations using Calendar chart. I got one link in oracle community. but in calendar … -
Can we create a Reporting Tile as a shortcut to access OTBI reports?Summary: In OTBI, is it possible to create a Reports Tile or link for managers and HR staff so there is a shortcut to access reports? It is a lot to sort through and has…
-
What audit reports are available for HCM configuration?Summary: We would like to know the types of audit reports available for HCM modules (ORC, Core HR, Compensation, and Talent) that are configuration and not employee leve…
-
Agent - Promoted ParameterContent Hello all, As you help me a lot before, I would appreciate your advice. We build a DB. Combine few report: New Hires & Terminated employees. The BU is prompted. …
-
Oracle table name containing employment category informationHi, I need a list of cost center information defined in the system, can you share the table containing this information with me? I find the cost center information assig… -
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…
-
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…