Data Models
Discussion List
-
Requirement for Capturing User Details on Candidate Profile Label CreationSummary: Business requirement regarding the tracking of user activities on candidate profiles. Specifically, we need to capture the following details when a user creates…Nachiketa Das 31 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Recruiting, Opportunity Marketplace -
a way to add additional person numbers to PER_EXT_SEC_PERSON_UE filter AND w/ SQLSummary: Hi forum: Cannnot remember SQL syntax to APPEND additional person numbers to PER_EXT_SEC_PERSON_UE filter without using 'IN' clause so extract XML file breaks o…
-
How to add an attachment in a BIP NotificationSummary: How to add an attachment in a BIP Notification Content (please ensure you mask any confidential information): Hi, we created a BIP Notification. We created the …Barile Alberto 51 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Is it possible to add an LOV behind the Value field on a Value Set?Summary: Hi Community, Our customer is looking forward to create a table of important setup for them inside a value set. This table stores specific codes for cities and …Pilar F. 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Is it possible to setup Unique Key's for DFF inside a Value Set?Summary: Hi Community, Our customer is looking forward to create a table of important setup for them inside a value set. This table stores specific codes for cities and …Pilar F. 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
How to send data from one dataset to another dataset?Hello guys, I have created one data model in which two datasets are there. is there any way to get data from one dataset to another dataset in bi publisher? for eg. I ha…Parthiv_Patel 240 views 3 comments 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
With Root = Person DG or Assign DG to get Comp DG ( to get Comp DBIs from PER_EXT_CMP_FEED_PLAN_UE)Summary: Hi forum Looking to pull these DBI attributes into /add to HCM Extract where root DG = 'PER_EXT_SEC_PERSON_UE' Or Assignment DG 'PER_EXT_SEC_ASSIGNMENT_UE' belo…
-
BIP report to fetch department changes record for employeeRequirement to fetch all the records where department attribute is being changed irrespective of action and action reason for an employee. For this we are comparing prev…
-
HCM Extract - Need help to get 'Previous' Job code / Job name SQL for VS/FFSummary: Hi I need to add these 2 columns in an HCM Extract (Assignment DG) that is sub to Person DG, Work Relationships, Work Terms hierarchy above Assignment DG Lookin…
-
to retrieve transaction details and log details for Error/Warning Messages appearing on Oracle UISummary: When business process change transactions are submitted with missing or incorrect information or for validation oracle displays the standard oracle error or war…sonawaav 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
For ICP failed transactions not able to get the plan name from the report diagnostic and by running.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 24D (11.13.24.10.0) Code Snippet (add…
-
I am attempting to End Date some Recurring Element Entries and need to find the Source System IDSummary: We are updating a number of Element Entry's for employees with updated information. I am attempting to do so through an HDL but have been receiving the error "T… -
Report to show View Count on Knowledge ArticlesSummary: Report to show View Count on Knowledge Articles Content (required): We are looking for a report which shows the number of views on published Knowledge Articles/…
-
BPM Worklist Transaction Status LOVHi, We are building a report to pull the list of transaction from BPM Worklist. We want to use Transaction Status as one of the parameters for this report. We need help …
-
Per_user_roles or ase_user_role_mbr to be used for Reporting ?Hi , We are trying to develop a BI report to extract all User assigned roles and privileges along with the effective date information . Which table is considered best to…
-
List of Standard Duty and Data Roles for Oracle Fusion HCMSummary: List of Standard Duty and Data Roles for Oracle Fusion HCM Content (please ensure you mask any confidential information): Dear Community, Similar to the post (h…
-
How to trace donated hoursGood day! is there a way in SQL to connect/trace donated hours of the employees involved? I'm only able to see who donated but cannot connect to who received those donat…notautomni9 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management -
what is the difference in oracle cloud hcm core from legalentityID to legalentityorganizacionid?Summary: Content (please ensure you mask any confidential information): what is the difference in oracle cloud hcm core from legalentityID to legalentityorganizacionid? … -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…
-
Error while loading the French names to Document typesSummary: Hello Everyone, Greetings of the day!! We have a document type with the name T2200 in the system. Now we are trying to load the french name(Transalated name) of…
-
I need a query for the last updated dates made to audit approval rulesSummary: Data extraction for audit purpose - last updates made to our approval rules Content (please ensure you mask any confidential information): I need a query for th…Global Support Desk 11 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Need help in getting the query to fetch Candidate Extra Info from ORCSummary: I have been trying to look for tables that stores the Extra Info section details on the Candidate profile in ORC. If anybody has worked on it, can you share the…Rini_Varghese-Oracle 11 views 1 comment 0 points Most recent by Rini_Varghese-Oracle Human Capital Management -
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Need help with Loopback Integrationshttps://us.v-cdn.net/6034893/uploads/Y2EH05POYKRM/loopback-integrationsref-15.docx We are exploring the option of "Loopback Integration" previously known as "Inbound Int…
-
Link between the gl/xla tables and tax tablesHello, I need to display the tax information (tax code, tax rate) for Journals having source 'Tax' (Note that these are journals created using the 'Create Taxable Transa…Varun Dhondea 275 views 2 comments 0 points Most recent by Varun Dhondea BI Publisher Learning Center -
Get employee information that has been modified since a specific date using SQL queriesSummary: Get employee information that have been modified since a date by using SQL queries and not API nor ATOM fields. Content (please ensure you mask any confidential…
-
How to have CR LF in ETEXT OutputI would like to ask on how to create a CR LF with ETEXT Output that is using an RTF Template.MayCab 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Backend column name to fetch special purpose attribute in element input valueSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 31 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM