Data Models
Discussion List
-
Need to edit Enterprise Onboarding TemplateSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We want to display the first name in place of full name in the Enterprise On… -
Worker.dat is not loading to update SenioritybasisSummary: METADATA|Assignment|AssignmentNumber|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|SeniorityBasis… -
SQL to fetch all the worker objects to load using HDLHi all, I needed a SQL to extract the worker objects (worker, person_name, phone, assignment, work relationship, assignment supervisor, etc., ) to load into fusion from …
-
Document of Records Letter Generation Does Not Have Proper Values or Has No DataSummary: The issue can be reproduced at will with the following steps: 1. Employee adds a document record by navigating to Me > Document Records 2. Select Document Type … -
Access of All Employees - Workforce Management - Absence Real TimeThe client requirement is to have access of Approved upcoming absences of all employees to the line managers and I have defined data security under Line manager - Person…
-
Issue with Table pay_dir_comp_details_f, pay_dir_card_components_f 'Responsive UI' calculation cardFor "US Federal Tax Card Details" and " US State Tax Card Details " Records for "calculation card details" are not appearing in the table "pay_dir_comp_details_f" when t…Siddharth D Chaware 169 views 8 comments 0 points Most recent by Visu Payroll and Global Payroll Interface (GPI)
-
Fusion to Fusion with HCM ExtractSummary: Hi, I want to know how can i configure a Fusion to Fusion using HCM Extract and Report. Is there a document with a guide to configure it and the flow pattern to…
-
Add New Assignment CategoryContent Hi Guys, I'm looking to add a new label in the area 'Assignment Category'. We're basically using this area to record the region of an employee, but I can't seem … -
Missing create Data model option under Published Reporting?Summary: Missing create Data model option under Published Reporting? Content (required): Missing create Data model option under Published Reporting? Let me know if any r…
-
Approval Delegates DataSummary Need Approval Delegates Details ReportContent Hi All, We have BIP report for role delegation with all role delegation details. Now the request is to get the data…
-
Please help share SQL to extract all oracle fusion hcm setup configuration with data.Hello All, We want to have a download of Config Workbook from the POD,but Configuration Package and Implementation Project setup isnt working as expected. Please help sh… -
How to add Deeplink for on Dashboard or My Teams -->My Teams WorkersSummary: How can we add DOR deeplink to Line Manager Dashboard where he can choose a person for that specific DOR, Or If we can add a deeplink on MY Team--> My Team --> …
-
SQL for 'Include for Automatic Conversion' and 'Synchronize from Position'On a pending worker record(My Client Groups ->Pending Workers -> Edit a pending worker/Add a pending worker), there are these two Yes/No dropdown fields in the Employmen… -
Updated Data MartSummary: Updated Data Mart by adding new field but not showing up when running the report. Content (required): I have a report created in and updated the data mart by ad… -
Employee access only report and analytics.Summary: Hi Team, We have a requirement , where employee can see only "Tool> report and analytics> and Browser catalog. Let me know anyone knows the privileges name. Tha…
-
Issue with multiple "and" conditions in RTF templateSummary: Hi Team, In an offer letter I have used multiple "If" and "and" condition. If employee is not having Fixed Mobile Allowance-SI, Fixed Transport Allowance-SI and…Asha Jennifer 32 views 1 comment 0 points Most recent by Ram Manoj Reddy Bala-Oracle Human Resources
-
SQL to get Checklist Status for EmployeesSummary: SQL to get Checklist Status for Employees Content (required): If we have a requirement to get Checklist status for Employees, below SQL can be leveraged. Versio… -
Department details with BU and LE InfoHi Experts, We had a requirement to fetch the department details( name , status, effective start date & effective end date) along with its business unit name and legal e…
-
SQL to Extract Tax Withholding Calculation card DetailsSummary: SQL to Extract Tax Withholding Calculation card Details Content (required): If there is a requirement to pull the Tax Calculation Card Details on BIP Report, th…
-
SQL - How to identify list of employees that are missing HR areas of responsibility for current weekSummary: Hi, Need find the list of employees who are not assigned HR responsibility Content (required): SQL Query Version (include the version you are using, if applicab…Bhaskar Dondapati 72 views 6 comments 0 points Most recent by Stephanie Moxley-Oracle Human Resources
-
Report to show View Count on Knowledge ArticlesSummary: Report to show View Count on Knowledge Articles Content (required): We are looking for a report which shows the number of views on published Knowledge Articles/…
-
SQL Sample Query for Native Electronic SignatureI am looking for help on modifying the SQL query I'm using in a data model for the native electronic signature task type. I'm looking to add a parameter for job title an…
-
Generating DOR Records via Document Records in Termination HCM Transaction FlowsSummary: Generating DOR Records via Document Records Available in Other HCM Flows Content (required): Hi all, I am seeking some information regarding the report paths av…
-
Impact Analysis of Work Measure UpdateSummary: Impact of updating Work Measure for all Employees through Data Exchange. Content (required): Requesting inputs on impact on all modules and tasks that may be af… -
Table Value set not returning data?Summary: I have a scenario where in i need to pull data stored in DFF and into another dff as read-only. The query below is generating data in Data model but not via val…
-
Data Model - Exclude TempsSummary: I am working on an employee's roster report and we need to exclude temporary workers in the report for our metric data. The field in per_all_assignments_m pulls…
-
Using Seniority Dates in BIP v3Summary: Hello, I'm creating a Termination report in BIP, and two of the fields left is Legal Employer Hire Date and Enterprise Hire Date. However I'm finding it very ha…
-
Filter out Project Owning Organizations in HCM screensI have a requirement to create Departments to derive accounting in PPM which should not be available in HCM at all, these should only be financial cost centers that do n…
-
Reporting on Legal Employer Seniority Dates in R13Summary Since the move to the new Seniority dates page, Seniority dates are no longer in OTBI and won't be in OTBI for the forseeable future, I'm having issues creating …
-
Logo does not display in header section on Job Offer Letter RTFSummary: Logo does not display in header section on Job Offer Letter RTF Content (required): I have created a Job Offer Letter RTF than contains my client's logo in the …Appsolve.Ian 54 views 6 comments 0 points Most recent by PatriciaS-Support-Oracle Recruiting, Opportunity Marketplace