BI Publisher
Discussion List
-
How to add parameter value when scheduling AnalysisSummary How to add parameter value when scheduling AnalysisContent Hi, When I try to schedule Analysis using Agent, I can't find parameters which are available when it i… -
RFT with 82 column but word has limit of 63 columnsContent I need to develop a report with these 4 requirements: -column number 82 -Output format XLSX, -2 header rows -specific sheet name in the Excel with RFT template I…Nicola Petri 41 views 7 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM -
Filter Job Names in BI Publisher reportSummary I need to remove some Job Names from reportContent Hi, How do I go about removing the job name: CLEANER from the report attached? There will no doubt be others t…User_2025-02-05-22-44-35-842 20 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Is there any rest api to run the report and download outputSummary Rest api for BI analysisContent Hi, Is there any rest api availbe to run and BI analysis and download the output. eg: Lead analyis Regards, Sudheer. -
Subject Area to determine the Minority/Non Minority Status of a personContent Hi , I want to use a Subject Area which determines the Minority/Non Minority Status of a person. Can anyone please suggest. Thanks, - ManishaManisha Chakraborty 24 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Tuning SQL queriesSummary Does anyone have any hints or tips they can share on techniques to tune SQL queries in BI Data Models?Content I have a BI Report which contains a single data mod…Jon Taylor 72 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
OTBI: Need to display ratio between 2 analysis in a dashboard page.Summary OTBI: Need to display ratio between 2 analysis in a dashboard page.Content Hi, We have analysis 1: All Employees Head Count Analysis 2: HR Employees Head Count W…User_MC37Q 75 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859 Reporting and Analytics for HCM -
Email Approval Notification for expenses showing different currency in email Subject and bodySummary Email Approval Notification for expenses showing different currency in email Subject and bodyContent After 20D upgrade, we noticed When an email approval notific… -
How to meet that requirement for a report?Summary Output format XLSX, 2 header rows and specific sheet nameContent Hi community, I need to develop a report with these 3 requirements: -Output format XLSX, -2 head…Nicola Petri 26 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
HCM - Actual working hour and hourly wageContent Hello, I'd need to create a query (data model) for part-time employees in our organization for their actual working hour and hourly wage for a particular period … -
Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OSummary How to get the Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OBIEEMark kristan De los Reyes 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Page Composer: Align text to the rightContent Hi all, we have customized our "Request Learning"-page and beside others we have added a link. Now we have the requirement, that the text of the link should be d…User_2025-02-07-08-20-40-999 26 views 2 comments 0 points Most recent by User_2025-02-07-08-20-40-999 Learning -
Current and Proposed Values in a pending BPM workflowSummary Getting the Current and Proposed Values in a BPM workflow notification in BI reportContent We have a requirement to build a report where the HR Specialist can vi…Akash Kiran Jana 65 views 5 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
BI Publisher Report - Prompt IssueSummary The drop down list for selecting criteria will not wipe cleanContent Hi, Everytime someone opens this report the Business Unit, Package Type, Legal Entity and Lo…User_2025-02-05-22-44-35-842 26 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Is third party payment approval possible in Oracle Cloud ERP?Content Is there an ability in Oracle to send payment batches to third parties for approval? Here is the use case: Construction project A is partially-owned by Z Corp. C…Kevin Fehskens 23 views 11 comments 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management -
Event Trigger not working with multiple selection and null value passedSummary Event Trigger not working with multiple selection and null value passedContent In bip report we using multiple selection and null value passed parameter type, fo…VarunMittal2005 59 views 4 comments 0 points Most recent by VarunMittal2005 Reporting and Analytics for SCM -
Function in Formula Column like Report Builder(RDF)Summary Function in Formula Column like Report Builder(RDF)Content In BI Publisher do we have an option to build a function(PL/SQL) in the formula column. In RDF report … -
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?Walid Hamdy 59 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Add Date to Report OutputContent Hi all - I am really hoping you can help me solve this oddity with our BIP report export to Excel. A user reached out to me asking to turn back on the option of …Prudence K 22 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to Restrict old asset books to the AP user?Summary How to Restrict old asset books to the AP user?Content Hi All, How to Restrict old asset books to the AP user? We have 2 books in 1 Business Unit. Currently user…Devendra Thota-220620 37 views 3 comments 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Customer Details with SiteSummary Looking for Report for Customer Details with Site addresssContent Is there any custom or standard report for Customer details with Site addresses.Bilalemail 29 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Response UI : Workflow Notification Report parameter valueSummary How to get the parameter value of TimeCardApprovalNotificationBulkReportContent Hi All, We are trying to customize TimeCardApprovalNotificationBulkReport workflo…Badresh Pottabathini-248836 26 views 1 comment 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Busting subject line is appending withContent Hi, We have a bursting query to send a password protected file to employee's email. Now the subject line of email is coming as "[Not Virus Scanned] Your monthly …Nivya Mathire 24 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
need to generate BI publisher report in text format comma delimitedSummary need to generate BI publisher report in text format comma delimitedContent Hi, I have a requirement where I need to generate BI publisher report in text format c… -
How to create a Report with trend and costing dff details?Summary How to create a Report with trend and costing dff details?Content Hello , In reports OTBI type , the purpose was to get the cost trend details and also the cost …Revital Mefano 21 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Question : Migrate/Move Configs from On-prem Fusion to CloudSummary Looking for best way to migrate the config from on-prem fusion to CloudContent Hi Experts, As a functional user , I am looking for an answer to move/extract the …User_WB9R5 34 views 1 comment 0 points Most recent by User_ZLFIU Payables, Payments & Cash Management