OTBI
Discussion List
-
OTBI Subject Area: Fixed Assets - Asset Depreciation Real Time data mismatchIn UI, Asset's Initial units were 100, And 66 units were partially retired and then Transferred out on Oct-24. So the current active units are 34 and the Depreciation Re…Vairasundar_1997-Oracle 4 views 0 comments 0 points Started by Vairasundar_1997-Oracle Reporting & Analytics for Fusion Service -
Facing Error while generating Fixed Assets Data in OTBIHello, We have around 30 Asset Books, For my user all the Asset Book access given. I'm trying to do an analysis in OTBI by using the Fixed Assets Depreciation Real Time …
-
How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end… -
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 25 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 15 views 0 comments 0 points Started by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP
-
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l…
-
Trouble Querying For PO Delegation DetailsI am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly …
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 25 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
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 73 views 5 comments 1 point Most recent by Todd Hensley Reporting and Analytics for HCM
-
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 143 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 12 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
withdraw issuewithdraw issue
-
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 13 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service
-
Need a query to link the Import costs process id with load interface id is passed as parameterHi Team, I am working on a query which is consuming by dell Bhoomi integration platform to the status of the ESS Job. So they are passing the load_request_id (the proces…
-
How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 3 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
why the Export Data has different results than Export FormattedSummary: why the Export Data has different results than Export Formatted Content (please ensure you mask any confidential information): We are actually trying to export …Kadali Harika 24 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…SHRUTI PRIYA 17 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
about assigning roles for OTBI report accessHello, I have some questions about assigning roles for OTBI report access. For cross-module OTBI reports, we created a duty role requiring 'priv1', 'priv2', and 'priv3' …M Wang 33 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting and Analytics for ERP
-
BICC PVO for privileges and their link to rolesIs there a BICC PVO for privileges and their link to roles ?keshav rowjee 2 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management
-
Drill Down in Reporting not workingSummary: My pivot table is coming up as not able to drill down into even though the settings are correct for it to be allowed to be clicked into, not sure what I'm doing…Gabby 13 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
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 63 views 8 comments 1 point Most recent by Calin Pavel Reporting & Analytics for Fusion Service -
Tables which stores the details of Request More Information for CandidateWould like to know which table stores the details that will be entered by the candidate when he/she is requested for More Information. The details may also include attac…Nalsoft Pvt Ltd 18 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
How to show a BI Publisher report along with an OTBI reportHi, I have a requirement to show a BI Publisher report along with an OTBI report. Is it possible to attach or embed a BI report inside an OTBI report? Also, if this is p… -
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 25 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM
-
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…
-
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 30 views 1 comment 1 point Most recent by Rakesh_Kumar_Sahu Reporting & Analytics for Fusion Service
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Reddy 7 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM