BI Publisher
Discussion List
-
Learning OTBI reports does not retrieves data when item has no access view modeHello, I'm trying to build a report from the subject area Workforce Learning - Learning Management Real Time to extract learning history of workers (completed courses). …Victoire Bizieau 51 views 5 comments 0 points Most recent by HCM.Fusion009 Reporting and Analytics for HCM -
Create Data Model From View ObjectSummary: We are in an Oracle Fusion Saas environment. I have been looking at the View Object Data Model, We have Data Sources that populate for ERP and HCM in the dropdo…Christopher Haupt 21 views 0 comments 1 point Started by Christopher Haupt Reporting and Analytics for ERP -
BI Publisher - how to add watermark based on condition in RTFSummary: Content (please ensure you mask any confidential information): Dears , We have a requirement that a watermark to be appeared based on condition , like if the st…Beshoy Hakim-Oracle 15 views 1 comment 1 point Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
Requirement for Encrypted File Generation in UCM via BIPSummary: Hi, We are currently using Bursting in BI Publisher, where a .csv file is generated as the output and placed in the UCM Content Server. However, we have a requi…Mounika-Oracle 61 views 5 comments 0 points Most recent by User_WBPA1 Reporting and Analytics for HCM -
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…ManishaPatil 31 views 7 comments 0 points Most recent by Theresa White Reporting and Analytics for ERP -
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an…Parag Hiremath 2 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Powerpoint export of BIP report is showing unnecessary boxesHi , We have BIP report which has rtf template and when we are exporting this report in ppt format output is showing unnecessary boxes which are difficult to edit in ppt… -
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …Tauseef_Akram909 41 views 2 comments 4 points Most recent by Maureen Jones Reporting and Analytics for ERP -
Requirement to have 7 buckets in Customer Statement reportSummary: Client requires 7 buckets in Customer Statement Report. We have defined a statement aging method to have 7 buckets but only 5 buckets are visible in the report …Anand Kandasamy 12 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track… -
custom US Cheque Report repositioning when printed to a copierHi, I have built a custom US Cheque Report based upon Oracle's seeded US report. I am having issues after a test payroll is ran and converted to pdf and at that point th… -
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…Clifford Trett 331 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 703 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM -
create customer statements ESS job output in Excel formatSummary: Requirement is to generate Statements in PDF and Excel format for the standard ESS job "Create Customer Statements". No option to select output type as Excel. A…Anand Kandasamy 64 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g…Consultant Ian 41 views 6 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
LUHN check digitHI All We use LUHN check digit part of the check numbers and transaction numbers extract from ERP to the client payment systems. This is a common requirements in the pay…Murthy Kodavati 2 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
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… -
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… -
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc…Vishal Purohit 31 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (… -
Min-Max Planning Details Across All Orgs ReportSummary: Needs a query to fetch the Min/Max details for all the items across all the inventory organization in the application. Content (please ensure you mask any confi…Mamdouh Ahmed 11 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM -
Change Text format in dashboard BI publisherHi, is it possible change text format (size, format, color,…) in caption inside "Link or Image" in BI publisher dashboard ? Thanks, Han Xi ZhaoHan Xi Zhao 31 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct… -
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y… -
Deep Link for payment view in oracle fusionSummary: Please provide the deep Link for payment view in oracle fusion. Content (please ensure you mask any confidential information): Version (include the version you …User_B1ZBU 11 views 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management -
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found hereAllen D'Souza-Oracle 259 views 9 comments 3 points Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…Mamdouh Ahmed 21 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP