Data Models
Discussion List
-
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 3.2K 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 21 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 43 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 1 view 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 22 views 1 comment 0 points Most recent by Rajesh Nagpal-Oracle Human Capital Management -
Is there any table which stores Subledger balances for sources like Payables and specific accounts?I need an information about the tables through which Subledger level balances for specific sources like Payables, Receivables and Fixed Assets and specific accounts (GL_… -
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 143 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 …
-
Can i integrate EDMCS hierarchy with HCM?I am establishing an EDMCS instance for a fusion implementation. Can i directly integrate EDMCS metadata to HCM? -
Help with EText Template – Convert SYSDATE from UTC to Malaysian Time (MYT)Summary: Hi All, How can I convert or adjust SYSDATE to Malaysian Time within an EText Template? Any guidance, workaround, or example from your experience would be highl… -
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 74 views 5 comments 1 point Most recent by Shreya Banerjee 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… -
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 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management -
how BIP job that retrieves data from an Oracle Database table containing a BLOB columnWe have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integratio… -
Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee? -
Fast Formula Error : PLS-00123: program too large (codegen operands)Team, We have an extract rule Fast Formula that returns balance values using database items based on element name input. The current code works fine, but we're facing ch… -
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… -
Replace Grade in a Job Code using job.dat HDL loadSummary Replace Grade in a Job Code using job.dat HDL loadContent I want to replace a grade in an existing job code using HDL. Below is a sample. I want to replace E04 w… -
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 34 views 2 comments 0 points Most recent by KarthikDamamkar Human Capital Management -
Custom tokens are not showing in Preview Offer LetterSummary: Hello, I created a custom data model for our Offer Letter template and tested it using both RTF and PDF output formats. When I run the report directly, all the … -
Value Set Query to Get Unique Assignment DetailsHi Team, Need input on Value set Creation to get unique assignment details out of multiple rows. Currently, I am using the below query which gives me 2 rows, due to same… -
how to get assignment work terms number in fusion data intelligence oac fdiSummary: how to get assignment work terms number in fusion data intelligence oac fdi Content (please ensure you mask any confidential information): how to get assignment…RajaGangavarapu 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
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 161 views 10 comments 0 points Most recent by Ravi Tilekar Human Capital Management -
Which attribute stores the Term correction reason for reportingSummary: We are trying to build a report to fetch the reason change that was entered as part of Termination correction, but we do not see any table storing this update m…Tumpa Mandal 11 views 5 comments 0 points Most recent by Cristina Greyling - Oracle-Oracle Human Capital Management -
Transaction console data along with the approver name.I have created a report to fetch the all the transactions details from the transaction console, along with the transaction id , process name and approvers name and some …Jagruti2408 66 views 1 comment 0 points Most recent by B S Rafatullah-Oracle Human Capital Management -
How lexical parameters are replaced in fusion BI reportHow is lexical parameter like &LP_FA_DEPRN_DETAIL getting replaced in Form 4562 - Depreciation and Amortization Report. -
What Value should be provided to Lexical parameter for Seeded Report Data modelHi All, What value should be provided to below Lexical parameter for Seeded Report Data model of Uninvoiced Receipts Accrual Report ? &ACCRUAL_ACCOUNT &CHARGE_ACCOUNT Th…