Reports
Discussion List
-
how to use preprocess XSLT File in xdo_metadata in excel using bi publisher?Hi - I am new to hcm extract and would like to use the preprocess XSLT file on excel xdo_metadata bi publisher. I am looking for documentation because it is not currentl…
-
Is it possible for an xsl report template to generate an excel output in extract?Hi - I'm new to extract and I am using xsl report template that needed to have an excel output in extract or even csv? Is that possible? I have tried using csv but it wa…
-
We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years.Summary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …
-
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g…
-
Submitting Extract with Parameter Date for output file name not working as expected.Summary: Submitting Extract with Parameter + Date for output file name not working as expected. Please see attached for detail screenshots. It should have file name with…
-
W2 Box balances on Payroll ExtractSummary: We have a reporting requirement where we are fetching Payroll balances. The report also needs W2 Box balances on the report. After we add the W2 Box balances an…Vibha Pandey - Oracle 26 views 3 comments 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Extracting ORC Responsibilities and Qualification in Custom ExtractSummary: Extracting ORC Responsibilities and Qualification in Custom Extract Content (please ensure you mask any confidential information): Hi Team, Greetings! This ques…
-
How to consolidate multiple extracts in a single extractSummary: Hi, I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a meth…
-
HCM Extract to compress multiple reports in a Single Zip FileSummary: I'm loading Job Requisition Template Description. For this I combined ClobFiles and JobRequisitionTempalte.dat into .zip file manually, i 'm able to load data ,…
-
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 …
-
How to customize US Validation Report for Payroll report?Summary: Hi Team, We are trying to create a copy of the seeded report. The extract copied does not yield any result even with no customization. The seeded extract name i…
-
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
-
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…
-
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…
-
Oracle HCM Extract: Deprecated User EntitiesHi, Can anyone please let me know how the Product Team announces about deprecated User Entities? Thanks Chaitra
-
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
-
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…
-
Request to provide the PVO and VO attribute name corresponding to the Fusion Table and ColumnHi Team, I need the column "Newly Separated Veteran Discharge Date" from to OTBI to FAW. I am trying to achieve it by Data Augmentation route by extending dimension. The…
-
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 …
-
Error on Submitting ExtractSummary: I created a Extract and when i submit it, it throws below error. Please find the screen shot. How to solve this? Content (please ensure you mask any confidentia…
-
Automate - PDF files upload from report to Document of RecordSummary: Automate PDF files upload from report to Document of Record based on Person Number Content (please ensure you mask any confidential information): We have a requ…
-
Resource to learn Extract.Summary: Hi All, I am complete beginner to Extracts. Would like to have standard and simple resources to learn. Thanks in Advance! Version (include the version you are u…
-
Is there a way to extract filter criteria for multiple extracts in one goSummary: Is there a way to extract filter criteria for multiple extracts in one go Content (required): Hi Team, Greetings! We are checking for the HCM extracts which use…
-
Experiencing blank fields in extract output.Hello Team, I have created an extract with Future UE and I'm experiencing blank lines in complete rows count in number six in output file. Do you have any idea regarding…
-
Is there a SQL query to get employees processed in extract run?Summary: Is there a SQL query to get employees processed in extract run? Content (please ensure you mask any confidential information): there a SQL query to get employee…
-
How to bulk download HCM Extract/Payslip data xml files from past 1 year runSummary: For a third party integration, we need to download payslip data xml files for past 1 -2 years. Data XML is not defined as extract delivery option. The only way …
-
HCM Custom Extract for Payment RegisterSummary Sample extract for customized payment register reportContent Change Notes Date Version Change Reference 23-Aug-2019 v1 First Version Background Payment Register …
-
Can I use output from one BI report as input to another BI report?Summary: Content (please ensure you mask any confidential information): I know that I can create multiple templates for my output, but that would require me to run the d…