BI Publisher
Discussion List
-
Add an Infolet Box of OTBI Report in Invoice Page like seeded infolet using SandBoxSummary: I am working on a requirement in OTBI where I need to create Infolets on the Invoice page in the front end, similar to the seeded Infolets, using Sandbox. There… -
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain…Ahmed Abdelhamid 331 views 4 comments 0 points Most recent by Rishabh257 Reporting and Analytics for SCM -
Change the rtf template for Receivables Aging by General Ledger Account for Multifund AccountingSummary: I've created a new rtf template for the "Receivables Aging by General Ledger Account for Multifund Accounting Report" and put it in the custom folder, but when … -
Leave balance ytd in oracle payroll run resultsSummary: Hi All, We have a requirement to get the Sick leave ytd balance in the report. Could you please help me to get the query for the same? or How can we get the Sic…Amarnath Podaralla 31 views 6 comments 0 points Most recent by Amarnath Podaralla Reporting and Analytics for HCM -
Table name that holds the Supplier Site Purchasing Tab dataSummary: Table name that holds the Supplier Site Purchasing Tab data Content (required): I'm trying to create a BI Report to monitor when PO's are not communicated out t…Richard Nagle 555 views 2 comments 0 points Most recent by Shiladitya Reporting and Analytics for ERP -
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 13 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 64 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 15 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 334 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 707 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 61 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 1 view 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