BI Publisher
Discussion List
-
How to take Department head and Business Leader information from AOR?Summary: How to take Department head and Business Leader information from AOR? Content (required): Hi All, From which tables we can get Dept head and Business leader inf… -
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific dateSummary: Hi Community! Hope to find you well. Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective em…Luca9797 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 306 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep…HarishVummidi 81 views 5 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 42 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
DOR approval report gives cartesian product/wrong dataSummary: I am trying to fetch approver details of pending/approved document of records entries made by employee using attached query but it is always giving me the carte…
-
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 148 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit…
-
Updating RTF for Element Register ReportSummary: There is an error on the Element Result Report that produces split lines for Person Number. I need to update the rtf to correct this. Content (required): When s… -
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 53 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Work Schedule Report - Getting Hours On DateSummary: As per the screenshot attached. We have a requirement to fetch the Hours On Date. Example. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-7 (Ne…
-
Is there any way to fetch real updated absence records via BIP Report?Summary: - Content (required): Background: Absence Management Module We currently need to capture the real updated absence records, distinguish which records are newly c…
-
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…Saher 437 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…User_2025-01-25-04-02-13-126 375 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
Release Update Issue 23b: Error in custom reportsSummary: 'ORA-32036: the unsupported case for inlining of query name in WITH clause' Content (required): Hi Everyone, I'm facing an error on reporting level after the Re…
-
BI Publisher security on expatriatesSummary: BI Publisher using secured view shows records outside scope of user's AOR who is running the report Content (required): Hello, We have a BI Publisher report on …
-
Job detail HistoryHi Team, I am looking for table or Subject area to pull the Job detail history. The Navigation to view history details is given below: My Client groups->Workforce struct…Praveen_Chouhan 42 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on specific Manager and his/her actions with employeesSummary: Content (required): Good afternoon. We have a request to identify any employees that one specific manager either Supervised (their direct supervisor), Hired (th… -
Looking for Learning Reports specified in 20A release notesSummary: NOW RESOLVED. 22/05/23 Hi, I'm looking for a set of reports that were listed on the 20A Oracle release notes (https://www.oracle.com/webfolder/technetwork/tutor…
-
Converting payroll elements from one currency to anotherSummary: Content (required): Hello experts, Do you know if now it is available in OTBI and UI the possibility to convert payroll elements from one currency to another ac…Valerio Curzi 44 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Reporting and Documents of Record Updating / UploadingHi all, Apologies if this is the wrong place to ask. We're looking to build a report within BIP that produces a letter of reference that can be saved to an employee's do…
-
How can restrict the data in reports?Summary: How can restrict the data in reports? Content (required): Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have …
-
Need to know approval date file & table name of absence records attached my sql, if anyone please moSummary: we use oracle fusion cloud. OBI report and analytic Need to know approval date file & table name of absence records attached my sql, if anyone please modify and…RIfdhy Zain 517 views 3 comments 0 points Most recent by RIfdhy Zain Reporting and Analytics for HCM -
Seeded EEO and VETS ReportingSummary Is anyone using the seeded EEO and VETS Reporting?Content Hello Customer Connect Community, Has anyone used the seeded EEO and VETS reporting from Fusion HCM yet…User_2025-01-22-19-43-38-766 286 views 17 comments 0 points Most recent by Suppu Reporting and Analytics for HCM
-
How to find deeplink for Allocate Checklist page?Summary: How to find deeplink for Allocate Checklist page? Content (required): Hi All, How to find deep link for Allocate Checklist Page? From Tools -> deep links , i go…
-
Report on Learning Alerts Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas or BI tables that can be used to report on the learn notifications that are sent out using the Alert Comp…Mahesh_M123 171 views 4 comments 0 points Most recent by Swaraj_Sudhagonela Reporting and Analytics for HCM
-
Logic on Audit bit map field in per_all_Assignments_m_ tableSummary: We are working on an audit requirement to track the insert, update and delete assignment records over a given period of time. We have enabled the audit for prod…prabhunagu 144 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 51 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM
-
In Xsl template we are getting error like:sun.util.calendar.ZoneInfo cannot be cast to java.util.SimSummary: Hi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting…MaheshRayudu7 61 views 2 comments 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM