Data Models
Discussion List
-
Need help with Loopback IntegrationsWe are exploring the option of "Loopback Integration" previously known as "Inbound Interface" which got decommissioned since 22B. We have received a step by step guide f… -
Get employee information that has been modified since a specific date using SQL queriesSummary: Get employee information that have been modified since a date by using SQL queries and not API nor ATOM fields. Content (please ensure you mask any confidential…
-
Adding BIP report in custom resource alerts message bodySummary: Hi Everyone , We have a requirement to add a BIP report in custom Alerts message body. Please let me know if there is any possibility. Content (please ensure yo…
-
Adding a Common Sequence to Filename in Bursting Report Triggered via ESS JobHi everyone, I'm working on a bursting report in Oracle that generates filenames with a date and timestamp, like Grade_01012024_928282.csv. I have two different reports …
-
Replace Grade in a Job Code using job.dat HDL loadSummary Replace Grade in a Job Code using job.dat HDL loadContent I want to replace a grade in an existing job code using HDL. Below is a sample. I want to replace E04 w… -
How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileSummary How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileContent Hi Experts, Can anyone please help me as to how to displ… -
Can we burst multiple templates in BI Publisher?Summary Can we burst multiple templates in BI Publisher?Content Hi Team, I have a requirement where I am having two different templates based on a single data model. Eac…
-
How event changes being tracked in HCM cloud HRC_EVT_OBJ_CHANGES table?Summary How event changes being tracked in HCM cloud HRC_EVT_OBJ_CHANGES table?Content Hi Team, Am trying to understand how an event change is being tracked in Oracle HC…
-
Want to do a Bulk update on Work Email to stop notifications or Data Masking reasonsSummary NOT Licensed for data masking want to update email address for everyone please use this sql to create a HDL file and import into HCM.Content Here you go! select … -
Using SUM function in Table Type Value setContent I am trying to perform the SUM function in a Table Type value set, but it is not fetching results. I have tried various ways like using inline query in the ID Co… -
Debug HCM Extract - Extract Rule Type Attribute (Fast Formula - Without DBI)Content Hello, the use of pending workers requires us to update to an existing HCM Assignment Extract. Currently we use the DBI PER_PERSON_ENTERPRISE_HIRE_DATE. However …
-
Create direct depositSummary Create direct deposit report to third party banksContent Hi All, I am looking to send create direct deposit deposit file that gets generated as part of payroll r…
-
Need inputs to find the Report Name/HCM Extract Name based on the Bursting emailSummary: Need inputs to find the Report Name/HCM Extract Name based on the Bursting email Content (required): We got bursting email notification but we need to know on w…
-
Reverse Termination - Comments stored?Summary: Reverse Term Comments for custom report Content (required): Which HCM table stores Comments from Reverse Termination UI Version (include the version you are usi… -
HCM Extract failure notification email content customizationSummary: Is it possible to customize the HCM extract failure notification email content? Content (required): We have a requirement to customize the HCM Extract failure n…Venkateswaran Murali-Oracle 31 views 0 comments 0 points Started by Venkateswaran Murali-Oracle HCM Integrations
-
Table Info Alert Composer NotificationHello everyone, we need to see the history of when notifications created with Alert Composer have been changed, does anyone know if there is a table where this informati…Alfonso Alfano 242 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Sample HDL or Spreadsheet file for Competency Talent profileContent Does any body have any dat file or sample file for Competency load in talent profile ? We are trying to load competency to Talent profile but it not working. We … -
Need Connection/Join between Business Unit and Legal Employer User EntitySummary: Grouping and summation by Legal Entity and Business unit I am trying to develop a Payroll Balance related HCM Extract where I need to group the data based on Le… -
HDL for Terminate and Re-HireSummary We have a requirement to Terminate & Re-Hire An Existing EmployeeContent We have a requirement to Terminate & Re-Hire An Existing Employee with All The Details E…
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi Experts Select LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. … -
HDL Questionnaires with Conditional Questions failsContent Hi all, I have been loading questions with HDL to Fusion which in the main works but fails when I have conditional questions and answers. The Oracle documentatio… -
HCM Extract: How to generate custom file extension like file_name.xyz?Summary HCM Extract: How to generate custom file extension like file_name.xyz?Content hi All, I need to generate output from HCM extract with custom file extension. Curr…
-
Procedure Element in HCM ExtractContent Can anyone explain what is a Procedure element and where I can see the list of PROCEDURE ELEMENT? And any white paper introduces how PROCEDURE ELEMENT works? Ver…
-
Identifying appropriate user entity to use for HCM extractSummary Looking for guidance regarding identifying the appropriate user entity to use for a HCM extractContent Hi Looking for guidance regarding identifying the appropri…
-
Need HDL to load results of a BI report regularlyContent Hi, Is it possible to schedule an HDL ran regularly, wherein the file it processes is the output of a BIP report that is sent over to webcenter? I have seen this…
-
Need table name which store the fields : Threading Database item, Root Data Group and Threading ActiSummary Need table name which store the fields : Threading Database item, Root Data Group and Threading Action.Content Need table name which store the fields : Threading…
-
CSV Extension File from HCM extractSummary CSV OutputContent Team, Could someone please let me know if we can generate CSV from HCM extract using XSL template ? I did refer one document from Oracle CoE bu…
-
Use of :flowInstanceName PARAMETER6 Output File Name - in Bursting SQL of globalReportsDataModel?Summary Use of :flowInstanceName PARAMETER6 Output File Name - in Bursting SQL of globalReportsDataModel?Content Hi forum: We would like to pass the :flowInstanceName to… -
UCM Tables listSummary UCM TablesContent Hi Iam looking for UCM table names. One of the requirement is I wanted to see where employee pictures are stored in UCM tables and if it can be…Naveen Jayaraman-48236 164 views 6 comments 0 points Most recent by Anupam Singh-154771 HCM Integrations -
HCM Extract Office Hours Session on Payroll Costing pleaseSummary Session covering how HCM Extracts be used to provide Payroll Costing information pleaseContent Please can you hold an HCM Extract Office Hours session on how to …