Category 81
Discussion List
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Last Standard Process date column in payroll reportHi There, Hope you are good! I m looking for creating report with last standard process date for terminated employees in order to run HSDL for final close for these term…Priya1 12 views 2 comments 0 points Most recent by Raju Sandepogu-Oracle Payroll and Global Payroll Interface (GPI)
-
How to calculate number of continuous weeks of Submitted TimecardsSummary: For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks. Content (please ensure you mask any confidential …Richard Kemp-Eyre 22 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How to add BI publisher report to Briefing bookSummary: We have a requirement to Add a BI Publisher to a Briefing Book. I tried creating it by following the steps mentioned in below link but not able to see the outpu…Santhosh Gangishetty 23 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 22 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
ytd payroll balance values using pay_run_balancesSummary: How to fetch the Ytd balance value of the Gross Pay,Net and Employee tax deductions using pay_run_balances table Content (please ensure you mask any confidentia…susmita 762 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How we can pull old assignments and old payroll name?I need logic for old assignments and payroll name, it will be appreciable if you will provide me any sample query. This is the Requirement Global Transfers processed in …Narmada Yadav 31 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
i want to join (PAY_PAYMENT_TYPES) tables with person details.wanted to fetch payment type and payment source highlighted in the below snapshot.Chetana Pawar 12 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How do I report on all the phases and states a job requisition progresses through?Summary: I am currently trying to report on all the phases and states a job requisition progresses through, including effective dates. using subject area 'Recruiting - R…Paul Morrissey 232 views 2 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
opening of Outlook and send mail for rejection of performance assessmentsHi code is written so that mail is sent for rejection of assessments. when we click it will redirect to outlook. mailto:fusion_notifications@XXXX.com?subject=%20Reject%2…Shanmukhi 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
BIP report to scan BIP custom catalog for a key word in custom SQLSummary: Any Table which stores BIP Custom SQL. So That I can query that table to find a Particular "Table" used in all custom SQL. Content (please ensure you mask any c…SaiPavan Kumar Gadepalli 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Report related detailsSummary: Hello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report …Namrata_20 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Inbound Integration HCM Extract - Zero RecordsSummary: Hi All, I face a unique scenario where my HCM Extract may not always generate HDL Data records to be loaded to HCM Data Loader. Due to this, a blank .zip file g…VinayDama 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
BI Report job success but email not deliveredHi, We have come across an issue with one of our bursting reports wherein the Report job is showing as Success, but the email is not being delivered. Can someone help wi…Praneeth K 15 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 16 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Reports return SQL error since applying security profileHi there, Since doing a restructuring of the business, we applied a person security profile to one of the HR roles so that they could only search for and work with peopl…Matt Corserv 5 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…Oriana L. 32 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
does the system keep track of changes made by the manager on the employee's goal plan?Summary: Is there any way to track the historical data of an employee's goal plan? when the manager makes changes to the employee's goal plan (e.g., in the mid-year time…Alessandro Nesi 21 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Is there a table or a view holding "Previous Comments" or "Approval History" related to unapprovedSummary: In order to check a detailed approval status of Goals before approval, I'd like to extract data such as "Previous Comments" or "Approval History" . I'd like to …S.Watanabe0110-Oracle 13 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How to track the number of requested feedback via BI PublisherSummary: How to track the number of requested feedback via BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to generate a re…Barile Alberto 23 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Select data which are displayed on the All-In-One EvaluationSummary: As per customer's request, I'd like to make a BI report that selects the data displayed on the All-In-One Evaluation. Content (please ensure you mask any confid…S.Watanabe0110-Oracle 32 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Where to find historical data in BICC PVO'sSummary: Need to pull historical person info from PVO's in BICC Content (please ensure you mask any confidential information): Our business has set up an integration bet…SeanWesche 127 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 62 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versaSummary: Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versa Content (please ensure you mask any confidential information): Currently the reporti…Akhil M 62 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Limitation on XDO Tags in BI Publisher Excel TemplatesSummary: The number of XDO tags within our BI Publisher Excel template has exceeded 1000. We are unable to generate additional tags, which is hindering our template desi…Tauseef-Oracle 53 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI - Reverse geocode time events via sqlSummary: Hello, Is there an sql package available for cloud customer regarding reverse geocoding?. Content (please ensure you mask any confidential information): We are …Paul Buna 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
dashboard parameter resetHello, I prepared a dashboard from a web service data model and this dashboard works with certain parameters. Dashboard consists of two tabs in total. When I select the …Sinem Kara 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
need build a logic to pull only the approved time cards for that particular month.Hi We need to build a report to get the approved time cards for Payroll processing i can only find hwm_tm_rec which captures the data. How can i consider only approved t…