BI Publisher
Discussion List
-
List of all Agents created in OTBISummary Ability to report on scheduled AGENTS - Listing of Agent, Report Recipient and Frequency (schedule)Content The Payroll/HR department is lookin for a report that …Raz Baboorian 743 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM -
HRT_PERSON_PERF_RATINGS_V shows all performance ratings not just talent ratingsSummary: When querying the HRT_PERSON_PERF_RATINGS_V table, values from incomplete performance documents will show. How do we otherwise restrict this table to show only … -
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…TC 61 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.1K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor…
-
Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP CloudSummary: Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud Content (please ensure you mask any confidential information): I wo…
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 239 views 7 comments 0 points Most recent by Bisweswar Goud-Oracle Reporting and Analytics for HCM -
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 2 views 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 69 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Need table for Provider setting values for the task Configure Candidate Experience CAPTCHA ProviderSummary: Hi Could you please help me out to find the table where the information for Provider setting values in the task Configure Candidate Experience CAPTCHA Provider …
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…Valerio Curzi 356 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I modify existing seeded workflow notification template?Content I have a requirement to modify existing seeded template for Workflow notification(Transfer Report). I have found the template and copied it in custom folder and …User_2025-02-06-14-37-05-233 209 views 6 comments 0 points Most recent by Kotakonda.Balasubramanyam-Oracle Reporting and Analytics for HCM -
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …Rajdeep Chavda 4 views 2 comments 0 points Most recent by User_VQTGR Reporting and Analytics for HCM
-
how to fix #VALUE! error in excel templateSummary: i am using DATEVALUE function to convert text to date in excel template.However incase of blank date i an getting #VALUE!. Can anyone please help to reslve the …minati_behera-Oracle 11 views 3 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM
-
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d…
-
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err…
-
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does… -
I need to find who created or updated a BIP or an OTBI report and whenSummary: We need to find details like who created a BIP report or a Dashboard or an OTBI report and when. Content (please ensure you mask any confidential information): …
-
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font … -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 53 views 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man…
-
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a…UrvashiJ 503 views 1 comment 0 points Most recent by Basavaraj Navalagi Reporting and Analytics for HCM
-
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…
-
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 205 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 13 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)