Data Models
Discussion List
-
How to get the last degree if the worker have 2 records in a Analysis and ReportSummary: How do we get the last degree if the worker has 2 or more records in an Analysis and Report? We need to get the last degree considering their last start date. C… -
Bursting Email not getting sentHI While I am using Parameter3 of query as my company's domain mail. It is not getting sent . Please suggest client does not want email sender to be shown as Oracle. How…Aditi Agrawal2650 72 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center -
Need an Correct SQL Query to get updated start time and stop time from OTL Submitted time entriesBelow is the reference query which is pulling duplicates becuase of confusion between range and measures types. SELECT papf.person_number, htc.start_time, htc.stop_time …
-
Job Profile - Work RequirementsSummary What are all the work requirement fields associated with a job profile?Content Hi Everyone, I am looking to understand what are all the work requirement fields t…User_2025-02-06-09-32-26-556 60 views 4 comments 1 point Most recent by Merwin Human Capital Management -
How to send bursting email using personal email address?How to send bursting email using personal email address?Do we need to configure something or mail address can be used directly in bursting query?Aditi Agrawal2650 12 views 0 comments 0 points Started by Aditi Agrawal2650 BI Publisher Learning Center
-
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…Ooha Pranathi Akkala 4.6K views 12 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM
-
In transaction Console, all old transactions are not visibleSummary: In transaction Console, all old transactions are not visible only few are visible. How to check the old transactions. Need to create a report to fetch old data.…
-
Query on changes only Extract data retention periodSummary: Hello, I have been using a report to extract the xml data for our changes only extract for a long time now. i was able to pull data from flows that were near 30…
-
Query to get assignment category in Positions pageSummary: I am building a BIP report for the active positions in Fusion. I need to fetch the actual Assignment Category found in Positions page: In hr_all_positions_f tab…Patricia Azucena 769 views 2 comments 0 points Most recent by Patricia Azucena Human Capital Management
-
Which table have nationality information in Oracle HCMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Add role restriction of table access while developing the sql query and not while viewing the reportSummary: For OTBI and BIP we want restriction to be added on table access while coding the reports for specific modules. The client wants to code reports in the system u…Tarushee Agarwal 1 view 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Manage Registration ReportSummary: Manage Registration Report Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the active State Withhol…Parag Hiremath 1 view 0 comments 0 points Started by Parag Hiremath Payroll and Global Payroll Interface (GPI) -
Where can we locate the candidate details in the Sample termination extract for Taleo EnterpriseSummary: Where can we locate the candidate details in the Sample termination extract for Taleo Enterprise Content (please ensure you mask any confidential information): …
-
"Report Category for Workers" and "Report Category for Third-party Payees" Organization MethodSummary: "Report Category for Workers" and "Report Category for Third-party Payees" Organization Payment Methods Content (please ensure you mask any confidential informa…Visu 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Can i get the full query for the last Updated dates made to our approval rules?Summary: Data extraction for audit purpose - last updates made to our approval rules Content (please ensure you mask any confidential information): The auditor has reque…Global Support Desk 54 views 2 comments 0 points Most recent by Global Support Desk Human Capital Management
-
Data model not showing edit option in Reports and AnalyticsSummary: We have came across a issue where we are not able to see Edit option for one data model. It shows only properties and More. Edit is not visible We tried to chec…
-
Unable to retrieve Reviewer's data for an employee in Talent review meeting using TablesWe are unable to make an BI Report on Reviewer's data using oracle tables. We got the list of participants for an particular review meeting but unable to fetch the Name …
-
How ESS Job Parameters are mapped to BIP Data ModelI would like to know how ESS Job Parameters are mapped to the BIP Data Model? I have a BIP Data Model with some mandatory and optional parameters. I would like to use a …
-
which tables stores interview evaluation feedbackHi Team, May I know which tables stores interview evaluation feedback ? If possible can I get a snippet of SQL code ? Regards, Harish
-
I need a query to get the last updated datesHow to get the last updated Dates made to our approval rules for Job Offer, Job Requisition Approval, Termination, Resignation, Salary ChangeGlobal Support Desk 31 views 2 comments 0 points Most recent by Global Support Desk Human Capital Management
-
-
Where is Bypass Approval info stored in backend?Summary: On transaction console we have checkbox to ByPass Approval for a process. Where is this information stored on backend. We want to find out who has updated the f…
-
Electronic Signature loading wrong document of recordsSummary: Electronic Signature loading wrong document of records. When we process the Acknowledgement of Policy Journey the data from the first Journey is re-populated on…
-
Is it somehow possible to increase fields or flexfields characters?Hi Community, We know that Flexfields are limited to 150 characters. However, our customer needs to store more than that amount of characters on the Position Page in one… -
how manage decree dataSummary: How to manage in Oracle HCM data of ministerial and administrative decree for Employee in the context of Public Administration. Content (please ensure you mask …
-
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 21 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 702 views 1 comment 1 point Most recent by Neha Aishwarya Human Capital Management