BI Publisher
Discussion List
-
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… -
Generate CSV file output with column names from BI publisherSummary: Is there a way to exclude column names from printing on a csv file output using BI publisher? I created the DM and report and the csv output has the required da…Aaron Asher 155 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Query for Sales Order Contact at header and line levelSummary Query for Sales Order Contact at header and line levelContent Can you please share the query to get the customer Bill_to and Ship_to contact details at header an…AnishRV 24 views 2 comments 0 points Most recent by Kishore J-Oracle Reporting and Analytics for SCM -
Customised Create Customer Statements for multiple templatesSummary: Customised AR Customer Statements for multiple templates Content (required): The requirement is for the Customer Statement to print the correct logo based upon … -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S… -
The void has to be printed at the end after the payment total for all overflows.Bulk invoices are to be paid via check and the invoices are extended beyond one page, there is an obvious overflow. The expectation on payments is that it records the me…AaronJai 52 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Need to know Table names to get the offerings/Learning Initiative details from Learning Module in OrContent Hello All, I am developing a Report from Learning Module in Oracle Fusion HCM. I want to know the below details ,Please guide : 1) In OTBI Report: - i am using W…kanchana venkatasubramanian 1.7K views 3 comments 0 points Most recent by Kiran-HCM-Oracle Taleo Learn -
Total row should have same color according to the stage respectivelySummary: Total row should have same color based on the stage. Kindly check the screenshot. Content (please ensure you mask any confidential information): Version (includ…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
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 61 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Run report privilege not found after creating a job definitionSummary: I created a job definition to run a report by schedule process however, I am not able to find the privilege to assign to users in order to grant them access to … -
Need Expense table that stores the itemization detailsContent I am trying to create a BIP report that shows the Itemization data for accommodation expense type like Hotel Room Rate , Hotel Room Tax etc where the daily room … -
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 1 view 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 31 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 282 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 21 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 11 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 21 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 21 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 12 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 81 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
B S Rafatullah-Oracle 41 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 71 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Anyone having issues post 24A upgrade with OTBI analysis using the Payables Invoice subject area?We have several reports using the Payables Invoices - Transactions Real Time subject area that are not working as they did before the 24A upgrade. As soon as a filter is…Kristina P - National Heritage Academies 161 views 7 comments 1 point Most recent by Kristina P - National Heritage Academies Payables, Payments & Cash Management -
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 1 view 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 12 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 11 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 91 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM -