Reports
Discussion List
-
Is there other table store info about qualified entitlement planHi Teams, table anc_per_abs_qual_entl is holding the data when user records an absence, do we have any other table or view stores the entitlement information when user n… -
The filter should show just the Years: 2021 2022 2023 2024Hi, this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Fe…SenthilRaja 13 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple… -
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
is there way to hide Page Options - Edit dashboard - we have access it through work areaSummary: Dear exports, We have created work area and provided below static url of the dashboard link to access the report. The manger's are able to see the ritNow, the c…Rama123-Oracle 2 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su…
-
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 232 views 7 comments 0 points Most recent by Gillian Kilbride Reporting and Analytics for HCM -
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 141 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM
-
SQL query to get the child department of a parent department from the department hierarchy in BIPI have written below query where I have hardcoded Organization id for which I want to fetch the child departments from department hierarchy in BIP report but the query i…Anjali_Kumari4121 63 views 3 comments 0 points Most recent by B Casla Reporting and Analytics for HCM
-
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s… -
How to hide Page Options while accessing by managers Fusion Cloud HCMHi Team, Could you please to hide below Page Options (Edit dashboard, other options in it) while accessing by managers in Fusion Cloud HCM BIP.Chanikya Neelam-Oracle 1 view 0 comments 0 points Started by Chanikya Neelam-Oracle Reporting and Analytics for HCM
-
Unable to Add Home or Work Address for Internal Employee in Offer Letter TemplateHi, We are currently unable to include the Home Address or Work Address of internal employees when generating the offer letter using our offer letter template in Oracle …Narendra N 32 views 3 comments 0 points Most recent by Sridevi Kuttalingam Reporting and Analytics for HCM
-
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re… -
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Write a sql query to fetch average number of learning days per employeeSummary: Write a sql query to fetch average number of learning days per employee (includes all formal learning). Content (please ensure you mask any confidential informa…
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 295 views 10 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Defaulting the date parameter value based on their native languageHi Team, We are facing some issue in the existing report. Below is the details of the issue. 1. In one of our report, we are defaulting the date parameter value as Last …NIRMAL KUMAR L 3 views 0 comments 0 points Started by NIRMAL KUMAR L Reporting and Analytics for HCM
-
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 65 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 32 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
Is there a way to filter this way in OTBI?Summary: Content (please ensure you mask any confidential information): I'm extracting columnA from a table. It has both null and not null values. »»»Filter should only …Stefano_Mazzocca 11 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
unable to find the table which stores the approver details for fusion bpm nor rest api, please helpSummary: Hi Experts We are unable to find REST API or fusion table to extract the approval rules and the approver details. Below is the more details Would like to extrac…zakir112443 41 views 1 comment 0 points Most recent by Pradeep Kumar Reddy V Reporting and Analytics for HCM
-
Outage for Import Oracle Fusion Data Extensions for Transactional Business Intelligence?On the documentation page discussing importing DFF fields using Import Oracle Fusion Data Extensions for Transactional Business Intelligence it mentions "Running the pro…Angela Montenaro 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th…
-
How to retrieve AS$_ATTRIBUTE7 in OTBI?Summary: I'm looking for assignment descriptive flexfields and I'm using "Workforce Management - Person Real Time" subject area Content (please ensure you mask any confi…Stefano_Mazzocca 22 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Unable to add security permissions for HCM seeded report folderWe want to provide customized access to the seeded HCM report folders on the Reports and Analytics page, but we're unable to modify their security permissions directly. …fusionuser 22 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Hiding the settings icon in embedded BI dashboard via deep linkHi Team, to embed a BI dashboard within a custom icon without displaying the BI menu, we created a deep link to the dashboard (ref. How To Embed A BI Dashboard URL Witho…
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 201 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…Rama123-Oracle 12 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…