BI Publisher
Discussion List
-
Looking for a sql query to get the absence plan and corresponding element name associatedSummary: Hi, We have a requirement to get the data of the Absence Plan and corresponding element data using the sql. If anyone has come across such requirement then plea…Peeyush Chandel 3.9K views 1 comment 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM -
Provide access to OTBI report by Area of Responsibility by BUSummary: Content (required): We have a requirement that the user will have only Employee and/or Line Manager Role and they should be able to fetch the employee records i…Vinay Gharge 251 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get list of all the reports that are run in the last 3 monthsSummary: Is there a way to get list of all the reports that are run in the last 3 months in Oracle Fusion(Not just ESS Jobs but also run directly in catalog). Content (r…VinayGeddam 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers…MilanMohanty 271 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Email Address for Implementation Users in FusionSummary: Team, I would like to know the table in which the email address of the implementation users are stored. As they are not tagged to employee record, we will not b…Sumedh Kumar-Oracle 31 views 1 comment 0 points Most recent by Sumedh Kumar-Oracle Reporting and Analytics for HCM
-
How to query if a pending worker to EMP was converted with manual or auto conversion?Summary: Is there a query to determine how a pending worker was converted to EMP (ex: "include in auto conversion" or "quick convert")? Content (required): Is there a qu…Jessica DiCerbo 676 views 2 comments 0 points Most recent by Jessica DiCerbo Reporting and Analytics for HCM -
Turnover- Last 3 monthsSummary: Content (required): trying to add a filter for the last three months but nothing is pulling - I tried several sql expressions and repository variables xml attac…Riti Malhotra 41 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get SQL query details of BI Report data modelSummary: Hi , We need to identify list of Data models which is using a specific column in BI Report SQL query. We have two option , first is to verify manually all data …Niraj 2.6K views 2 comments 3 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is it possible to create new/custom infolets ?Content Is it possible to create new/custom infolets ? Version 19CCaio Zioli-Oracle 97 views 5 comments 0 points Most recent by Manishsrf7 Reporting and Analytics for SCM -
Award Project amountsSummary: Award Project amounts Content (required): Can you please help me with table name or query to extract amount on Manage Award --> Open award --> Financial Perform…Nidhi Chhajed 11 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
How do I implement custom barcode fontSummary: We have a requirement to print barcodes in BC3of9 and Code128 fonts. We implemented using the delivered Oracle-supported fonts. However, the client tested and s…Lisa Taroma 132 views 2 comments 0 points Most recent by Lisa Taroma Reporting and Analytics for ERP
-
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…
-
Is it possible to report on requisition approval volumesSummary: Our business users are asking for reports to see who has approved purchase requisitions made in the business so that they can track volumes etc. Does anyone hav…DLMorgan 21 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Pull all active and terminated employee or single employee based on person numberSummary: I want to fetch all the records of active and terminated employees or single employees based on the person number parameter and history of all the employee chan…Deepak Bhatt 2.8K views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Report on Temporary Global TransferHello Is it possible to report on the field 'When do you expect the new work relationship to end?' available on Temporary Global Transfer through OTBI?
-
22B - Manager Resources Dashboard - white screen for around 15 seconds before loadingSummary: Since 22B deployment, our dashboards are taking around 10 - 15 seconds to load... Content (required): Has anyone else got an issue loading dashboards? Since 22B…Kevin M Storrie 61 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Getting error in Headcount OTBI ReportSummary: Hi all I am using the below Subject area Workforce Management – Worker Assignment Real Time Compensation – Salary Details Real Time Workforce Management – Perso…Deepak Bhatt 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table details which store scenario present on Inquire on Detail BalanceSummary: Table details which store scenario present on Inquire on Detail Balance Content (required): Version (include the version you are using, if applicable): Code Sni…Nidhi Chhajed 361 views 8 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
Where we can find predefined template for cloud hcm notifications ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):priyankatriv 21 views 16 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM
-
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…