BI Publisher
Discussion List
-
Include min function in value setSummary: Content (please ensure you mask any confidential information): Hello experts, I should manage the attached query in a value set. However in the VALUE COLUMN NAM…Valerio Curzi 37 views 11 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
how to find is there any attachment with the anytime feedback?Summary: need to find whether a attachment is there or not with anytime feedback Content (please ensure you mask any confidential information): Version (include the vers… -
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 70 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
Adding BI report dates prompt to dashboardSummary: Adding BI report dates prompt to dashboard Content (please ensure you mask any confidential information): Hi, I've a BI report which pull event data between two…Bhavna-Civeo 15 views 4 comments 0 points Most recent by Bhavna-Civeo Reporting and Analytics for HCM -
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…Rama123-Oracle 16 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
How to embed Logo/Images in BI Publisher RTF Template in RTF Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in RTF Output format Need to Embed Logo in RTF output format for BI reports Template. Content (required): …Bala Kasineedi 329 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…
-
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
What is the exact query to get all values of transaction consoleSummary: What is the Backend Query to get the transaction details of a particular transaction as it is appearing in the transaction console. Content (please ensure you m…JSAHOO1988 16 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Can we access the file contents of UCM file in BIP Report?Content I have a requirement to read the contents of the file placed on UCM in BI Report and am struggling to find the right table for this purpose. In EBS there was a t…Sricharan Monigari 599 views 7 comments 1 point Most recent by Juhi Singh Reporting and Analytics for HCM -
Unable to fetch Enrollment Action time, Disclaimer status and Assigned date in a BI report.We need to retrieve the Action Time, Disclaimer Status, and Assigned Date fields from benefit enrollment records for a BI report. However, these columns do not appear to…
-
Impact on BIP Schedule if Only Data Model is ChangedSummary: I’m planning to make changes to the data model of a BIP report. I want to confirm whether modifying only the data model will have any impact on the current repo…KHALED IHADDADENE 10 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …Vaishnavi Katiyar 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Options to control and monitor the download of Custom BI ReportsHi, We have a custom BI Report containing multiple layouts The client has raised a request to understand anyone options on how to do the below Information on options: Te…Steven_Bullock 18 views 4 comments 0 points Most recent by Steven_Bullock Reporting and Analytics for HCM
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.3K views 10 comments 0 points Most recent by Robinson Ng Reporting and Analytics for HCM
-
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1.6K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Approvals report secured by locationSummary: I have a requirement to create a report or analysis of approvals and their statuses, but it must also consider the employee’s location. The report should only d…Ismael Jimenez 14 views 4 comments 0 points Most recent by Ismael Jimenez Reporting and Analytics for HCM -
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 19 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Number of workflow Notification Emails sent from HCMSummary: Looking for number of emails sent from HCM through workflow notifications by Module identifier. For Example - Number of emails triggered by personal information…vinay karumanchi 17 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to …Vasanthakumar Ravi 13 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to add Days to Worker Hire Date in HCM Alert TemplateDear Team, Need help in rectifying below expression. ${AlertUtils.addDays(workers.workRelationships.StartDate, 10)} I need this add 10 days to hire date of an employee t…