Data Models
Discussion List
-
ORA-01719: outer join operator ( ) not allowed in operand of OR or IN errorSummary: Content (please ensure you mask any confidential information): We are unable to see any information in the change address notification upoon debugging further w… -
Deeplink to vacation rule pageSummary: I have created an alert that is sent to the employee as soon as his/her absence is approved. The alert reminds employees to create a Vacation Rule before going … -
How to have CR LF in ETEXT OutputI would like to ask on how to create a CR LF with ETEXT Output that is using an RTF Template.MayCab 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
To track HCM Key Configuration changesSummary: Hi , Looking for ways to capture HCM key configuration changes like setup data , what configuration changes are made , the user who made the changes and all. We…
-
Backend column name to fetch special purpose attribute in element input valueSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 21 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM
-
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… -
Display of Dashboard is not good in IphoneSummary: I have developed a dashboard the display of it is same in desktop and in android phones. I have arranged 2 columns side by side. Below these 2 columns I have an… -
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…
-
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… -
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 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 942 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…
-
HSDL Template to load DFF values in Employment pageSummary: Hi Team, We have configured the DFF value in the Employment page,and need to load the values to list of associates. We tried using HDL Template to load but when…Madhavi konduru-Oracle 40 views 9 comments 0 points Most recent by Madhavi konduru-Oracle Human Capital Management
-
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 63 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…
-
Is there a way to delete the previous selected valued from the flex field.Summary: I would like the system to delete values from the DEI fields when a user changes their consent value from YES to No or Yes to Blank it is preferred that the del…
-
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-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) -
I need a query for the last updated dates made to audit approval rulesSummary: Data extraction for audit purpose - last updates made to our approval rules Content (please ensure you mask any confidential information): I need a query for th…Global Support Desk 1 view 0 comments 0 points Started by Global Support Desk Human Capital Management
-
"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 21 views 2 comments 0 points Most recent by Global Support Desk Human Capital Management
-
Create user account using rest apiDear All, I am attempting to create a worker using the REST API (/hcmRestApi/resources/11.13.18.05/workers). It automatically generates the user, but when I set the user…
-
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…
-
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…
-
SQL query to fetch all notifications/emails sent by Fusion.Summary: We need to extract all worklist notifications/Approval/email notifications that are triggered in Fusion within a specific time range. Has anyone ever worked on …Piyush Pokharkar-Oracle 1.9K views 7 comments 1 point Most recent by Saurabh P Singh Human Capital Management
-
SQL TO GET REQUEST FOR MORE INFORMATION TRANSACTION DETAILS in Absence Transaction in FUSION HCMHi Experts, I am looking for SQL to fetch the Request for more Infomation by Approver in Absence Transaction in oracle fusion HCM. Please let me know the tables or SQL R…
-
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