BI Publisher
Discussion List
-
Need a query to pickout the balances details in Oracle HCM fusionHi All, Our requirement is to get the balance details of the following balances based on the employee details for a pay period. can you please share the code for that. '… -
Can seeded flow Run Element Results Register be run secured by Business Unit ?Summary: Can seeded flow Run Element Results Register be run secured by Business Unit ? We have requirement to generate the output Run Element Results Register based on …
-
can we add filters for checklists tasks also in hcm extractswe wan to create DOR if the termination/resigantion checlists tasks are completed. Can we add filters for those also in HCM extracts. which bussiness object we need sele… -
Getting Additional Compensation details in HCM extractHello, I am building an HCM extract to capture Employee changes. I am currently using this UE to bring all required attributes: PER_EXT_PAY_EMPLOYEES_V2_UE_EMP_REC I req…
-
HCM Extract is getting into error after adding Data Loader Interface - Delivery TypeHCM Extract is getting into error after 24A update. After import of extract and added new delivery type as Data Loader Interface and give correct object entity details t…
-
Created a Changes Only extract– contains historical data on Assignment detailsSummary: Hi Teams, Need to get history data from assignment using HCM extract, Root UE: GLOBAL_PAYROLL_INTERFACE_TERMS_UE Childs 1: PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE Ch…
-
Statutory Deduction Register - Need the code/Logic in calculation of Balances at PSUHi All, we would like to understand the logic/code computation logic which would calculate balances based on the TRU. Can you please help. Thanks, RakeshRakesh Kanukanti 22 views 2 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person detailsChetana Pawar 11 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Help in Benefits HCM ExtractSummary: Hello again! I need to pull some data and I found the perfect UEfor it: BEN_EXT_ENRT_RSLT_UE. The only problem is that it can't be a Root Data Group UE. Searchi… -
Can we automate the HDL loads for Business Objects like Talent Profile / DOR having CLOB Files ?Assume, client is giving the DOR files on a regular interval and placing them in some folder and we have to automate the DOR HDL load on a recurrence basis. Is there a m… -
Can Delivery Option Web Content file entry be removed from Extract already on Scheduler?Summary: Can Delivery Option Web Content file entry be removed from Extract already on Scheduler with out impacting nightly output to FTP Content (please ensure you mask… -
Chnages only extract to pull chnages on same daySummary: I have requirement to pull Employment Assignment Action at changes only extract. It is working fine when there is single change in a day but user is expecting b…
-
Has anyone been able to Connect Oracle to AlteryxWe are trying to connect Oracle DB to Alteryx. Has anyone been able to do this, we would like to use Alteryx for some reports. Thanks AhsamAhsam 14 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Integration Cloud HR Guides and Templates
-
User Entity Talent HCM ExtractHello friends. I need to create an extraction in the HCM Talent module. But I never had contact with this module to find out information such as which user entity I shou… -
Fetch balance values from Fast FormulasI have a requirement to fetch balance values based on input balance names passed to Fast Formula. I am using Balance Specific DBI's to fetch their values. When I hardcod…
-
Context sensitive DFF in LookupSummary: Actually i have done all the setup and Before i'm able to see the DFF value in lookup. My system got cloned from Prod. After performing all the steps as before …
-
BIP Report to Get Last 30 Days User Login DetailsSummary: The Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last l…Chainsyssupport 95 views 2 comments 0 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
Unable to access BI report using REST serviceHi, When I try to access BI report from postman it returns as 400 Bad Request Thanks -
Parse JSON data in HRC_ATOMPUB_ENTRIES.ENTRY_XML fieldSummary: For reporting purposes we need to read and parse the JSON payload that is present in Atom Feed Table. The field ENTRY_XML contains an XML which tag //entry/cont…Claudio Marini-Oracle 84 views 2 comments 0 points Most recent by Claudio Marini-Oracle HCM Integrations
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
inbound interface type option deprecationSummary: inbound interface type option deprecation what is alternative option oracle providing ? HI Team, Good Morning As per this note 2872186.1 (inbound interface type…Prasanth Venkata p 34 views 2 comments 0 points Most recent by Shivani Rathore Human Capital Management
-
Email blocking problems? SPF SetupSummary: Hi, Are any other UK customers experiencing problems with emails from HCM being blocked recently? We are starting to get emails (delivered as part of HCM Extrac… -
Hdl Template for loading answers to a question for each employeeSummary: Hi, I am looking for a HDL template to load answers for questions with respect to each employee. Which attribute should I take that so that different answers ge…Aviral Tripathi 95 views 4 comments 0 points Most recent by Marius Voicu-Oracle HCM Data Loader (HDL)
-
Getting Job offer details in HCM ExtractsHello, I am trying to bring Job offer letter comments in an HCM extract as an attribute, but job offer comments does not appear anywhere in the core. Can anyone please s…
-
Report to show Employees serving Probation PeriodSELECT Command for extracting Employees that are serving probation period.
-
Migrate update to extract definitionHi Experts, We have a case where the report Extract Definition is already in production and has been used but we need to update the extract definition with additional de…
-
Need to identify the logic of seeded LookupVO in flow pattern -Run Type|RuntypeLookupVOSummary: WE need the table or Query to identify the LookupVO in flow pattern -Run Type|RuntypeLookupVO. Flow Pattern: Calculate Payroll Flow parameter -> Run Type: Run T…
-
can we add checklists completion status in hcm extract filtersIs it possible to add checklists filters in the hcm extract. Is there any user entity specific to checklists data or can we modify the user entities. we want to get the …