OBIEE
Discussion List
-
Enabling of OBIEE12c Agents As-IS during MigrationSummary: We need to move over 1000+ automated agents from our test system (DEV) to our live system (PROD) in OBIEE 12c on Linux. Normally, when we move these agents, the… -
Would it possible to extend the sql quey time limit.Hi Team, There is an BIP report scheduled and it was taking more than 1800 secs to run. While it was crossing 1800secs the report is failing. Is there any way we can ext…MaheshRayudu7 7 views 0 comments 0 points Started by MaheshRayudu7 Reporting & Analytics for Fusion Service
-
Query to get the prepayment Amount ValuesSummary Dear All, I am creating a BIP report, In which I need to calculate the number of employees processed in the payroll run and sum of total amount in processed in p…VaibhavChavan20_ 13 views 1 comment 0 points Most recent by VaibhavChavan20_ Reporting & Analytics for Fusion Service
-
Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per…
-
Parameters and lists of Value in the analysis are not inherited into the BI Publisher Data ModelHi, Expert I encountered the case that I developed an Analysis and Prompts within it. Subsequently, I built a new Data Model, designating the Analysis as the dataset, bu…ICE Pratchapon 65 views 1 comment 0 points Most recent by ICE Pratchapon Reporting and Analytics for HCM
-
I have build the report using service request object with custom subject area but getting error.Summary: I have build the report using service request object with custom subject area and trying to map the reference number to SR number (custom object custom field) b…Manjula Bellamkonda-Oracle 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 3 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
BICC external storageSummary: We have to send bicc files to external storage allocated in a s3 site. wich kind of serviceName i'll request from my aws technician to make bicc get container n…
-
Subject Area Related to CE_BANK_ACCOUNTS to get bank account Num & Asset Code Combination IDI am using "General Ledger - Journals Real Time" Subject Analysis & need to Join using Code Combination ID to get above bank account numSagarChadha 22 views 2 comments 1 point Most recent by SagarChadha Reporting & Analytics for Fusion Service
-
Offer details are not getting stored in transaction table (HRC_TXN_HEADER)When an offer is sent for approval and after approval if the offer is "Re drafted" and edited then the table "IRC_OFFERS" is storing the latest data. Whereas i need to f…Nalsoft Pvt Ltd 13 views 0 comments 0 points Started by Nalsoft Pvt Ltd Reporting & Analytics for Fusion Service
-
ORC Job Offer Letter has got a different font than the RTF Template.Hi Team, I am currently facing an issue on the Job Offer letter in ORC,the customer is using their own custom font style for branding purpose. I am using the same font s…Beatrice C 32 views 1 comment 0 points Most recent by PatriciaS-Support-Oracle Recruiting, Opportunity Marketplace
-
How to get same data in two data sets in the same data model without any data model link.We have 2 different data sets in the same data model, and we have a common column in both the data sets but without a link. Can we get same data based on the common colu…Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…Bobba Anil 61 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get Roles hierarchySummary: A query to get role hierarchy by role ode Content (please ensure you mask any confidential information): Want a query where i can pass the role code, and get al…Osama_Mo 128 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 103 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Required SQL query to get Customer Opt in featureSummary: Required SQL query to get Customer Opt in feature Content (please ensure you mask any confidential information): Hi Team, We need the SQL query to get Oracle fu…Opkey PA 222 views 2 comments 1 point Most recent by Biju Radhakrishnan-Oracle Supply Chain Orchestration
-
CRC 32 - Hash in Oracle fusionHello , We have one requirement where it has been asked to convert the 16 digits column value ( The site ID from Account Payable) into a CRC 32 HASH value. I did not fin…VarshaK 41 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Needed for Custom Query Mapping in ORC to CORE HRHi Team, I hope this message finds you well. I wanted to reach out regarding a custom query I created for the offer creation page in ORC. While I’ve made some progress, …Girish Kushibi 25 views 2 comments 3 points Most recent by Girish Kushibi Recruiting, Opportunity Marketplace -
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC.Gowri Perumal 71 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Where can i find Item Drawing Number in Oracle Fusion ERP tables ?I Am trying to search for "Drawing Number" in oracle fusion ERP tables, it might be an Attribute but I am not getting in which table I can find this attribute. Please re…Dona Sengupta 12 views 2 comments 0 points Most recent by Dona Sengupta Reporting & Analytics for Fusion Service
-
Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co…MD-JMS 183 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 111 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Download sample issue for the PVO in BICC consoleSummary: Below are the list of PVO's which are having the download issue for sample file 1.FscmTopModelAM.FosOrchestrationProcessAM.TransactionEventPVO 2.FscmTopModelAM.…Soare Oldrich Alexandru-Oracle 50 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex…
-
How to reduce execution timeHi, I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.…Madhu A 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 2 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service