Data Models
Discussion List
-
Redwood Identification info - Condition not workingSummary: Hello, According to the Documentation from 25A release, we should be able to use Citizenship and issuing country as condition attributes, if we need to create r… -
SQL to fetch the status of performance documentHello Experts, I am currently working with a BIP report and can't find this status field of performance document, Does anyone know where or what table should I pull this…
-
New Field Added but no data in the field in the HCM Workflow approval Termination reportSummary: Following below document i was able to add a field to the standard report, but could not fetch the data in that field. (Doc ID 2647434.1) https://support.oracle…KarthikDamamkar 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
V3 Seniority Date HDL file for manually adjusted datesHi Experts, We ran "Seniority Dates V3 - Remove Seniority Dates Transaction Data" Diagnostic process to removes seniority date for the certain configured rules. While ru…
-
Is there a way to dynamically pass the instance name (PROD, TEST, or DEV) into the Alert Composer?Summary: Is there a way to dynamically pass the instance name (PROD, TEST, or DEV) into the Alert Composer body? Content (please ensure you mask any confidential informa…Volodymyr Faranosov 1 view 0 comments 0 points Started by Volodymyr Faranosov Human Capital Management -
Need Table details storing User information created in Security ConsoleSummary: We need to get the information of User like First Name, Last Name, username and email id of the user created in Security console. Content (required): Person inf…
-
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…
-
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
We Need to build BI Report in Oracle HCM to fetch parameter used in BI Report.Summary: We Need to build BI Report in Oracle HCM to fetch details of BI Report such as Report Name, Report Path, Parameter, submitted by, If it's schedule or ran manual…
-
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 41 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 21 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…
-
Generate multiple Excel sheets based on parameter valueHi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel outpu…Sonia Choudhary 11 views 0 comments 0 points Started by Sonia Choudhary BI Publisher Learning Center
-
HCM Extract - Extract Employee Contact Details when multiple contactsSummary HCM Extract - How to Extract Employee Contact Details when multiple contactsContent Hi In one of the HCM Extracts we are extracting Employee Contacts. The user e… -
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…
-
bi report and otbi svswe have svs but is possible to have bi report and otbi with svs apply? how can i do?
-
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 11 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 3.1K 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 42 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 21 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 142 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 …