BI Publisher
Discussion List
-
OTBI agent monitoringSummary: We have scheduled OTBI agents, We cannot able to find a way to monitor the agent status - whether its active? - Whether its still running? - how long its runnin…Prabhu Krishnamoorthy 122 views 7 comments 5 points Most recent by Louis K.Emezina Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 112 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
Receivable Invoice Report returns nullHi, When I ran the query it returns no rows -
report about changes the employee has madeSummary: Content (required): Good morning, Is it possible to have a report about changes the employee has made to Personal details, Additional personal details, and Bank… -
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 23 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 454 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM -
How to get asset register report in a single Excel spreadsheet?Summary: Currently assets are reported in Asset Register in separate Excel spreadsheets in one workbook. We have million of assets and this format is not usable for us. …Sohail M.-Oracle 99 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
Auditor is unable to view Preauthorized ExpenseSummary: We currently have two templates set up for expenses for our employees (1) PreApproval expense template — which a V.P. must approve; and (2) Actual Expense Reimb… -
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 225 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo… -
Record more than 150 Character in DFF fusion CloudSummary Need to store QR code string in DFF which is greater than 150 CharactersContent We are using Oracle Fusion Cloud Update 20D. We need to store QR code string in a…Manish Asawa 1.1K views 2 comments 2 points Most recent by Timeer Lagade Payables, Payments & Cash Management -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
offer approval notification template to include Requistion Approval History, Candidate CV etc.Summary: We have requirement to Include Links to Requisition Approval History, Candidate CV and Interview Feedback within the Offer Approval Notification template. Is it…Ginesh Chalil 12 views 0 comments 0 points Most recent by Ginesh Chalil Reporting and Analytics for HCM -
BI Publisher Report Auto Run - Open Report from home page instead opening from BISummary BI Publisher Report Auto Run - Open Report from home page instead opening from BIContent Hi Experts I have created a BI Publisher Report. i have taken the url of…Mansur Khalil 152 views 17 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM -
P2T Post Clone Tasks & Activities - ERP, EPM & PaaS/IaaS CustomerSummary: P2T Post Clone Tasks & Activities - ERP, EPM & PaaS/IaaS Customer Content (required): We are using ERP, EPM and PaaS/IaaS and we would like to know if there a d…Rihan Jameel 592 views 5 comments 5 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
Query functions only if "Connect By Prior" added"SELECT DISTINCT hrao.effective_end_date effective_end_date1, hov_inner.status status1, hov_inner.organization_id org_id FROM per_dept_tree_node_v pdt, hr_all_organizati…C R Anil 22 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …Maddipati Ajay Kumar 101 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report of 'Corrected Import Journals Errors'?Summary: We're looking for a report that shows us all interfaced journals that have been manually 'corrected' - is there a seeded Scheduled Process or OTBI report in Ora… -
Data Archival & retention for HCM CloudSummary Data Archival & retention for HCM CloudContent we wanted to know you what would be recommended best strategy for Data Archival & retention for HCM Cloud & do we …Ranveer.Tiwari-Oracle 64 views 3 comments 3 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
Query for Third Party payments along with involuntary deduction component referencesSummary: Delivered Third Party Payment Register Report is not fetching unpaid payments in the report along with the status. We need a query to retrieve the unpaid paymen… -
In OTBI, when I am using Subject Area, how can I generate XML for the dataI am trying to generate the report using OTBI for a particular subject area. What I want is that I should be able to generate XML of the data so that I can use this in B… -
BI reports Permission Related QuerySummary "Application Roles" and "Users" : Is it AND or OR?Content Hi, We have a query related to permissions given to BI reports. When you navigate the BI reports folder…User_MC37Q 95 views 2 comments 0 points Most recent by Lakshmi Bai-112908 Reporting and Analytics for HCM -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …Maddipati Ajay Kumar 221 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
CreateException:Index 6 out of bounds for length 6 in BIP reportsSummary: CreateException:Index 6 out of bounds for length 6 when I add 7th RTF template to the report I am getting below error and I am not able to delete extract RTF an…Gorla Shiva 87 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Generate ISOXML Payment Files in non-EnglishSummary: All our data entered for Suppliers and Bank Accounts were in English. We have countries like China, Taiwan, Japan and Korea requiring to send the files in local…Mani.Kumar 4 views 3 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management