Data Models
Discussion List
-
Weekly working hours - Lov issueSummary: Hello In the field "Working hours frequency", if we select one of the value, we can't go back to an empty field, and then we must enter a value for the working …Alexis_Mogne 41 views 1 comment 0 points Most recent by Girish Singh-Oracle Human Capital Management -
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 25 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 21 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Human Capital Management -
SQL(Table) to get the Countries with Phone Country codesSummary: If we need to fetch the country codes for Phones, this table is really useful. Please see the SQL. Content (required): SELECT TERRITORY_CODE, PHONE_COUNTRY_CODE…B S Rafatullah-Oracle 703 views 1 comment 1 point Most recent by Neha Aishwarya Human Capital Management -
How can we send a file at UCM on "prc/supplier/export" folder location?Hi I want to send a supplier report at UCM on "prc/supplier/export" folder location using bursting, but I'm not able to find this location. There is only "prc/supplier/i…
-
Enable PersonID binding variable for per_passports table.Summary: Hi, Is there any way to enable PersonID or Perosn_ID binding variable for the Per_Passports tabel Content (required): We have requirements where we want to get …Shubham Khandelwal - Accenture 141 views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Human Capital Management
-
HDL loading error LegalEmployerNameSummary: I'm trying to test the bulk load of a HDL file but getting the below error: The METADATA line can't be processed because the LegalEmployerName attribute is unkn…Maria Smith- de Novo Solutions 12 views 4 comments 0 points Most recent by MandeepGupta Human Capital Management
-
What values should be provided to lexical parameters for seeded BIP data model?I am working on the SQL query for Oracle Seeded Data Model - Transactions Print Data Model for Invoice Print Template report, where it shows some lexical parameters and …Kratika Sharma 384 views 4 comments 0 points Most recent by Dhinakaran G BI Publisher Learning Center
-
Flexfield on Salary pageSummary: Hello, I'm looking to display a Flexfield on different salary pages such as Change salary, salary history. I setup a FF thinking that I was on the right pages (…
-
Resignation Approval reportSummary: We have a requirement to fetch Approvers and Approved date all the Resignation transaction from the system. We were able to retrieve the information for the rec…
-
Include Last Working Day in workflow notification for terminationgood morning experts Could someone help me so that this Last day worked field can be added to the termination notification, I have tried to add it in the MD but I do not…
-
Maximum SSP Weeks report replacement in HCM CloudHi, Our client has been using Maximum SSP Weeks report in EBS. This is out of the box report and they're now looking into getting the same data from cloud HCM. Does anyo… -
Custom SQL Returns Only One RecordI am working on a new report using the below SQL and I am only seeing one Record when running it. I have confirmed that there are many users with no additional assignmen…Nathaniel.Wilcox 1 view 0 comments 0 points Most recent by Nathaniel.Wilcox BI Publisher Learning Center
-
How to Add Representative information into ExtarctSummary: Hi Expert, I need your assistance regarding adding representative information to the worker Extract File. I tried to search the user entity for the area of resp…Saher 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Tax Withholding AssociationsSummary: In what table are the Tax Withholding Associations stored? I need to query this data using a Data Model. Content (please ensure you mask any confidential inform…Al Darabaris 41 views 2 comments 0 points Most recent by Al Darabaris Payroll and Global Payroll Interface (GPI)
-
Seeded Termination Report in Oracle HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 191 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Human Capital Management
-
Oracle UI: determine data source (table/columns)Summary: Hello, When using the web interface of Oracle HCM, I need to determine which table and column the UI values are being populated from. Is there a reliable way to…
-
Excel Report only showing data on 2 out of 3 tabsSummary: We have an HDL Error report that is an Excel spreadsheet with 3 tabs of data. https://us.v-cdn.net/6034893/uploads/RZA3CHT7YYQX/summary-not-appearing.docx The d…
-
Is there any way to extract user account details with who have person data and without person data?Summary: Is there any way to extract user account details with who have person data and without person data? Content (please ensure you mask any confidential information…
-
Reporting on HR Error During ProcessingSummary: Reporting on the reason for HR, Error During Processing Content (please ensure you mask any confidential information): I've created a report to highlight new hi…
-
Aduit Report for ESS jobs scheduled/rescheduledHi, We need an audit report on list of all ESS jobs scheduled/rescheduled, who scheduled them and when were they scheduled/rescheduled. Has anyone worked on any similar …
-
Hide the section "Change Photo"Hi everyone! How can i hide the section "Change Photo" ? Thanks!Mario Della Monica 31 views 9 comments 0 points Most recent by Nivya Mathire Human Capital Management
-
How to call a service logistics PVO from an SQL query from BI Publisher and BI AdministrationHow to call a service logistics PVO from an SQL query from BI Publisher . We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesP…P.S.Nikhitha Muduliar 31 views 1 comment 0 points Most recent by Shrikant Nene-Oracle BI Publisher Learning Center
-
How an employee logged into HCM can run a BI report to get output with his/her own dataSummary: How an employee logged into HCM can run a BI report to get output with his/her own data. My requirement is that who over logs in and runs a particular report, s…
-
Create bank account to an employeeDear All, I am trying to create an external bank account to a new employee using this endpoint:/fscmRestApi/resources/11.13.18.05/externalBankAccounts. But I am obtainin…
-
Does anyone have a report for page field labels in different languages?Requirement is, to provide for business user review, a list of field labels by page, and their translated labels, for each language pack in scope. Does anyone have a rep…
-
How to define pl/sql triggers in oracle hcmSummary: I want a list of pl/sql functions from HCM that can be added as triggers. From what i have learnt so far, oracle does not allow us to define pl/sql functions on…
-
How to define pl/sql triggers in oracle hcmSummary: I want to define or use triggers in my bi publisher model but can't find the package to call them from. What is the list of packages in oracle HCM where i can r…
-
Seeded Function PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS takes longer to run in BI ReportThe function takes longer time to run in BI report and gives time out errors out when run in Adhoc. Since we are placing this report in dashboard as a link to BI, the re…
-
Ways to identify the Person's Assignment attributes modified in "Correct" modeSummary: Need to know the SQL/DB Table through which Oracle Fusion HCM maintains the modifications done to Person's Assignment attributes in "Correct" mode. Content (req…