BI Publisher
Discussion List
-
table which stored the information collective agreement in user profile/Person managementSummary table which stored the information collective agreement in user profile/Person managementContent Hi all, Which table store the information collective agreement i… -
Learning in OTBI - subject areas changing in 2021?Summary In a recent product forum or webinar it was highlighted that by 21B there will be a subject area called 'Learning Assignments' deprecatedContent In a recent prod… -
Can we create the output as .txt file in analysisSummary Can we create the output as .txt file in analysisContent i have created a analysis to fetch the assignment number for all the employees.but we need the output as…User_2025-02-05-02-11-29-794 33 views 8 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
End Dated Scheduled ProcessesSummary End Dated Scheduled ProcessesContent Hi Team, We have observed some of the scheduled process got stopped in our production environment. this might be due to end …nitin Sharma 32 views 4 comments 2 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal pSummary Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal plan, FYI notification get triggered)Content Hi Expert, Query/… -
Embedding a BIP reportSummary Embedding a BIP report in the tool with all the functionalityContent Hello, Does anybody know... When you embed a BIP report into the Operational tool, does it c…User_2025-01-22-20-09-02-352 86 views 7 comments 2 points Most recent by Mohana Gopal S-Oracle Reporting & Analytics for Sales -
Documentation for Sales - CRM Pipeline Facts 11.1.1.9Summary Documentation for Sales - CRM Pipeline Facts 11.1.1.9Content Hi, Is there a documentation for Oracle Business Intelligence 11.1.1.9 subject area metric measures?…User_2025-07-18-06-07-44-367 46 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Ability to override tax on credit memo which is referenced to invoiceSummary Ability to override tax on credit memo which is referenced to invoiceContent Hi All, We need to override the tax amount to zero for credit memo which are referen…Devendra Thota-220620 84 views 2 comments 1 point Most recent by Cristian Bilibou-Oracle Tax & Global -
Expenses approval is not going to line manager.Summary Expenses approval is not going to line manager.Content Hi All, Expenses approval is not going to line manager. Thanks, Dev Thota. Version 20D -
User behavior and AnalyticsSummary Is there a BI table which captures information on user behaviorsContent Our customer is looking for information on user behavior - which Fusion page is being use…Akash Kiran Jana 27 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Translated Customer NameSummary Translated Customer NameContent How to get Translated Customer Name as we are uploading Customer into English but we need invoice report in both language "ENGLIS…Sandeep Nihalani 286 views 3 comments 5 points Most recent by Baskar.Chakravarthi Receivables & Collections -
Need a SQL Query to fetch previous employment element entry details.Summary Need a SQL Query to fetch previous employment element entry details.Content Hello Team, I have a requirement to fetch Previous employement element entry details …User_2025-02-10-16-28-01-402 724 views 2 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM -
Reporting HCM Catalog Group and Folder PermissionSummary Creating report to get the list of accounts under Catalog GroupsContent Hi All, I know that we can able to report within OBIEE Reports by creating Data Source. W…User_2025-02-04-07-19-57-588 44 views 2 comments 2 points Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM -
Listing of all FIN reports in foregin languageContent Hi, Can someone let me know where we can find full list of reports ( jobs) available for Financials offering but with translation on Russian Language? When loggi…Liubov Morozova 24 views 1 comment 1 point Most recent by Mary Ramirez-Oracle Reporting and Analytics for ERP -
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…User_2025-12-05-01-24-53-219 17 views 2 comments 0 points Most recent by User_2025-12-05-01-24-53-219 Reporting and Analytics for HCM -
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna Chidella-Oracle 53 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Unable to add Negotiation Icon to the Springboard and Navigator.Summary Unable to add Negotiation, SQM, Catalog Icons to the Springboard and Navigator.Content Hi Fellow Practitioners, Season's greetings. I have done all the necessary…Prateek Moroney 159 views 1 comment 0 points Most recent by Yogesh_P-Oracle Reporting and Analytics for SCM -
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 39 views 3 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Merge Values Created By Duplicate Sales Stage NameSummary Merge Values Created By Duplicate Sales Stage NameContent Hi, I created an analysis in OTBI and the Sales Stage Name is creating two sets of # of Opportunity Val…User_2025-07-18-06-07-44-367 34 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t…
-
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1.1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572 Reporting and Analytics for HCM -
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 155 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 284 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Email NotificationsSummary Disable email notifications for all those who are on long leaveContent Team, we have few employees who are on long leave due to reasons like Maternity leave or P… -
Restrict access to Reports and Subject areaContent Good day, everyone! Could you please tell me if there is an option to restrict access to reports based on roles? I also wondering if is possible to restrict acce…Kristina Serikova 41 views 2 comments 2 points Most recent by Kristina Serikova Reporting and Analytics for HCM