Data Models
Discussion List
-
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…Jose Guerra 16 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Human Capital Management -
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… -
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…Yuvraj S-Oracle 57 views 7 comments 0 points Most recent by Yuvraj S-Oracle Human Capital Management
-
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…B S Rafatullah-Oracle 1.9K views 1 comment 2 points Most recent by Parag Hiremath Human Capital Management -
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…User_2025-02-12-21-24-25-654 78 views 6 comments 0 points Most recent by Stephanie Moxley-Oracle Human Capital Management -
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…Luke.Findex 114 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
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 …User_2025-01-30-01-42-22-008 185 views 8 comments 0 points Most recent by Max W Human Capital Management
-
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 …Consultant Ian 196 views 6 comments 0 points Most recent by Patricia-S-Oracle Recruiting, Opportunity Marketplace -
Employee under an AORSummary: Content (required): Hi Everyone, Could you help me with Query to fetch all the employees under an AOR? Version (include the version you are using, if applicable…ShawShankk 46 views 2 comments 0 points Most recent by Dr Surlina Yin-Oracle Human Capital Management
-
API for employee supervisor hierarchySummary: Was researching if there is API to get employee supervisor hierarchy where, for example, employee is parameter and API will return chain of command all the way … -
How to customize approval templates to show/hide dataSummary: I need to customize an approval notification to show/hide data based on security roles. How can i use a conditional region to show/hide? Content (required): I n…Adil_R 36 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
HCM Exclusion RulesSummary:BIP Report - Link HCM Exclusion Rules to Data Role Content (required): Hello, Would anyone be able to provide the tables/linking that tie HCM Exclusion Rules -> …JBlain 89 views 2 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
How to customize approval templates to show/hide dataSummary: I need to customize an approval notification to show/hide data based on security roles. How can i use a conditional region to show/hide? Content (required): I n…Adil_R 15 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Does anyone has experience with doing a rehire with a spreadsheet load?Summary: Does anyone has experience with doing a rehire via a spreadsheet load? And if so, can you send me the example template? Content (required): Does anyone has expe…Martijn van den Berg 46 views 1 comment 1 point Most recent by Cristina Greyling - Oracle-Oracle Human Capital Management -
Line Manager view when they also have HR Analyst RoleSummary: Line Manager view when they also have HR Analyst Role Content (required): Hello All, We have a business requirement where we are enabling infolets only for Line…User_2025-02-12-15-36-40-024 27 views 1 comment 0 points Most recent by Unknown Human Capital Management
-
Is there any way to schedule a report using flow patterns?Summary: Hello Everyone, I have created a custom flow pattern and added a BI Publisher report to it. I have submitted this flow pattern using payroll flows. Now I want t…Padamatinti Varsha 37 views 2 comments 0 points Most recent by Raghavan p-Oracle Human Capital Management
-
Does anyone have any Journey's reports already compiled?Summary: I am looking for a compilation of Journey's reports. I thought I had seen a comment on here before with some but I cannot find it now. Content (required): I am …
-
How to find missing privilege to get archive and unarchive options on reportsSummary: How to find missing privilege to get archive and unarchive options on reports Content (required): Hi Team Greetings! The archive and unarchive options are not s…Parag Hiremath 405 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Date start is different in backend.Summary: Date start is different in backend. Content (required): Hi Team, For an Employee, in the employment page the hire date is showing as 05/16/2022 but in the per_a…
-
Can we add Reference number to Letter Reports generated using Document of Records.?Summary: We have a requirement to add reference numbers in letters generated using DOR. Content (required): Users want to add the following reference number format in le… -
Embed BI data model based report in fusion HCM pageSummary: Can we show the data from BI report(Data model based) in the employment page in HCM ? I need the data to populate in same page as a table instead of opening as …
-
Edit Termination -- How to identify if the termination has been correctedSummary Edit Termination -- How to identify if the termination has been correctedContent Hi Experts I would like to see if there is a way for us to identify if a termina… -
HDL WORKER LOADSummary: Hi All, I am trying to load Non workers through HDL and I'm always getting the following error: Error: An error occurred while processing your data set: java.la…Padamatinti Varsha 197 views 3 comments 0 points Most recent by MilanMohanty Human Capital Management
-
Issues in 22B for HCM Extracts and BI PublisherSummary: Hi All, Below are the issues that we have encountered post 22B upgrade: INBOUND INTERFACE type not available while creating/developing the HCM extract. In globa… -
Roles associated with reportsSummary: Can we create a report to identify all the roles associated with different reports in OTBI ? Content (required): Version (include the version you are using, if …Saurabh Pratap Singh 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Human Capital Management