Data Models
Discussion List
-
sample query to fetch contingent workers along with their locationSummary: Can I get a query that fetches all the list of CWK and their associated BU,LE & Locations ( Active Assignments ) Content (please ensure you mask any confidentia…Mohammed Ehteshamuddin 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Sample query to fetch person detailsHello, Can anyone please provide a sample query that would fetch "Person Name, Person Number, Assignment Status, Location, Person Type, Business Unit, Legal Employer", J…Mohammed Ehteshamuddin 12 views 1 comment 0 points Most recent by Nivya Mathire Human Capital Management
-
Need columns 'Destination Quick Move Phase' and 'Destination Quick Move State' in BIP ReportSummary: I want following columns in a BIP report - Process Name, Phase, State Name, Destination Phase, Destination State and Comments. I am able to fetch all except des…
-
Need columns 'Custom Filter's Context' and 'Add Custom Filter' in BIP report from Career site - IRCSummary: I am building a BI query to take out all the basic details of career site, here, I have requirement of two more columns 'Custom Filter's Context' and 'Add Custo…
-
Is there an OTBI/BIP Report for Employee Personal Information Change Transactions?Summary: Looking for an OTBI/BIP Report for Employee Personal Information Change Transactions! Content (please ensure you mask any confidential information): Checked the…
-
Position Override Flag Changing After HDL LoadSummary: Hello, We are doing a full load for UAT. I have position override set to Y for all active workers. Yet when I load the data it changes to N for some. WHY?? And …
-
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 Track Article View Counts in Oracle Fusion Knowledge Management (Self-Service, Email, SR)?We are using Oracle Fusion Service Cloud (Knowledge Management) and would like to understand how to track article view counts across different channels and roles. Specif…
-
Is it possible to determine if a workflow notification is an FYI or Request for Approval?We are exploring options to add additional text to an FYI notification to line managers to provide more guidance on what they need to do. We would therefore like to have… -
Impacts on Tables post enabling redwoodHi Team, In lower pod, we have enabled Redwood Profile options and we would like to know about the impacts on the tables, viz we have come across a scenerio wherein for …Ameeque Ahmed 14 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management
-
EMGW : E-Signature BLOB characters are restricted under 4000 characters in BI ReportsSummary: The requirement is to retrieve the E-Signature from journey's screen in BI Report using data model query. since it is a BLOB(Binary Large Objects) .it restricti…
-
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 2.9K views 13 comments 1 point Most recent by User_FR8AH Human Capital Management
-
Request for Details on Employee Usage Calculation for SaaS BillingSummary: We are reviewing our Oracle SaaS usage and invoices and need clarification on how the employee usage count is determined for billing purposes. Specifically, we …User_2RSEM 23 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 32 views 3 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch number of preboarding journeys assigned to employee and candidatesSummary: write a sql query to fetch number of preboarding journeys assigned to employee and candidates Content (please ensure you mask any confidential information): Ver…
-
Could you please advise if this can be achieved within the Directory or Reporting frameworkI hope this email finds you well. We would like to build a report in Oracle Fusion HCM Directory that displays the organization structure in a tree format (tree with bra…Mohammad Hussein 2 views 2 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
where can i find the XML data generated for the HCM WorkFlow approval NotificationsSummary: I have requirement to edit(add new field) the HCM Workflow Approval Template. where can i find the XML Generated for the HCM workflow approvals(eg:- Termination…KarthikDamamkar 13 views 1 comment 0 points Most recent by Rajesh Nagpal-Oracle Human Capital Management
-
Document Number is empty in FND_DOCUMENTS_VL tableSummary: Hi all, I have an issue when I try to retrive a file loaded on a Document of Record. I use this query because I need to retrieve DM_VERSION_NUMBER,DM_DOCUMENT_I…teresa.marciano 113 views 16 comments 0 points Most recent by David Huang-Oracle Human Capital Management
-
Incumbent on positionSummary: I cannot see the Incumbent Position Entry Date, Position Exit Date, Status, Type information in any columns in the hr_all_positions_f and hr_all_positions_f_tl … -
Oracle HCM Cloud: HSDL for Seniority Date updatesContent Oracle HCM Cloud: HSDL for Seniority Date updates. We are trying to create an HSDL template for Seniority date updates but it seems there is a structural issue w…User_2025-02-10-08-35-40-989 77 views 5 comments 1 point Most recent by Shreya Banerjee Human Capital Management -
Change Working Hours approval notification template shows old template in RedwoodSummary: Change Working Hours approval notification template shows old template while submitting via Redwood UI . Showing correct template while submitting via Responsiv…M Santoshi-Oracle 41 views 7 comments 0 points Most recent by Maria Smith- de Novo Solutions Human Capital Management -
Tables store transaction console approver name showing as AssigneeSummary: Tables store transaction console approver name showing as Assignee Content (please ensure you mask any confidential information): Hi, I'm looking table name whi…
-
Under HCM only license, capture Department Costing under GL Cost Centre.Under HCM only license, can we capture Department level cost under 'GL Cost Centre' ( Which is used by ERP) ? And if we do would we have any downstream implications? Als…
-
SQL query with BIP tables which gives Approval details for Compensation worksheet in Fusion hcmHi Team, We have requirement with below approvals on Compensation worksheet. The initial manager submits the request. The initial manager’s manager provides the first le…
-
See department tree status in tableHi, We want to see the status of our department trees in a data model. In what table could we see this?Nick H 2 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
BI Audit Report/Tables connection errorSummary: We are seeing below error when user is trying to run a BI Report which fetches data from fusion iau viewer.bipublisher_v table to capture report access timeline…Venkatesh TR 15 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
How to see pending or rejected transactionContent HR transactions are submitted by HR (like Change Department on Assignment or Increase Salary) ,until the transaction is approved ,anyone would not able to see it…
-
BIP report to extract approval history and transaction historySummary: BIP report to extract approval history and transaction history for JRs Content (please ensure you mask any confidential information): Hi all, I need to create a…
-
In Redwood Resign from Employment-Termination details not displaying in Approval notificationSummary: We have migrated to Redwood V3 Resign from employment. when the Employee Resign from Employment, the approval goes to the Line Manager and HR VP. Though they se…Saranya B-Oracle 130 views 2 comments 0 points Most recent by Saranya B-Oracle Human Capital Management
-
Transaction Console WorkFlow notifications(FYI And FYA) in HCMHello Everyone, we have a few requirements from customer regarding the changes in FYI- For You Information and FYA-For your Action notification templates which user rece…KarthikDamamkar 16 views 2 comments 0 points Most recent by KarthikDamamkar Human Capital Management