BI Publisher
Discussion List
-
Bip publisher output doesn't clear cache as old message isnt clearedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a …Michael_Burgett 3 views 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM -
How to identify edited DOR in BI reportsHow to identify edited DOR in BI reports?Nivya Mathire 21 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID… -
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
default time zone when scheduling BI reportsSummary: is it possible to set a default time zone when setting the date on a scheduled BI report? our default time zone is London but when we open the calendar it defau…
-
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…
-
SQL tables to fetch Questionnaire data from performance goal feedbackThis the screen from where i want Questionnaire dataTanu.T.Sharma-Oracle 11 views 1 comment 0 points Most recent by InaNotra-Oracle Performance Management
-
Which table contains 'P45 Filed date' from oracle hcm payroll moduleProvide exact table name and column name to fetch ''P45 Filed date'' field. Field is from Calculation cards→statutory deductions→PAYE. Need this in data model and report.
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 11 views 0 comments 0 points Started by Srikanth Nakka Reporting and Analytics for HCM
-
Requesting details on the Fusion Tables used to extract “Tax Rate” from Values Defined by CriteriaDetails: We are creating an outbound custom BI Report to send Payroll Balance and Calculation Card details to Fidelity. One of the requirements is to extract Tax Rate of…
-
The filter should show just the Years: 2021 2022 2023 2024Hi, this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Fe…SenthilRaja 13 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …Sandy Suo-Oracle 219 views 6 comments 4 points Most recent by MFlannery Reporting and Analytics for HCM -
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 407 views 10 comments 0 points Most recent by Thomas Samuel19 Reporting and Analytics for HCM
-
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
Oracle table for termination reason in bip reportSummary: Unable to find the following data in oracle tables. I'm able to capture in otbi report, but we need a BIP report with same data and unbale to find in action rel…
-
OTBI Filter Criteriaanalysis result in error when no prompts are selected Errore Errore di visualizzazione della vista Errore durante l'elaborazione della query (SQLExecDirectW). Dettagli e…Rosita Santosuosso 14 views 0 comments 0 points Started by Rosita Santosuosso Reporting and Analytics for HCM
-
How to show custom dashboards under Dashboard Header Menu in Oracle Fusion Report & AnalyticsI have created custom dashboard and I want show that dashboard under Dashboard Header Menu as attached Help me how to achieve it. How to add custom dashboard to Existing…
-
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s… -
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, RaviRavi-Palacharla-Oracle 130 views 4 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
How to hide Page Options while accessing by managers Fusion Cloud HCMHi Team, Could you please to hide below Page Options (Edit dashboard, other options in it) while accessing by managers in Fusion Cloud HCM BIP.Chanikya Neelam-Oracle 1 view 0 comments 0 points Started by Chanikya Neelam-Oracle Reporting and Analytics for HCM
-
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t… -
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Query to extract all the updates made on employees assignmentsSummary: Content (required): Hello experts, when accessing the employee assignment page, it is possible to see users making last updates. Is there a query to extract all…Valerio Curzi 793 views 6 comments 0 points Most recent by VivekKumarAgarwal_CZTR1 Reporting and Analytics for HCM
-
Write a sql query to fetch average number of learning days per employeeSummary: Write a sql query to fetch average number of learning days per employee (includes all formal learning). Content (please ensure you mask any confidential informa…
-
Report BI - double column headerHi, is there an alternative to RTF for making a report with two headers on the columns? Example I have these columns: Organization Tot Male Female Tot Male Female Org1 4…
-
How to make the email confidential through bursting in BIPSummary: We have a requirement to make the email confidential in BIP , we are sending the email to recipients through bursting . Content (please ensure you mask any conf…
-
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 65 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Query to get the failure reason of a transactionSummary: Please share any sample query to get the issue description of a failed transaction Content (please ensure you mask any confidential information): From the scree…
-
what table stores payment date of quick prepayments?Summary: hi All , i need to get the below payment date for BIP but i am not able to get the table which stores this. Please help. i tried PAY_REL_PAYMENTS_VL PAY_PAYROLL…Divya Vaish 22 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM