Data Models
Discussion List
-
Need Approval Group Details in GeneralLedgerHi all, I am working on a GL Manual workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments in GL. P… -
How to get the user details to whom termination notification is getting sent from workflow .How to get the user details to whom termination notification is getting sent from workflow notification AssignmentTerminationReport. Objective is to customize template b…
-
Query to find transaction details for stuck 'Time Change Request Approval' process_OTL cloudSummary: We have multiple transactions in 'Stuck' status after a DB outage for a certain date, these transactions don't have any details for the dates/time for which the…
-
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se… -
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 21 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 Started 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 43 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 784 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…
-
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…
-
BI Publisher - Obtain YTD / accumulated balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…
-
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 23 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 22 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 1 view 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 13 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