Category 81
Discussion List
-
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 462 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM -
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Phani S-Oracle 306 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
How to rename the Remote File Name, in order to display hour and minuteSummary: How to rename the Remote File Name, in order to display hour and minute Content (please ensure you mask any confidential information): Hi, we scheduled a BIP re…Barile Alberto 38 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Accrual balance report/ how to use months in column and years in rowsI'm building an OTBI report to based on Accrual Real time subject area, with the goal of displaying accrual balances. To have a report that makes sense I used Pivot Tabl…Marius Neata 14 views 2 comments 0 points Most recent by Marius Neata Reporting and Analytics for HCM -
How to run the Talent Profile seeded report?Summary: I need to export an XML file, but I won't be able to view all the fields and content sections. See below parameters used: Version (include the version you are u… -
my FRS is showing duplicate accounts on reportsSummary: Reports were correct when created but now have this issue of duplicating and categorizing accounts under cost of sales but still appear in the correct category …SaintNick 3 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
We need to send files to Microsoft teams Through any automated processWe have a BIP report that needs to scheduled on a daily basis and we want to store those output files in Microsoft teams under Files Section. We don't want to store them…Kunal_444 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Table to get the Time Card Required field in Payroll Relationship page.Summary: We have a requirement to pull the "Time Card Required" field on the Payroll Relationship page. But we are unable to get the table. Please help me with the table…Rengaraj G 3 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Veteran Self-Identification Status - no results in OTBI Person Real Time SA **Updated**Summary: I have the 'Veteran Self-Identification Status' along with the other Veteran statuses in multiple analyses and dashboards. Recently, sometime after 8/15/2024, t…Susan Anderson 95 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a… -
How can i get absences in BIP Report that where approved and then withdrawn/deleted .Summary: Hi, Please suggest tables that stores absences that where approved and then withdrawn , are there any transaction table that stores the data or absence events t…GummadiNamrata 46 views 4 comments 0 points Most recent by GummadiNamrata Reporting and Analytics for HCM
-
Loading Job Requisitions via HDL - What table is collaborators held in?Summary: I'm loading Job Requisition from one Oracle environment to another and I'm having trouble finding the table where Collaborators sit. Please advise. Thanks! Cont…User_H77SF 41 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…Ooha Pranathi Akkala 3.3K views 12 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM
-
OTBI : How to customize the seeded OTBI dashboard and analysis used in the dashboardSummary: Hi All, I have to customize the line manager dashboard -> Absence (tab). When I click on edit dashboard -> edit the analysis, I can see the analysis. But I want…
-
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
I need help in drill through custom URL.Summary: Direct integration is built between Oracle cloud ERP and EPM Planning cloud. I am planning to create drill through to source using custom URL. I am unable to ge…
-
How to run report to pull specializations and courses on a single report?Summary: I need to run a report with all specializations with the courses in the specializations with course sequencing position. I don't need any user information, just…
-
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 57 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
query or table in service request managementSummary: We need to identify tickets that are not addressed for those requested information /response is already provided in Oracle service request management. We have c…
-
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 274 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 148 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
OTBI Recruiting Candidate Data SecurityHello, We currently operate in multiple GDPR countries, and our Legal/Data-Privacy departments are requiring that we lock down candidate and job requisition data based o…Nick Dorfner 12 views 2 comments 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Primary key PVO legal entity / legal entity registration numberHi, Can I join these 2 tables using the 2 primary keys ? Will my legal entities match the registration number in a report ? Regards, LaurianeLauriane Massin Whitaker 13 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th…BDO Sue Cronin 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
User Role Audit ReportSummary: User Role Audit Report - We want to see when changes were made, who made the changes, what change was made, what role to user is added or removed Content (requi…SAKTHI SUNDAR 117 views 5 comments 0 points Most recent by User_BN0QX Reporting and Analytics for HCM
-
Getting correct calc_breakdown_id from pay_action_contextsTeam, We have developed one HCM Extract and having balancevalue field. This field gets value from Rule (Fast Formula). We have written the fast formula and calling one v…Manoharan 62 views 0 comments 0 points Started by Manoharan Payroll and Global Payroll Interface (GPI)