Reports
Discussion List
-
Third-Party Payment Register Report is blankSummary: After running and generating payment, when I run the Third-Party Payment Register Report it keeps coming blank with this message: This process is in Completed s…Kalemba Jean-Marc Kankwenda 12 views 3 comments 0 points Most recent by Kalemba Jean-Marc Kankwenda HCM Extract -
Is there a known limitation for HCM Extract Output generated in .txt format?Currently, we have an extract that makes use of the user entity, PER_EXT_SEC_ASSIGNMENT_BASIC_UE, and runs on system date; and the data model, globalReportsDataModel, to…
-
How can i hide salary data on OTBI?Summary: We will instert the salary information to the live environment soon. A spesific role was determined on the SaaS application and access restrictions were set wit… -
using HCM extract in need to upload the profile image into document recordsusing HCM extract in need to upload the profile image into document records post approval. Once the image is approved it will be enabled. Same image can we upload in DOR…
-
Looking for a companies who can help in providing 834 file format to one of our clients.Summary: Do we have any list of Oracle partners to whom I can reach out to send 834 File Format Directly from Oracle HCM to various Vendors? Thanks and regards, Sravani
-
Failed - IO errorSummary: Failed - IO error Content (please ensure you mask any confidential information): When we tried to click on "customize" option, getting this error. Even if we tr…
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g… -
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…
-
Is there another SOAP call that we can use to trigger BIP without exposing the Username & Password?Summary: We are currently using the SOAP wsdl below to trigger BIP report. Unfortunately client wants the username/password to be hidden in the SOAP envelope. Is there a…
-
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 21 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 75 views 2 comments 0 points Most recent by Clare Murtagh - new 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…