BI Publisher
Discussion List
-
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time… -
How to remove blank line from RTF template report output?There is a BI report(RTF Template) with the following data as output: Name: DOB: Gender: DOJ: The requirement is to hide DOB(both text and the value) for a certain c… -
We need citizenship column in BIP querySummary: Hi Team, We unable to find the citizenship column and we checked on per_citizenships table also . any one help me on ? Thanks, Ajay Content (please ensure you m…AjayKumar Maddipati 50 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one rowHI Team, when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row. how to…AjayKumar Maddipati 34 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FTP server setup for BIP - Save or Test connection not availableHi Team, I am trying to add FTP server setup. I can enter all the details but I do not see Save or Test connection. I should be a complete administrator, but seems I hav…SM_EP 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
HCM Table to fetch Saved SearchHello, I'd like to create a BI report to see whether employees have created their own Saved Searches on Document Record page. Do you know which HCM table store this piec… -
How to retrieve Country of a Logged in User to be used in a value set of a DFFCreating a DFF to determine Yes/No based on country (and some other details) of the logged in user in the value set of the same. First is it possible at all, if yes then…Avik Chakraborty 12 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Can we get Completed By and Task Start Time of Task/Activity?Summary: we need to pull Completed By and Task start time fields using BIP ? Do we have direct columns ? Content (please ensure you mask any confidential information): V…Kadali Harika 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Where can I find the BIP tables storing the "Personal Brand Administration" related details?Summary: Hello, We have a requirement to fetch Personal Brand Administration related data, specifically the information under the "Skill Settings" section - "Skill Data …Prashanth Sangram-Oracle 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Can we recall the triggered emails from scheduled reports via the system ?Hi All, Is there any possible ways to recall the triggered emails from scheduled reports via the system ? Regards, JebaJebarsan Thangam John Durai Raj 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …Rengaraj G 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Customize/remove action button in infolets for fusion HCMSummary Customize/remove action button in infolets for fusion HCMContent We have a requirement where action button of infolets needs to be hidden for users. Please share…
-
How to Create a BI report for BPM worklist fields in addition to TXN action and action Reason.Summary I have created a BI report for BPM worklist, along with action and action reaction from TXN header table which is and extract from XML_data_cache filed, but it i…
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to …Oriana L. 17 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
How to compare BU to TRU.I was wondering if there's a way to compare BU to TRU. I've tried using different logic to compare the two, but haven't had much luck. TRU has the official name, while B…Michael Angelo Lucena 1 view 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
How to insert cover art image on Learning Catalog Course (Not stored as a BLOB file) in a BIP reportSummary Trying to insert cover image of course in OLC in BIP ReportContent Hi Team, In Oracle Learning Cloud, we can upload Cover Art images at course level and the imag…MandeepKGupta 70 views 3 comments 0 points Most recent by Daisy Quebrata-Oracle Reporting and Analytics for HCM
-
Employee / Line Manager / HR Specialist seeded analyticsSummary: Customer want to know any seeded list of Employee / Line Manager / HR Specialist analytics or dashboard Content (please ensure you mask any confidential informa…Suresh Manoj Kumar-Oracle 21 views 5 comments 0 points Most recent by Suresh Manoj Kumar-Oracle Reporting and Analytics for HCM -
Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES?Summary: As stated in the question title: Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES? We know that PGP Encryption … -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 32 views 8 comments 0 points Most recent by Mark Jayson Tamaray Reporting and Analytics for HCM -
How can we change BI report name dynamically while downloading as per selection parameter.I have created a BI report as 'Job Application Report' and in this report I have created many parameters. One of them is the parameter name 'Requisition Name'. And After…Anjali_Jaiswal 148 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
BI Publishing: bursting without attachmentsSummary Bursting to selected people, without attachmentContent Hi all, I am trying to use BI Publishing to burst an email to colleagues who have handed in their notice. …User_2025-01-31-17-49-32-187 1.4K views 10 comments 4 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Payroll Data to Transaction DetailsHello I am looking to create a report that shows pay element details linked to the transaction data. We issue Special Payment to several of our employees. When it is ent… -
VBC HCM tables available for BI Query in lab pod? POCSummary: Are the Value By Criteria tables available for BI Query Data Model? Content (please ensure you mask any confidential information): Hello: I'm performing a Proof…
-
Federal Tax Withholding Filing Status - Pulling Data from TablesSummary: The Federal Tax Withholding Filing Status seen from the front end of the application is displaying a status that does not correspond with the Filing Status seen…ChicagoConsultant 15 views 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Table that Stores Fields on Tax Withholding Calculation Card- Filing StatusSummary Looking for table that stores filing status on Tax withholding calculation card when you select Federal Income Tax, Calculation Coponent DetailsContent Hi All, L…User_2025-01-30-00-53-42-934 988 views 5 comments 0 points Most recent by Sydney_Flahive Reporting and Analytics for HCM
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 284 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 14 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM
-
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 300 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Specify Multiple People in Cc While Bursting in Custom BI AlertsSummary: Content (required): There is a requirement of having multiple people in Cc while bursting. How to configure PARAMETER 2 for multiple recipients? Version (includ…Shashank Singh 1K views 3 comments 0 points Most recent by jahanavi metta Reporting and Analytics for HCM
-
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 43 views 0 comments 0 points Started by jtwhit_hcm Payroll and Global Payroll Interface (GPI)