Data Models
Discussion List
-
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 51 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 -
Conditionally send report to email ONLY if query returns data resultsIs it possible to setup a schedule in BI Publisher to run every day that will only output a report to EMAIL if the query fetches at least one row of data? In other words…
-
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 71 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 112 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… -
Would like to report on HR Help Desk Audit History table in BI PublisherHello, We would like to report on HR Help Desk audit history in a BI Publisher report. Has anyone done this and might be willing to provide instruction? Thank you, Natal…Natalie A. 51 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center -
I can't view a job option in more menu for default report ?I can't view a job option in the more menu and the scheduled job doesn't appear on the Manage Report Jobs page for default reports. but it works well and shows scheduled…New 41 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
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 180 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 192 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 41 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 … -
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…User_2025-01-30-18-22-06-612 43 views 4 comments 0 points Most recent by Hardik_User2023 HCM Integrations
-
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 31 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 81 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 11 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 41 views 1 comment 1 point Most recent by Cristina Greyling - Oracle-Oracle Human Capital Management -
____ has a private scope. It's not part of the official offering. Error in TCCSummary: Has anyone experienced the tcc error " (field name) has a a private scope. It's not part of the official offering." Can someone share more insights / inputs on …
-
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 21 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 31 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 …
-
Bursting by quantity of results? And "pull" delivery???I need to export a couple million rows of data from Financials as CSV files or similar. Even when I limit the output by fiscal year, some years produce well over a milli…