Category 81
Discussion List
-
Send remittance advice report querySummary: Send remittance advice report query Content (required): We want to customize send remittance advice process. And we need the seeded report data model query acce…Priyanka More-Oracle 123 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to create date range parameter i.e. Date from and Date to in OTBI report?Summary: How to create date range parameter i.e. Date from and Date to in OTBI report? Content (required): We want to fetch payment details from specific date range in O…Priyanka More-Oracle 1.6K views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
OTBI Column NameSummary: Hi, We have requirement to capture account balances as at a particular date (entered as a parameter) in an OTBI report. How do we cater this requirement? Regard…Sheneli98 21 views 2 comments 0 points Most recent by Sheneli98 Payables, Payments & Cash Management -
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …Swapnil Kashid 81 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 71 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Last closed period in Fixed Assets - Transactions Real timeSummary: There is no data in the fact column "Last closed period" in the subject area Fixed Assets - Transactions Real time. Content (required): We do have some closed p…Anders W. Langholm 21 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
User folder not visible in right pane due to system limitation of 300 folders at a timeSummary: Per Doc ID 2443757.1 users folder permission can be set by navigating to folder. However though I can see the user folder in left pane can't navigate to the sam… -
How to Calculate Payroll ReversalsSummary: How to include payroll reversal values in calculation Content (required): We have BI publisher report that calculates Payroll distribution for all of our employ…GauravGupta39 61 views 5 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Workforce Management - Absence Real Time Subject Area not returning any dataContent Workforce Management - Absence Real Time Subject Area displays 'No Data found' . Can someone who has used this Subject Area please let me know the roles that hel…Shruthi Ramesh 245 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Create LOV for countries defined in the system and few more custom valuesSummary: Can we create an LOV that will include all countries already defined in the system plus few more custom values. Content (required): Version (include the version… -
Value of a LOV is restricted depending on logged in userSummary: How can we restrict the values included in an LOV depending upon the logged in User Content (required): Version (include the version you are using, if applicabl… -
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 21 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM -
Merging cells for header row in management report gridSummary: Hi, I am wondering if if is possible to merge the cells of a row in a management report grid to be able to generate a heading row (top row or somewhere else)? I… -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick… -
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher… -
Transaction (requisition and/or expense report) - approvers and actionsSummary Provide end-users with a report (or reports) that identifies approval status (and history) on requisitions and/or expense reports).Content Boise State has a requ…User_2025-01-28-03-18-28-504 80 views 8 comments 0 points Most recent by Mihaela Vlad Reporting and Analytics for ERP -
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise.Soumya Prakash Parhi 154 views 2 comments 8 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to burst different notifications to different mail IDs based on exit interview responsesSummary: How to burst different notifications to different mail IDs based on exit interview responses Content (required): We have implemented the Offboarding Process in … -
Changing User IDsSummary:We use our email addresses as our user ids in Oracle. Our company is getting ready to change the prefix of our emails from ex. Joe.Smith@gmail.com to Joe.Smith@y…Robert G Wilkinson 11 views 2 comments 1 point Most recent by Parker F McCrary Payables, Payments & Cash Management -
Audit Report for FranceSummary Does Anyone use Audit Report for FranceContent We are trying to use the provided Audit Report for France and we are running into issues. Did anyone use this repo…Tina Valtchev 33 views 8 comments 2 points Most recent by amy hardtke Reporting and Analytics for ERP -
How to remove/supress subtotal lines in SmartviewSummary Is it possible when drilling down in a Smartview report to 'remove subtotal rows' in the same was as you can with a standard pivot table output?User_2025-02-11-02-45-23-645 180 views 2 comments 1 point Most recent by Ekta Nayak-Oracle Reporting and Analytics for ERP -
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM - Administrator Role for Report Scheduling in HCMSummary: Create an Admin record in HCM for Report Scheduling Content (required): Is there a way to create a user account in HCM that can be used as a central scheduler f… -
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM