SQL
Discussion List
-
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 44 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Query to link Location to Reporting EstablishmentSummary: Hello, CC! I am in a need to find a way to develop a query that can list all the Locations given for a Report Establishment(Or a Legal Employer) for a Report I …Matheus Roberto 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need to fetch Resignation/Termination withdrawn after last working dateSummary: Hi, There is a requirement to pull all the employees who has withdrawn the resignation/terminations after the last working day need to include pending for appro…Aruna Aounti -Oracle 1 view 0 comments 0 points Started by Aruna Aounti -Oracle Reporting and Analytics for HCM
-
Issue with Dependent Filters and Multiple Selections in BIP Report for CoursesSummary: Hi Team & @AshishERPCloud, I have created the BIP report for the Courses. Where I have given the filters of Course, Offering, Business Unit, Start and End Dates…Dasari Dileep 53 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM
-
Issue with employee's line manager compensation plan approval status SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query by filtering for an employee for testing purposes: se…Valerio Curzi 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…Valerio Curzi 317 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 11 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
expiry date for tasks under journeys are not populating in the backend table for few recordsSummary: Hi Community, we have a requirement to populate expiry date of the allocated task for journeys of an employee,where in the UI it shows the epiry date and not po…
-
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…JDCal 61 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …Valerio Curzi 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…Valerio Curzi 11 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu…Arti P 1.8K views 8 comments 0 points Most recent by Sriram Shashank Reporting and Analytics for HCM
-
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…Valerio Curzi 91 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…Valerio Curzi 366 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
If a EFF does not have a value is there a way to pull it into reporting?Summary: We have some positions that have Extensible flex fields entered for Background checks and Licenses - but some of the positions do not have this yet (so essentia…THawkins_LGI 61 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…Valerio Curzi 197 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte… -
Building a custom report for pay ratesSummary Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.Content The tables hol…User_2025-01-28-05-08-05-606 72 views 2 comments 0 points Most recent by Rajesh Jupudi-Oracle Reporting and Analytics for HCM -
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 21 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
Fast Formula or query retrieving the number of working daysSummary: Content (please ensure you mask any confidential information): Hello experts, it is possible to build an SQL query or Fast Formula retrieving the number of work…Valerio Curzi 260 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
looking for ytd and ptd bip reportSummary: lookind for ytd and ptd bip report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Co…
-
Can i see what a user sees from PER_ASSIGNMENT_SECURED_LIST_VWe have a user downloading a report but seeing just 600 result compared to another users that can see more than 800. The only thing in the report that could prevent him …margherita bonfiglio 23 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 394 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ…Consultant Ian 21 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…Fatima Claire Benito 31 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…Henry Imgrund 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a…Cansel Karasoy 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM