Data Models
Discussion List
-
How to extract referential data from Oracle HCMSummary: How to extract quickly referential data from Oracle HCM, for example the list of countries (territories). Content (required): I'm new to Oracle HCM, coming from… -
Want to know who created and when created the person record in person management?Summary: Want to know who created and when created the person record in person management? Content (required): Hi Team, Want to know who created and when created the per… -
What is the OTBI subject area for Collection functionSummary: Content (required): Hi Expert, We just want to know what is the subject area name to get the data for collection. Version (include the version you are using, if…
-
Absence Balances – Resignation – Current Balance and Balance at TerminationSummary: How to display Absence Balances, As-of Date: Current and at Termination Date? Content (required): Embedded OTBI report in Resignation. Report displaying Absence…
-
No Negative YTD Pre-Tax Deduction Balance ReportSummary: Need to create a custom "No Negative Pre-Tax YTD Balance Report Content (required): Not sure if an existing OTBI Data model exists? And should an HCM Extract be… -
Table name for retrieving representative information shown on pubic info page for an employeeSummary: I need to write a BI publisher report where I need to fetch the representatives assigned to an employee based on AOR as shown in the screenshot below .Below we …
-
HCM ReportsHello dear community, I want to know which report exists for every module in fusion hcm. Thanks, Octa -
Where to find Loqate Geography Reference Data for FranceSummary: Content (required): I've found the information in Oracle HCM Implementation Guide that the Loqate supports 82 countries for loading Geography Reference Data. Bu… -
Folder restriction for OTBI sideHow can I remove BI catalogs or make them invisible to users? Users are having difficulties because there are too many folders. For example, we only want to see TAV fold… -
How to remove ORA_BIP_APPROVE_START, ORA_BIP_APPROVE_END displaying on NotificationSummary: Resignation Custom/Configurable Notification - How to remove ORA_BIP_APPROVE_START, ORA_BIP_APPROVE_END and ORA_BIP_SUBMIT_START not to display on notification(…
-
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Checklist Task Email Notification TemplateSummary Templates for checklist email notificationsContent Can someone let me know where to find the templates for the checklist email notifications? We are using the of… -
Need to know tables used for storing geographies for use in BI publisher reportSummary: Need to know tables used for storing geographies'.This info will be used to extract list of all cities and states visible on geography hierarchies for India loc…
-
Looking for HDL file to load the data into the created dff in DORSummary: Content (required): Hi Expert, We have created some dor and in dor we have created a date dff and we want to load the data in it. Please provide the .dat file i…
-
Requirement: How to identified if a notification is standard or BurstingSummary: Content (required): Hi Expert, There is a notification triggering but I am not able to identify is a standard notification or is a bursting notification. Versio…
-
Default Expense Account is not acknowledged in Requisition Charge AccountHello, We have a worker.dat file which successfully updates the employee default expense account:…James Coles 42 views 3 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
HR Core: Employment model choiceSummary: Our industry is the public sector. Country Italy. Only one Legal entity. Scenario: every person can have 1 contract and multiple asg. we're about to set up the …Rebecca Tosetti - Oracle-Oracle 31 views 3 comments 0 points Most recent by Rebecca Tosetti - Oracle-Oracle Human Resources -
BI Report to print position hierarchy chartSummary: Hi, Looking for the custom BI Report to get the print of the position hierarchy. Content (required): Below Idea logged to enable the print functionality with po… -
Unable to properly attach ESignature document to Esignature TaskSummary: The report path is being directly pulled from OTBI as well as the name of the document, the .xdo?P_SIGN_DATE={SignDate}&P_SIGNER_NAME={SignerName}&P_SIGNER_EMAI…
-
HCM Talk Radio: HCM Cloud Environment Sizing GuidanceSummary HCM Talk Radio: HCM Cloud Environment Sizing GuidanceContent Are your Cloud environments sized appropriately for your operational needs? Listen in to HCM Talk Ra… -
How to fetch Employee PII information (Address, Phones) in a BIP ReportSummary: We have a Scheduled BIP report which fetches employee address from PER_ADDRESSES_F table. This was working fine. But recently, the table not returning any recor…Christopher Jothi - HCM-Oracle 41 views 7 comments 0 points Most recent by Mandeep Gupta Human Resources -
Having trouble getting this table-based Value Set to workSummary: Value Set in Fast Formula Content (required): I have been wracking my brain all night/day on this one. The SQL works fine in BI but when I use it as a Value Set…
-
How to read content of the DOR attahmentContent (required): Hi, How can we read the content from DOR attachment? We would like to get the content of DOR attachment in report. below query gives me UCM id and fi… -
How to download the attachments from transaction table?Summary: How to download the attachments from transaction table? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…
-
Unable to navigate to "Page Composer" from Sandbox in Change Assignment PageSummary: Hi Team, We are facing a problem where in we are unable to navigate to "Page Composer" in Change Assignment page from a Sandbox. The error faced is as attached.…
-
Where are Sandox details stored?Are they in tables or as files in SoA layer?Summary: Where are Sandox details stored?Are they in tables or as files in SoA layer? Content (required): Where are Sandox details stored?Are they in tables or as files …
-
Upload and delete massive dataSummary: Hello dear community, I want to know how could I delete all the data in my fusion test environment and how could I reset the settings to start from zero? Also h…
-
Configuring User-Defined TableSummary: I am looking for best practices and clear instructions guide for setting up a user-defined table in HCM to store recruitment related information. Content (requi… -
How to get the total Headcount of Employees and contract worker on monthly basis.Summary:We were trying to fetch the Hire and Terminations on monthly basis in OTBI. Please find the Attachment for your Reference. Content (required):We are trying to cr…Harish.M 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Extract correct hourHello everyone, I would need to set when I extract a date to the date set on the system's regional preference. That is, get the correct timezone based on the settings sa…Alfonso Alfano 21 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Human Resources