BI Publisher
Discussion List
-
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 11 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 151 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 594 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 21 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 104 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 66 views 3 comments 3 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
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 94 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 226 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 92 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 5 views 3 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management -
SQL for Invoice Status based on As-of DateHi Team, Can you please help provide a sample SQL where I can select the invoice amount and status based on as-of date. For example, as of 24th Jan 2024.. invoice 001 wa…Kaz 53 views 2 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management -
Can ESS job Asset Register Report combine in one sheet?Summary: ESS job Asset Register ⇒ Asset Register Report split single asset in a single sheet. Is there any way to combine them into one sheet? Version (include the versi… -
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 259 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
Budgetary Control Dashboard CustomizationHello everyone, I've been wondering if there is anyway possible to edit/customize the built in Budgetary Control Dashboard. There are some values under each segment that… -
Workflow Transactions/Transaction Console Reporting (Rel 13)Content Hello, Just checking if anyone managed to create any Transaction Console related reports out of these two subject areas: 1) Human Capital Management - Transactio…SantoshKumarBhairi 941 views 11 comments 4 points Most recent by Samarpan Reporting and Analytics for HCM
-
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized …Soumya Prakash Parhi 603 views 11 comments 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Payment infotile on the Invoices landing pageSummary: Starting Update 22C, the Payment infotile on the Invoices landing page is no longer be available. Has anyone recreated the Infotile, and can share? Content (req…AVorster-Oracle 41 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…Neha Bhatt 231 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Does anyone know how to restrict data in BIP report based on user who will run it?Summary: How to restrict data in BIP report based on user who will run it? Content (required): Hello I am running report in BIP regarding no performance goal plan. Can y…Hazel De Castro 590 views 5 comments 0 points Most recent by Maddipati Ajay Kumar Reporting and Analytics for HCM -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …Maddipati Ajay Kumar 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 240 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
BI Publisher reportingI primarily use OTBI for reporting and then copy the SQL from these reports if I need to create a BI Publisher report. I do this because I find it so difficult to find t…Paul Morrissey 21 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Can we disable email notifications triggering with Outlook Integrations for ILT OfferingsSummary: Can we disable email notifications triggering for ILT Offerings with Outlook Integrations after running process "Sync Instructor-Led Training for Learning". Is … -
SQL Query - List Of Email-Notification DetailsContent We have a requirement to fetch all the Email-Notification Details (Recipient Email Address, Subject, Email Body Text., ) received by an employee. We have identif…Mano Haran-61126 1.8K views 4 comments 0 points Most recent by DevasishG Reporting and Analytics for HCM -
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…Maddipati Ajay Kumar 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM