OTBI
Discussion List
-
asset category column for OTBI reportSummary: I am trying to create an OTBI report with Asset Category as one of the columns. I am facing issues with assets that have been transferred multiple times from on… -
Does the oracle supports the Asset depreciation calculation based on Original cost as well?Hi Team, Business has a requirement to have the Depreciation calculated based on Current Cost as well as Original Cost so as to show them as comparison in their Annual R…
-
Is there any report to show that assets has already gone through physical count process?I would like to know whether there are any report/field which identified that assets has gone through physical count process. For Instance, Asset A has gone through phys…User_1W1HV 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Fixed Assets ReportSummary: We need a report in Fixed Assets Module which shows the beginning balances for the selected company and year in the parameter and then multiple columns showing …
-
Beginning Balances for a few Entities (Segment1 from GL) is not there in FA_BALANCES_EXTRACT TableBeginning Balances for a few Entities (Segment1 from GL_CODE_COMBINATIONS) is not there in FA_BALANCES_EXTRACT Table when we filter on basis on those entities we aren't …
-
How to display the rate from the rate table in OTBI.How to display the rate from the rate table in OTBI, including the ability to show the rate across up to three dimensions. Using these subject areas: Incentive Compesati…Vinicius Sato 171 views 2 comments 0 points Most recent by Tejaswi Tatavarthi Incentive Compensation
-
Is there a way to filter the result of OTBI Report?Summary: I am creating Asset OTBI Report to capture the assets that registered with past dates since there is no standard report is available. I have created OTBI below …Karen Ito-Oracle 1 view 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Asset RegisterSummary: Looking for SQL query or OTBI report to get Project Segment (CoA) wise Asset Register Report. Balancing Segment, Cost Centre and Natural accounts are visible in…
-
Last login of service accountSummary: I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL que…
-
Asset Capitalization Date in OTBISummary: We have created an analysis on Depreciation Real time subject area. There is an asset which is capitalized in Mar-25 period with date placed in service as 15-Fe…
-
Accounts Receivable RollForward ReportSummary: Is there a delivered AR Rollforward report in Fusion OTBI? Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Scheduling Extract Assets Reporting Data JobSummary: We were trying to create an OTBI report fir fixed assets and noticed that subject area did not return any data. We executed job 'Extract Assets Reporting Data' …
-
Replicate Project segment Code to Asset Number with different Event Type in Oracle OTBI AnalysisSummary: Hi, I'm building an OTBI Analysis report using "Fixed Assets - Asset Transactions Real Time" subject area where the requirement is to copy the PROJECT segment c…
-
Configurable Attributes to Enrich Fixed Assets Assignment Information To opt-in this feature,Hi Configurable Attributes to Enrich Fixed Assets Assignment Information To opt-in this feature, we have created the DFF at FA assignments, but there is NO BI enabled fo…
-
How can we Restrict Users to Access data on OTBI/UI, particularly to those projects they assigned ?Summary: We have created a Custom Role to the Senior Projects Managers to view access on OTBI from """How Can Non Project Managers Access Review Project Performance Dash…
-
How to change the default Location flexfield Segment Label "State segment"?Summary: Hi, For the location key flexfield structure, we have 3 segments: Campus, Building and Room as segment1, segment2 and segment3 respectively. To assign the segme… -
OTBI which column is appropriate for only showing the Depreciation account code of AFFSubject Area: Asset Depreciation Real Time The Depreciation Account column displays not only depreciation accounts but also accumulated depreciation accounts. The column… -
Fixed Asset - Creating Cross Subject Area without SQLI am creating a cross Subject Area OTBI and having a problem. Fixed Asset- Asset Depreciation Real Time Fixed Asset- Asset Transactions Real Time When adding Asset Tran…Nao-Oracle 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Is it possible to combine one Finance subject area and also HCM subject area in a single OTBI reportSummary: Is it possible to combine one Finance related subject area and one HCM related subject area in a single OTBI report. Content (please ensure you mask any confide…Akhila N 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Duplicate rows in Fixed Assets Depreciation OTBI reportWe've created a custom dashboard to view our Fixed Assets Depreciation, based on the 'Fixed Assets - Asset Depreciation Real Time' subject area. We've found that some as… -
Duplicate rows in Fixed Assets Depreciation OTBI reportSummary: We've created a custom dashboard to view our Fixed Assets Depreciation, based on the 'Fixed Assets - Asset Depreciation Real Time' subject area. We've found tha…
-
Difference between Fixed Asset Descriptive Flexfield and Asset Key FlexfieldSummary: As per my understanding, both asset key and descriptive flexfield can be used for storing any additional information. I would like to understand the major diffe… -
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia…
-
Display location segment Value description in FA OTBI ReportSummary: Hi, in the 3 subject areas related to FA, only we can see the location segment code. we have a requirement to display the code description as well. but I cannot…
-
OTBI reports using cross of different subject areasSummary: Hi All, Is it possible to build OTBI reports using cross of different subject areas? For example: For Fixed assets, we have two subject areas: Fixed Assets- Ass…
-
Schedule otbi asset reportSchedule otbi asset report: If you schedule an OTBI Fixed Asset Report will it pick up the current Period if you tick the Use Trigger flag?
-
Report to reflect latest asset locationSummary: Report pulling through a line per location, even if it was updated Content (please ensure you mask any confidential information): We currently have an OTBI repo…
-
What kind of transactions processed by 'Extract Assets Reporting Data program'?Summary: Could I ask what kind of transactions processed by 'Extract Assets Reporting Data program'? Content (please ensure you mask any confidential information): Could…
-
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… -
How to download a detail report containing all fixed assetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…