BI Publisher
Discussion List
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 2 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Syntax To Pass Dynamic Parameters in Custom LOVs for ESS Jobs parametersSummary: We have created an ESS job which has 2 parameters : Business Unit, Contract Number For the Business Unit Parameter we are using the standard LOV. But for Contra…KannanM 153 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
unable to see data in IEX_BANKRUPTCIES table any standard report available?Summary: Unable to see data in IEX_BANKRUPTCIES table , is there any specific job role to view the data in this table or is there any specify bankruptcy report available… -
Oracle roles required for developing BI reportSummary: Need to know what Oracle roles are required for an user to develop BI report Content (please ensure you mask any confidential information): Version (include the… -
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 186 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Searching for table containing segment values and descriptionsSummary I'm writing the SQL in a data model where I need to display account value and descriptionContent I'm creating a data model where I want to display segments in th…User_2025-01-25-00-55-11-011 1.6K views 8 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 337 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP -
How to print tables side by side in BI publisherHi, I was trying to develop a rtf template to print the Invoice copy. As part of the requirement, I need to print tables side by side. I was able to add the tables side …AVN 162 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Report to extract Assessment Questionnaire of Learning sectionSummary Need to extract assessment questionnaire of an offering linked to a learnerContent Hi All, I am trying to extract the assessment questionnaire with the answers i…teresa.marciano 719 views 3 comments 1 point Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBISummary Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBI or BIP?Content Hi Experts, We are working on a requirement to…Harish Kumar Kovi 197 views 4 comments 0 points Most recent by 'Reekey Reporting and Analytics for HCM -
Oracle BIP Report -> Timezone Issues (displays +5 hrs)Summary timezone offsetContent Hello, Can anyone please help me? I have a learning activity with a start time of 08:00 am and with timezone of EST. When it is included i…SantoshKumarBhairi 139 views 8 comments 1 point Most recent by Cristelle Dahak Reporting and Analytics for HCM
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 381 views 4 comments 0 points Most recent by Subbareddy Kandala Reporting and Analytics for ERP
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 346 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Custom data model for Invoice PrintSummary: We want to print invoices for bundle items, means display only the bundle price in the invoice print. Can we have custom data model? Content (required): Version… -
Dashboard Performance for performance document reating distribution no resultSummary: when open Dashboard Performance for standard line manager Dashboard , the result for performance document reating distribution not showing . Content (please ens…Mohammed Alharbi 23 views 1 comment 0 points Most recent by Mohammed Alharbi Reporting and Analytics for HCM -
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…Nidhi Chhajed 31 views 3 comments 0 points Most recent by Lakshmanji Karupalli Reporting and Analytics for ERP -
Can HCM OTBI output file be password protected like BI Publisher ReportSummary Can HCM OTBI output file be password protected like BI Publisher ReportContent Hi, We know how to BI Publisher report output file can be password protected with …User_2025-02-05-22-36-27-300 91 views 11 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Course completion certificate template is not available for selectionHi All, After going through following link I understand that to configure the Completion Certificate we first need to copy the seeded templates and move them to custom f… -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
Alternative ways to Schedule Reports, Agents and Report Bursting as opposed to using a Generic userSummary: We currently use a generic user which is against our IT internal controls (so have an open Risk we track). We are looking to establish if other customers have t… -
What are the control reports to be run on the fresh instanceSummary: We are going to start testing and want to run the control reports in the fresh instance. Could you let me know what are the control reports to be run. The modul…Lal11 32 views 3 comments 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 152 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …SSS Song 99 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec… -
how to change the hyperlink text in the workflow checklist tasks notificationSummary: I am trying to change the "More details" hyperlink to "Click Here". attached is the data model, xml output and rtf template screenshots any idea ? Content (plea…Shlomo Elnekave 12 views 1 comment 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
hi all, by any chance can you point me to the join between per_person_names_f and CMP_PLANS_BSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 31 views 2 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 81 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM