OTBI
Discussion List
-
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…Lia Naga 12 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service -
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…Omran Zeaiter 9 views 0 comments 0 points Started by Omran Zeaiter Reporting & Analytics for Fusion Service
-
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac…Arsen Guevara-CITCO 46 views 4 comments 0 points Most recent by JohnG Reporting and Analytics for ERP -
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca…
-
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…User_5FJ4I 72 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li…Calin Pavel 42 views 6 comments 0 points Most recent by Corey Brew-Oracle Reporting & Analytics for Fusion Service -
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 39 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdictionCindy Souvagis 32 views 2 comments 0 points Most recent by Cindy Souvagis Reporting and Analytics for ERP
-
Hello experts, do you have the SQL query to get the list of employees and their HR representativesHello experts, Do you have the SQL query to get the list of employees and their HR representatives? Regards, Hazel
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 520 views 6 comments 0 points Most recent by User_S6U3H Reporting and Analytics for ERP
-
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 83 views 2 comments 0 points Most recent by Biju Radhakrishnan-Oracle Supply Chain Orchestration
-
Export the list of configured time attributes and display value from Time entry layout componentsIs there a way to export the list of configured time attributes and display value from Time entry layout components? We are comparing 2 different layouts and it will be …
-
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can …
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…Ploy 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr…Simon Kaplun 25 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…Vitor Nakamura 58 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Sales
-
How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which…
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 36 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 63 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…Amritha2184-Oracle 31 views 3 comments 1 point Most recent by Mark Di Ponio Reporting and Analytics for HCM
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 70 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 34 views 1 comment 0 points 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
-
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 17 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 44 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for ERP
-
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 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…vikram khengare 21 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for SCM
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 21 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP