Data Models
Discussion List
-
How to find missing privilege to get archive and unarchive options on reportsSummary: How to find missing privilege to get archive and unarchive options on reports Content (required): Hi Team Greetings! The archive and unarchive options are not s…Parag Hiremath 441 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Date start is different in backend.Summary: Date start is different in backend. Content (required): Hi Team, For an Employee, in the employment page the hire date is showing as 05/16/2022 but in the per_a… -
Can we add Reference number to Letter Reports generated using Document of Records.?Summary: We have a requirement to add reference numbers in letters generated using DOR. Content (required): Users want to add the following reference number format in le… -
Embed BI data model based report in fusion HCM pageSummary: Can we show the data from BI report(Data model based) in the employment page in HCM ? I need the data to populate in same page as a table instead of opening as …
-
Edit Termination -- How to identify if the termination has been correctedSummary Edit Termination -- How to identify if the termination has been correctedContent Hi Experts I would like to see if there is a way for us to identify if a termina… -
HDL WORKER LOADSummary: Hi All, I am trying to load Non workers through HDL and I'm always getting the following error: Error: An error occurred while processing your data set: java.la…Padamatinti Varsha 191 views 3 comments 0 points Most recent by MilanMohanty Human Capital Management
-
Issues in 22B for HCM Extracts and BI PublisherSummary: Hi All, Below are the issues that we have encountered post 22B upgrade: INBOUND INTERFACE type not available while creating/developing the HCM extract. In globa… -
Roles associated with reportsSummary: Can we create a report to identify all the roles associated with different reports in OTBI ? Content (required): Version (include the version you are using, if …Saurabh Pratap Singh 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Human Capital Management -
Workflow notifications data model customizationSummary Configurable workflow notifications customizationContent Hi All, We are trying to customize manage individual compensation approval notification using BIP Workfl…
-
Need to convert 24 hr time format to 12 hr time formatSummary: Need to convert 24 hr time format to 12 hr time format Content (required): Hi I trying to fetch a column from Assignment page where in the UI it shows 12 hr for…
-
Disable BIP Report Scheduling Option for UserSummary: Disable BIP Report Scheduling Option for User Content (required): Is it possible to disable scheduling option for BIP report for certain roles? Version (include…
-
User Preferences not reflecting in BIP NotificationsSummary: User Preferences not reflecting in BIP Notifications Content (required): Hi, User has set his preferences for Date , Time and Number format in his Regional Sett…
-
Help creating a table to use as BIP Bursting delivery data sourceI am seeking additional documentation or white papers describing how to create a table for use as a delivery Data source for bursting with more detail. I have read the O…
-
FYI notification changes not reflected in BIPSummary FYI notification changes not reflected in BIP notificationContent Hello All, I modified seeded BIP FYI notification template and added in custom folder. It worke…
-
How to add two legal entity's for one countryHi Team, For coming one country we have only one legal entity so we gave as haou.name='x' but now we need give two legal entity's for one country that is x and y how to …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center -
Loading global transfer workers through HDL.Summary: Hi All, I am trying to load Worker.dat file and the following is the error occured: An error occurred. To review details of the error run the HCM Data Loader Er…Padamatinti Varsha 52 views 2 comments 0 points Most recent by MandeepGupta Human Capital Management
-
Requirement: Client wants to update Job and Position for multiple employees on the assignment pageSummary: Content (required): Hi Expert, A client wants to update multiple jobs and positions for multiple employees using HDL or SHDL. If anyone is having any templates,…
-
Need inputs to find the Report Name/HCM Extract Name based on the Bursting emailSummary: Need inputs to find the Report Name/HCM Extract Name based on the Bursting email Content (required): We got bursting email notification but we need to know on w…
-
Hyperlink in BIP RTF Template not workingSummary: Hello - we are using an RTF template which includes a hyperlink to an external site on a BIP report with a bursting condition. The hyperlink works fine in Word/…Shanna Oppenheim 11 views 2 comments 0 points Most recent by Shanna Oppenheim Human Capital Management -
Tables and Views for HCM Documentation Available as PDFSummary: Is there a PDF version of the "HCM Tables and Views for HCM" online documentation? Content (required): I am looking for a PDF or other consolidated version of t…
-
Reports and Analytics- Folder Security changes after 22a?We are noticing changes in security access to BI Publisher reports in our Custom Reports and Analytics Folders and Sub Folders. Example 1: Employees with only the Employ… -
Need SQL query to get the past dated managerSummary: Hi, The content is, since for inactive employees the manager information will not be there after the LWD, Need a query to get the past dated manager(who was the…
-
Please assist on my code I'm unable to find where is wrong in join conditionsselect DISTINCT papf.Person_number, ppnf.Full_Name, pni.NATIONAL_IDENTIFIER_NUMBER, Pn.PASSPORT_NUMBER, pp.attribute3 as "Business Card Title", to_char(ppos.ORIGINAL_DAT…AjayKumar Maddipati 21 views 20 comments 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
Trying to generate a report with parametersSummary: Hi - Im trying to generate a report that has two parameters when I activate the report task in Journeys for a promotion letter. I can generate the rtf, but the … -
Getting Log of ESS JobsHi Experts, We have a requirement to get the log of ESS job from fusion. Any pointer will be helpful like table name to get document Id or REST API to get this detail?Rajeev Nayan 21 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
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…Stefaan Onderbeke 31 views 3 comments 0 points Most recent by Stefaan Onderbeke Human Capital Management
-
BI Publisher Report producing values for next row when values cannot be foundHi all, Hoping you can assist me with some off behaviour that I am experiencing when producing a report in BI publisher. We have written a data model that when run appea…Luke.Findex 11 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
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…Faizan Rashid 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management