BI Publisher
Discussion List
-
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma… -
How to show an icon based on company?Summary: How to show an icon based on company? Content (please ensure you mask any confidential information): An icon of a report can be shown only if user has specific …Stefano_Mazzocca 15 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Is it possible to access the audit logs of selects placed on certain tables via Oracle cloud?Hi, I need the logs of some tables that are important for confidentiality. Is there a table on BI Publisher that contains the details of who ran it and when it was run i…Cansel Karasoy 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. …Janardhana Kondaveeti 256 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
SQL to extract location mailing addressSummary: Please could you let me know the SQL to extract mailing address that is stored in Manage Locations task. I have checked in the HR_LOCATIONS table but I cannot f…
-
BIP | SFTP filenames with .XLS or .XLSX extensions are not readable in SFTPSummary: Hi Experts, My requirement is to place the SFTP file in .XLSX format. SFTP filename with .XLS or .XLSX extensions are not readable in SFTP, but filenames with .…Arti_Priya 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…Sonal_Lalwani 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Can I download bi publisher to mac?Summary: Hi team, I want to switch to mac , I saw that is problem to download BI publisher, someone tried? and there any other problem with mac?Guy_Ora 5 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta…Luke.Findex 27 views 5 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…User_53LLL 8 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is there a way to find all data-models that use Bursting?Summary: We are planning a change in Sender Address in our ERP Instance and one of the requirements is to also amend it for all the Bursting reports configured in the sy…Prateek Mohan 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 590 views 7 comments 0 points Most recent by ManavM Reporting and Analytics for HCM -
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email burstingSummary: I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting. According to this, it should be…
-
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 3 views 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM
-
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…Gundllapally Sagar 105 views 1 comment 1 point Most recent by Nitin.Goswami Human Capital Management
-
How to encrypt and decrypt images in Oracle fusionSummary: How to encrypt and decrypt images in Oracle fusion Content (please ensure you mask any confidential information): Hi All, We got a requirement to encrypt and de…
-
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y…Guillaume SAVALL 130 views 6 comments 0 points Most recent by Austin Rodola Reporting and Analytics for HCM
-
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 44 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …User_2025-02-05-04-17-04-394 7.4K views 13 comments 0 points Most recent by Boying Reporting and Analytics for HCM
-
Emails with analysis tables are putting in extra spacingSummary: We have analysis that displays jobs that were posted in the past week. We send this report to users via email and have the data displayed in the body. The data …
-
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 8 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Does SFTP setting done in Production is copied over to non-production environment during P2T?Dear Experts, Can someone let me know if SFTP setting done in Production is copied over to non-production environment during P2T? Please share oracle documentation for r…B S Rafatullah-Oracle 18 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for…Shikha Agarwal 1K views 6 comments 0 points Most recent by user11977061 Reporting and Analytics for HCM -
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m…Consultant Ian 32 views 7 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…Gunal Baskar 762 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM