Data Models
Discussion List
-
Customize report directory printSummary: Content (please ensure you mask any confidential information): Hello everyone We're customizing the directory printing report. Therefore, among the selectable p…Gerardo Peluso 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
need the translate table where we can get the state columnSummary: We have tried to apply the translate column from the associate table Content (please ensure you mask any confidential information): we wanted to include the tra…
-
Create external bank account for an employeeDear All, I hope this message finds you well. I am writing to seek assistance with two issues related to external bank accounts in Oracle Fusion. 1- Viewing External Ban…
-
How to read content of attachment of Document of RecordSummary: How we can read the content of attachment attached to DOR. Content (please ensure you mask any confidential information): We have requirement to read the conten…Alpesh Sanghvi 21 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management
-
Report parameterized with person_id inside journeySummary: Content (please ensure you mask any confidential information): Hello everyone We're experiencing issues with a report to be included in a guided journey. Specif…Gerardo Peluso 23 views 2 comments 0 points Most recent by Gabriele_Cristofalo Human Capital Management
-
How to Convert Contigent Worker into EmplyoeeSummary: Hi Experts, Please confirm. How can we convert a Contingent Worker into an Employee? and after conversion, the contingent worker history is maintained in the sy…
-
Validate transaction console complex triggered approval rule on a completed transaction.Summary: I'm looking to review completed transactions details to see that the correct approval rule has been triggered in the change salary transactions we have had subm…Georgia Puddifoot 11 views 0 comments 0 points Most recent by Georgia Puddifoot Human Capital Management -
Clarification Required on Seniority Dates Data Fetching in Oracle HCM BI Report.Summary: A person having 2 Seniority entries- one for worker type as "Pending worker" and other for "Employee" is existing for below Seniority codes- "Legal Employer Sen…Amit Khadakabhavi 41 views 2 comments 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Human Capital Management
-
How can we store a BI Report (PDF) in the Document of Records without using HCM Extracts?Summary: We have configured a journey for Associates in which they receive a document as part of their task allocation. When an Associate is assigned a task, a correspon…
-
CreatePosition rtf template- DFF not showing in notification templateSummary: Hi Experts, We are trying to add custom DFFs in the CreatePositionrtf template. We modified the template but the DFFs attributes are not showing up once the pos…Revathi Thangaraj 21 views 4 comments 0 points Most recent by Revathi Thangaraj Human Capital Management
-
SQL Query to fetch all Notification details (approval, fyi and reminder notifications).Summary: Need SQL Query to build a Report to fetch all Notification details (approval, fyi and reminder notifications) sent in 2024 for some particular employees. The re…Saurabh Maheshwari 925 views 5 comments 0 points Most recent by Jamie Walsh Human Capital Management
-
How to convert User Defined Table text to date in BI PublisherHello I'm trying to work with a User-Defined Table (UDT) and am running into reporting issues working with the data in BI Publisher and am looking for help. The business…
-
How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured o…Sonia Choudhary 1 view 0 comments 0 points Most recent by Sonia Choudhary BI Publisher Learning Center
-
Need to Fetch Last Updated Records in ess_request_history tableI’m building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’t find a 'last update…
-
Is there any consolidated excel available module wise listing all deep links till 25CSummary: Hi Team, Need the complete list of deep links available in oracle fusion till release 25C. Is there any document available for the same or is there a way we can…
-
Is there a DM Table or Subject area to track log in timesSummary: Is there a DM Table or Subject area to rack log in times Content (please ensure you mask any confidential information): Version (include the version you are usi…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 21 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
Job Requisition Notification is emptyWe have a problem viewing the content of the Job Requisition notification content from the bell icon or in the worklist. It went through an approval cycle to be approved…Mayar Mohamed 23 views 1 comment 0 points Most recent by Emil M-Oracle Recruiting, Opportunity Marketplace
-
How can I build an ASL report in BI Publisher with supplier, item, and organization names?Hello, I am currently building a BI Publisher report based on the PO_APPROVED_SUPPLIER_LIST table. The report works fine when using this table alone, but I need to enric…
-
How to create Alert Composer filter with a fixed date?Summary: How to create Alert Composer fileter with a fixed date? Content (please ensure you mask any confidential information): Hi experts, I cannot get it to work. Is t…Volodymyr Faranosov 4 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management -
DBI'S and Functions related to workforce scheduling module.Hi Team, I would want to know all the DBI'S, and Functions related to workforce scheduling module to use in our custom fast formula to get working days and all.M-HCM 11 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
Issues with OTBI while extracting Person contact InformationSummary: We are developing a demographic report using OTBI in which we need to display Person contact information such as Contact Tel. # and Address. However, we are fac…
-
Table of position request changeHello, We'd like to know if anyone could help with a table or query that might might help extract data in the Position Request Change in the below screenshot. Thanks
-
Hide Seeded line manager dashboardSummary: Hi everyone, We’re aiming to hide the seeded Line Manager dashboard from managers. However, since it’s a delivered (seeded) dashboard, we’re unable to restrict …Saksham S 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
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
-
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…