BI Publisher
Discussion List
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 26 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 126 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
BIP - Completed Learnings ReportSummary: Hello, Has anyone tried creating a BIP report that contains all of a learner's completed learnings at a course level? (Completed, Bypass Completed) Below are th…Hazel De Castro 66 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need to know tables used for storing geographies for use in BI publisher reportSummary: Can someone help me with names of tables that internally store all geography hierarchy information in HCM. I need to use this in my BI publisher report to extra…
-
How can I set the default of a date parameter to the same date in the prior year in Bi Publisher?Summary: Due to leap year, {$SYSDATE()-365$} is no longer working correctly to set the default for a date parameter to the same date in the previous year. Content (pleas…BeachDreamer 268 views 4 comments 1 point Most recent by BeachDreamer Reporting and Analytics for HCM -
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…Tom John Bontoyan 17 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
is there an easy way to extract all the data from a specific table?Summary: Sorry in advance if this has been asked but I have not been able to find a resource to help me. I am looking for an easy way to extract all the data from a spec… -
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 140 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are …
-
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
How/where can I get a glossary/dictionary of language pack translations for all UI text?Hi We are in process of implementing HCM & Learning cloud for 5 countries in Europe. As part of the implementation, we have a couple of custom reports (BIP) to be genera…Jayant Ankur Kujur 67 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Can’t design the RTF file in Arabic layout when the report exceed 64 fieldwhen the report extracted from system the layout starts from the middle of the excel sheet and technical advised that he can’t design the RTF file to start from the (Cel…Omar El-sherif 4 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
HCM Table To Fetch BCC Details From Report Job HistorySummary: Need HCM table to fetch BCC details from report job history Content (please ensure you mask any confidential information): Version (include the version you are …puja suryanarayana 34 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Query to find the email recipients of the scheduled BI ReportsSummary: Hi, Is there any Query to find the recipients of the BI Scheduled Report using Job. If I knew the Report name, I can get this details by Jobs History -> Edit . …Faqir 264 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIAEm-Jay 24 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How we can schedule report to a shared folder.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Abhishek.Sachdeva 18 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How can we determine what field BI Publisher Attributes are linked to ?Summary: Is there a search option that we can use to find out what field is linked to an attribute? Content (please ensure you mask any confidential information): Versio…Antonio Washington 26 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Randomization of employee list(from different BU/Department) for every runSummary: Report to fetch Random list employees for every run Content (please ensure you mask any confidential information): I need the report to fetch randomized list of…Raksha Govindaraj 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Charts in bip how to use more value columns in oracle hcm fusionSummary: Issue: 1- When I create chart it maximum allows to add 5 values but I have more than that to be added. 2- Percent split inside the bars how to display ? How to …Deepeeka Nath 14 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How can we add dynamic dates to a scheduled BI report?Summary: We would like to schedule a BI report (integration) to run every two weeks with the parameter date as the new payroll date. For example, run the report on April…Terri Butler 80 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
B S Rafatullah-Oracle 46 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Custom BI Publisher reports takes a long time to completeSummary: I created a custom BI Report. When I run the report it takes about 23 seconds to complete. When my client runs the report it takes almost 10 minutes to complete…Consultant Ian 70 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
BIP Report Citibank PaycheckHello everyone, I would like to ask if you have or if there are any existing RTFs that follow the specifications for Citibank Paycheck. Thank you.CAMIL_Q 7 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
BPM Approval notification BI report for "Request a New Position" notificationSummary: When an employee is moved between departments, a "Request a New Position" notification is distributed. This notification provides details on positional details …Maruthi T 19 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
Email bounce back notification fusion hcmSummary: Client have a requirement where in a recipient try to reply to "sender email address" an email bounce back notification to be sent to recipient. for example: De…Shiva Prasad M 18 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…Manoharan 71 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
-
Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…Afrid_3R3AE 19 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM