Data Models
Discussion List
-
MAIN HCM SQL with 2 UDT columns (Nested JOINs)Summary MAIN HCM SQL with 2 UDT columns (Nested JOINs)Content Hello Forum friends:My goal is to have one line per Person_number and am successful with a couple of record… -
SQL Join of HCM and UDT tables togetherSummary SQL Join of HCM and UDT tables togetherContent Hello: How can i create a SQL join of HCM and UDT tables together in a BIP report? Can i and do i have to use this…
-
Manager DashboardSummary Do you have a Dashboard your managers love?Content We have a January go-live and are looking to wow our managers with good information at their fingertips. Do yo… -
Cloud HCM Talk Radio - People to Profit Analytics - Time to invest is nowSummary Cloud HCM Talk Radio - People to Profit Analytics - Time to invest is nowContent Are you interested in finding out more about Financial Analytics and People Anal…Frank Cowell-Oracle 16 views 0 comments 0 points Most recent by Frank Cowell-Oracle Human Capital Management -
Report with both bursting and non bursting requirement in one runSummary A report that requires both bursted and unbursted requirementsContent I have a requirement for a reports where the PDF output needs to be bursted by Company. I h…Joe Roberts-Oracle 25 views 2 comments 0 points Most recent by Sricharan Monigari Human Capital Management -
any possibility to change value M (Million) into Rs or INR??Summary any possibility to change value M into Rs or INR??Sidhartha Wadhwa 19 views 3 comments 1 point Most recent by Sidhartha Wadhwa Human Capital Management -
PER_EXT_PERSON_ADDRESSES_UE not fetching address of type 'MAIL' but its fetching address of type 'HOSummary PER_EXT_PERSON_ADDRESSES_UE not fetching address of type 'MAIL' but its fetching address of type 'HOME'Content I am building hcm extract with Assignment UE as ro…
-
is there any lookup or any setup part of workforce modeling??Summary is there any lookup or any setup part of workforce modelingSidhartha Wadhwa 40 views 3 comments 1 point Most recent by Julian Challenger-Oracle Human Capital Management
-
Action and Action Reason usages mapping reportSummary Action and Action Reason usages mapping reportContent Hi all, I am looking for a SQL extract/report that pulls all the list of Actions, associated Action Reasons… -
Unable to find Database Table Name and Column Name for 'Pending Changes' in Manage Grades and ManageSummary Unable to find Database Table Name and Column Name for 'Pending Changes' in Manage Grades and Manage Grade LaddersContent Dear All, Could someone please help to …Gopikrishna Nerella 25 views 1 comment 0 points Most recent by Senthamizh Arasu Govindan Human Capital Management
-
Location change report OTBIContent Hi, I need to produce a report in OTBI that gives me back the workers who changed location independently of the actions on today's date. How i can do it? It is p… -
Some Commonly Used Queries In Oracle HCM CloudSummary Some Commonly Used Queries In Oracle HCM CloudContent In any typical ERP Implementation, there are requirements to prepare multiple reports. Most of the Reports …AshishERPCloud 1.1K views 4 comments 7 points Most recent by AshishERPCloud Human Capital Management -
Need custom report to fetch the all the configured approval rulesSummary Need custom report to fetch the all the configured approval rulesContent Hi All, Is there any Custom report or Seeded report to fetch all the configured approval… -
Sample Query for Questions and Answers in Chekclist TemplateSummary Sample Query for Questions and Answers in Chekclist TemplateContent Hi Experts, Does any one have any sample query to pull the Question and Answers data from the…
-
Dynamic File Name and Bursting output using HCM ExtractContent Hello Everyone, I am creating an HCM Extract for the employee element entries. My requirement is to split the output file based on a flexfield attribute present … -
Manager Listing by Employee with Multiple ManagersSummary Recent changes limit manager results to "Line Manager" only, or entire hierarchy down to the employee. Users need a simple solution... Here is a workaround.Conte… -
Plot Headcount on a World mapSummary Bi Publisher - Excel- Plot Headcount on a World mapContent Hi Gurus, I am looking for ideas around plotting headcount on a world map. We are trying to use the ex…Sriharsha Devraj 31 views 2 comments 0 points Most recent by Sriharsha Devraj Human Capital Management -
HSDL error "The values ****,****,Reason aren't valid for the attribute InputValueId.Content Hi All, I am trying to load a basic element with 2 values Amount and reason. Now when I create an HSDL with the only Amount as input value it works. Now I try to…
-
Roles and TerminationsSummary Remove roles post TerminationContent Team, we have a requirement to remove all roles when user is terminated . we are planning to automate this through HDL and c…User_2025-01-30-20-47-14-770 58 views 4 comments 0 points Most recent by MandeepKGupta Human Capital Management -
Roles and TerminationsSummary Remove roles post TerminationContent Team, we have a requirement to remove all roles when user is terminated . we are planning to automate this through HDL and c…User_2025-01-30-20-47-14-770 49 views 1 comment 1 point Most recent by Siraj Syed -Support-Oracle Human Capital Management
-
BI Publisher report how can we add banner pic and color formatting to the layout?Summary BI Publisher report how can we add banner pic and color formatting to the layout?Content Hello , We would like to add a BIP report to a picture banner of the com… -
Can we modify standard process "Make EFT Payments" in fusion?Summary Can we modify standard process "Make EFT Payments" in fusion? we need to add some fileds so want to understand if we cand modify and what is the data source link…
-
BI Publisher SOAP error: FailedAuthentication : The security token cannot be authenticated.Summary Problem trying to run RunReport operation.Content Hi everyone, I'm testing an HCM Cloud report call using the BI publisher web service: https://[YourDomain]/xmlp… -
Please share tutorials on how to make SQL Queries for BIP ReportsSummary of Request Please share tutorials on how to make SQL Queries for BIP ReportsContent Hi, I am interested in learning SQL query building for BIP Reports. Please sh…Renuka Soneja-154959 56 views 0 comments 1 point Most recent by Renuka Soneja-154959 BI Publisher Learning Center -
Using payroll flow to run BIP report that has an excel input fileSummary Using payroll flow to run BIP report that has an excel input fileContent We have created a BIP report that makes use of a RTF template style sheet. The underlyin…User_2025-01-25-04-02-13-126 41 views 7 comments 0 points Most recent by User_2025-01-25-04-02-13-126 HCM Integrations
-
How to execute the PLSQL in Oracle cloud HCM?Content Hi, How to execute the PLSQL in Oracle cloud HCM: https://oraclecloudhcmtechfunc.blogspot.com/2020/06/how-to-execute-plsql-in-oracle-cloud-hcm.html Thanks Sainath