Category 81
Discussion List
-
OTBI formulas to combine 2 criteriasSummary: Help on OTBI formula Content (required): I would like to create a formula that would allow me to get the AVERAGE individual bonus achievement BY workers and BY …Jacqueline GRANDIN 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 173 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM
-
Is there any report that can be produced indicating when a user logs in using a password or SSO?Summary: Is there any report that can be produced indicating when a user logs in using a password or SSO in fusion? Content (required): Report/SQL Version (include the v…Fazal Subhan 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
ZIP output file of an OTBIHi All, We have a requirement to zip the output file of an OTBI analysis before emailing. Is this possible? Regards,Vibha Pandey - Oracle 12 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
UNable to query fusion_mds.mds_pathsSummary: UNable to query fusion_mds.mds_paths Content (required): Hi Team, There is insufficient privilege error received when we try to run query against table fusion_m…Parag Hiremath 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BI Publisher version controlSummary: Version control repository for BI Publisher Code Content (required): We would like to know how we can achieve version control for BI Publisher reports and metad…Ram Shankar 104 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 105 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
How do I find correct security type to add to a role to run report?I have created a dashboard and a new role which I had inherited to another role. The issue though is when I go to run the report I get the following error which I know i…Aaron Reynolds 22 views 5 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Export vs. "Open" Report Data OutputSummary: Hello there! I have a question regarding a discrepancy I noticed in the data output of a report that I'm using. The report pulls all active team members as of t…
-
Transaction Console BIP ReportSummary: For the Transaction Status: In Progress we are not able to fetch the Assigned To data in the table FA_FUSION_SOAINFRA.WFTASK Also we checked FND_BPM_TASK_VL as …Kshitiz Sinha 23 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
Show the pod or instance name on an OTBI Analysis?Summary: We need to be able to label the header of an OTBI Analysis with which pod or instance it comes from. It can be pulled into a data model using the following quer… -
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh…MikeW 122 views 34 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Organization Name for PromptSummary: Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wante…
-
How to prevent those writing BI Publisher Data Models from who have ERP access to use HCM tablesSummary: We are trying to prevent those writing BI Publisher Data Models from who have ERP access from being able to use HCM tables and vice versa. Need to implement the…
-
Duplicate person number in OTBI report.Summary: Hi Team, I am using the subject area " Worforce Management - worker Assignment Event Real Time" with below clolum and without any filter . Legislation CodeLegal…
-
Is it possible to pull ALL job applications (rejected, accepted, etc.) in an OTBI report?Summary: Is it possible to pull ALL job applications (rejected, accepted, etc.) in an OTBI report? Content (required): Is it possible to pull ALL job applications (rejec…Kim Buch 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get users logged on info in HCMSummary: User session info required Content (required): Need to get logon info for users. Seems to be a few posts but not a concrete answer. FND_SESSIONS seems to hold t… -
Talent Management DashboardHi, I am working on a dasboard to count the number of employees have a performance document in the worker evaluation status. I have both a KPI and a drill down report. T…
-
BPM Worklist Notification CustomizationHi , I want to edit the title information of the Absence Approval notification in the BPM Worklist. But is it possible and how is it possible to change the title only fo…Cansel Karasoy 227 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
pivot table sorting dataSummary: How to sort data in pivot table view Content (required): I created a report using a pivot table, but the data in pivot can be sorted in ascendent or discendent …
-
Report for failed attempted login with error messageSummary: Need to create a report for audit all the failed attempted logins with the error message. Content (required): Person number, name, date/time of login, error mes…Kumar, Nitin 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Registration Information OTBI columnSummary: Content (required): Hello experts, do you know the OTBI column name and subject area where finding the Legal Entity Registration Information fields? Please, fin…Valerio Curzi 12 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…Lee-GT 388 views 3 comments 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
how to build OTBI report that give grade rate name by citySummary: Content (required): how to build OTBI report that give grade rate name by city. I am encountering a situation wherin I see multiple salary plans or grade rate n…
-
Database Item for Payroll Element Name in Fast FormulaSummary: Content (required): Hello experts, do you know the database item for Payroll Element Name in Fast Formula? We need to create eligibility based on people having …Valerio Curzi 23 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
WE have OTBI report On Prescreen questions but getting below errorSummary: HI Team, we have OTBI Report on Prescreen questions but getting below error only today onwords we getting (still yesterday working fine. ). Please find below sc…AjayKumar Maddipati 12 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Report as on effective dateSummary: Want to generate OTBI report as on effective date other than sysdate Content (required): We have a requirement to fetch data as on 1 day before the current date…
-
How to fetch details from Worker Assignment Real Time Subject area as of (current_date - 7)Summary: Hi All, In an OTBI Analysis, I'm trying to fetch all the employees who has their Assignment Category changed to "Leader" in the past week. But I don't see a sub…Akhila 48 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM