Data Models
Discussion List
-
Is there a table where I can find the name of a deleted Document of Record attachment?Summary: Hi. I'm trying to create a custom audit report that lists any attachments that have been deleted from a Document of Record type. I can't seem to find any table … -
What are these apps and what is the use of itApps Available Under Others Tab What are these apps : Resource Directory and My Dashboard What roles have access to them?Mohammed Khair 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management -
Is it possible to add the Parent Position Code Field to the Workflow Notification/Approval window?Summary: Is it possible to add the Parent Position Code Field to the Workflow Notification/Approval window that is generated from the delivered Workflow Notification Dat… -
need HDL to load workday definitionSummary: after clicking on working hours(i have marked as yellow) this assignment hour details comes, for that we want HDL to load workday definition is there any templa… -
BPM Worklist Transaction Report based on BPM worklist transaction statusHi, We are building a report to pull the list of transaction from BPM Worklist including Transaction information, Person information, assignment information along with a…Haryi 62 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
To track HCM Key Configuration changesSummary: Hi , Looking for ways to capture HCM key configuration changes like setup data , what configuration changes are made , the user who made the changes and all. We…Phani S-Oracle 23 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Human Capital Management -
Report organizational chart - as ConnexionsHello, I would like to get or create an export that would reflect my organization chart (as an extract of Connexions). Ex : Manager level TOP Manager level -1 Manager le…Jacqueline GRANDIN 2 views 2 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Query/SQL for datamodel in BI Publisher of Other Addresses in Location PageSummary: Hi, Do you know via datamodel/BI Publisher in what table other addresses for locations are stored? We do not find them either in: HR_LOCATIONS_ALL_F_VL or per_l…Pilar F. 12 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 62 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management -
Is it possible to query or export approval rules + conditions for a transaction?Summary: I want to export the configured rules and conditions for the Manage Employment approval rule (Transaction Console > Approval Rules). How can I do this? Is there…
-
Person Name Style for Germany: need to use Birth Name fieldSummary: We have a requirement for Germany to user "Birth Name" or Nam_Information3. Why can't we use this field in Person Name Styles? This field has been part of Germa…Bianca Lei Villareal 43 views 3 comments 0 points Most recent by User796018-Oracle Human Capital Management -
Accrual Balance mismatch - QueryHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t…Saurav R-Oracle 3 views 1 comment 0 points Most recent by Ashwini Abhishek-Oracle Workforce Management -
You Do Not Have Permission To Add Users Other Than Yourself As Direct Recipients - ErrorHi, We're encountering the following error: "You Do Not Have Permission To Add Users Other Than Yourself As Direct Recipients." Please find the attached screenshot for r…Saurav R-Oracle 60 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management -
How can we modify this logic to ensure the correct date is displayed in the notification?Summary: Content (please ensure you mask any confidential information): How can we modify this logic to ensure the correct date is displayed in the notification? The not…
-
The notification received is Redwood Users Delegation Roles.Summary: Content (please ensure you mask any confidential information): The notification received is Redwood Users Delegation Roles. I need to know the OTBI path for thi…
-
Unable to find the table which captures the Appointment related details into case in Case ManagementSummary: I am not able to find the table which will capture the Appointment related details when we create a appointment with case in case Management. Can anyone help me… -
Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g… -
OTBISummary: Hello Everyone, Unable to access OTBI reports data, able to access BI reports using her current roles Thanks Krishna Content (please ensure you mask any confide…Krishna Sigilipalli 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
WF Notification customization for Comp not showing few field added to DMSummary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not… -
In which table comments from Document of Record page are availableSummary: I need to fetch comments from Document of record page in my BI report. I already used comments column from HR_DOCUMENTS_OF_RECORD table but it is giving blank d… -
activate user and assign role using HDLSummary: Hi all, Wanted to active one inactive user and assign role thru HDL. Can we do that ? Content (please ensure you mask any confidential information): Version (in… -
Worklist forms displayHello we have an enhancement request to add additional fields on the worklist being displayed in the following navigation Bell Icon > Show All > Click one of the Notific…pmarquez 1 view 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management -
When will Fusion Middleware technologies happen every year for cloud customers?Summary When will Fusion Middleware technologies happen every year for cloud customers?Content When will Fusion Middleware technologies happen every year for cloud custo…User_2025-01-22-19-57-20-732 22 views 3 comments 0 points Most recent by Parag Hiremath Human Capital Management -
What is the specific report template to which 'Edit Work Relationship' transaction points ?Could someone please confirm which seeded report template and data model (DM) are being automatically utilised for the 'Edit Work Relationship' transaction? There are tw…Aseem Bhawalkar 1 view 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
General Letters for Document Record is not getting proper values in Draft file.Summary: Unable to get the values in the template in Draft version and final version(after approval created a auto generated file) Content (required): I have created a D…Ritu Surve 102 views 8 comments 0 points Most recent by Pavan Kumar Thummalapalli Human Capital Management -
Need to extract clob field has html dataSummary: Hi Team, We need to extract the clob file that contains the HTML data. I wanted to know if the clob file could be extracted in the same way as the front end. Th… -
how to delete bulk rows in User-Defined TableThere are 50+ records in the user defined table Column, Column can not be deleted when it has child rows. Without deleting the rows manually, Is there anyway which can b…Sugenthiran Dinesh 78 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management -
Is there any way to store Signature image other than RTF template to use dynamically in lettersSummary: We have used Signatory using RTF templates where we are facing issue as it was dynamic for every update in signatory we need to change the signature more freque…RamyaK 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Organisation Structure Oddity (HR Reports)Afternoon folks, I have a weird one for you today. One of our HR Systems Advisors has encountered a bizarre malfunction in our data pull back. They (and one other) are c… -
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca…