Data Models
Discussion List
-
Reverse Termination - Comments stored?Summary: Reverse Term Comments for custom report Content (required): Which HCM table stores Comments from Reverse Termination UI Version (include the version you are usi…User_2025-02-12-15-41-59-245 21 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle HCM Integrations -
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…User_2025-02-12-15-41-59-245 21 views 6 comments 0 points Most recent by Kathan Bhatt-Oracle Human Capital Management
-
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…Evgeniya Repnina 51 views 2 comments 0 points Most recent by Evgeniya Repnina Human Capital Management -
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… -
HCM Extract failure notification email content customizationSummary: Is it possible to customize the HCM extract failure notification email content? Content (required): We have a requirement to customize the HCM Extract failure n…Venkateswaran Murali-Oracle 52 views 0 comments 0 points Started by Venkateswaran Murali-Oracle HCM Integrations
-
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…Shelly Feyerherm 256 views 5 comments 0 points Most recent by Shanna Oppenheim Human Capital Management -
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 113 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 Capital Management -
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… -
full outer join in BIP fusionHi, I have two queries and I want to use full outer join in BIP but it does not work. I am using select * from t1 full outer join select * from t2 on t1.A = t2.A but giv…Morad Alshammari 31 views 10 comments 0 points Most recent by Morad Alshammari BI Publisher Learning Center -
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…Frank Cowell-Oracle 36 views 1 comment 2 points Most recent by Alina C.-Oracle Human Capital Management -
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 61 views 7 comments 0 points Most recent by MandeepGupta Human Capital Management -
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 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.…
-
Sample HDL or Spreadsheet file for Competency Talent profileContent Does any body have any dat file or sample file for Competency load in talent profile ? We are trying to load competency to Talent profile but it not working. We …
-
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…Giuseppe Cannova 72 views 6 comments 0 points Most recent by Giuseppe Cannova Human Capital Management -
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 71 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need Connection/Join between Business Unit and Legal Employer User EntitySummary: Grouping and summation by Legal Entity and Business unit I am trying to develop a Payroll Balance related HCM Extract where I need to group the data based on Le… -
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…User_2025-02-07-06-30-13-200 21 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Human Capital Management