BI Publisher
Discussion List
-
Extract Completion Type of Learning Evaluation activity in an offeringSummary: We're trying to report on the COMPLETION_TYPE (Required or Optional) of all activities in an offering. We've made use of WLF_LI_ACTIVITIES_F table to query the … -
Issue with Report Changes Not Reflecting After Clicking SaveWe encountered an unexpected behavior with one of our reports. We made some updates to the bursting, clicked the save button, but when we checked the bursting again, the…Michael Angelo Lucena 131 views 4 comments 0 points Most recent by Thri Gaadi Reporting and Analytics for HCM -
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 647 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM -
can we generate report to view how many users clicks on the custom page in oracle fusionSummary: can we generate a report in bi publisher to view how many users views or clicks on the custom page or any page in oracle fusion ui. Content (please ensure you m…Someshvar Bansal 73 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales -
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Phani S-Oracle 502 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
How to rename the Remote File Name, in order to display hour and minuteSummary: How to rename the Remote File Name, in order to display hour and minute Content (please ensure you mask any confidential information): Hi, we scheduled a BIP re…Barile Alberto 42 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to Schedule a BI Publisher Report with Dynamic time range in parameter ValuesIssue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle'…Rajesh Kumar Gunda 141 views 5 comments 6 points Most recent by Rajesh Kumar Gunda Reporting and Analytics for ERP -
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to run the Talent Profile seeded report?Summary: I need to export an XML file, but I won't be able to view all the fields and content sections. See below parameters used: Version (include the version you are u… -
We need to send files to Microsoft teams Through any automated processWe have a BIP report that needs to scheduled on a daily basis and we want to store those output files in Microsoft teams under Files Section. We don't want to store them…Kunal_444 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Table to get the Time Card Required field in Payroll Relationship page.Summary: We have a requirement to pull the "Time Card Required" field on the Payroll Relationship page. But we are unable to get the table. Please help me with the table…Rengaraj G 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 782 views 5 comments 0 points Most recent by Gokul Reporting and Analytics for HCM -
Derive Logo on Payment File Format by Legal EntitySummary: Content (please ensure you mask any confidential information): Does anyone know the logic to derive a logo on a rtf payment file format by legal entity? For exa…Rory Mullin 11 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management -
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…Ooha Pranathi Akkala 4.5K views 12 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM -
Data Model link between FSCM and OBIEE latencySummary: Data Model link between FSCM and OBIEE too slow. Content (please ensure you mask any confidential information): When I create a financial data model that links … -
Custom BI ReportsSummary: Content (please ensure you mask any confidential information): Hi Team, I am currently working on creating a custom BI query, and I have come across an issue. W…Srushti Dhote 64 views 3 comments 0 points Most recent by Swapnil Kashid General Ledger & Intercompany -
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. … -
query or table in service request managementSummary: We need to identify tickets that are not addressed for those requested information /response is already provided in Oracle service request management. We have c… -
Edit Bank Account Transfer XML PAIN 001 formatSummary: We are in the process of implementing bank account transfers and our bank is requesting the details in PAIN 001 XML format. Need help to get the XML format to e…Wilson Chelakadan 11 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 218 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
How to generate .ics file using BIP report?Summary: We are trying to generate an ics file and want to send it to the learner's email for their assigned activity Content (required): Version (include the version yo… -
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 62 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management -
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th…BDO Sue Cronin 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
User Role Audit ReportSummary: User Role Audit Report - We want to see when changes were made, who made the changes, what change was made, what role to user is added or removed Content (requi…SAKTHI SUNDAR 111 views 5 comments 0 points Most recent by User_BN0QX Reporting and Analytics for HCM -
Assignment Manager (Unsecured) Dimenssion in Goals Real Time SASummary Data Role Data security not working in OTBI, when using the Assignment Manager (Unsecured) Dimmension in goals Subject areaContent Hi Team, We are using the Dime…User_2025-01-23-22-36-48-692 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review … -
How to adjust the alignment of the bar graph for charts function in RTF Template of BIPSummary: Hi Team, The goal is to display a bar graph in RTF Template with question vs ratings. How to adjust the alignment of the bar graph for charts function in RTF Te…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM