Inquiry & Reporting
Discussion List
-
Is there a "View Only" Role in Fixed Assets?Summary: Need a role that allows for "Inquire Assets" function, without giving the user with this role the ability to create or modify assets. Does a role like this exis… -
Changes of Accounts column in Asset Cost and Reserve ReportSummary: In Asset Cost and Reserve Report (standard report) in Oracle Fusion Assets, we want to understand the calculation logic behind the "Changes of Accounts" column.…
-
Segment Value Security in Fixed AssetsSummary: Content (required): Hi everyone, Does segment value security work on Asset assignments? eg. Would the segment value security for GL Balancing segment work in Fi…
-
Is there a way to delete non-FBDI data from Fixed Assets interface tables for FA_MASS_ADDITIONS?Summary: The only existing docs and samples that I see are for Mass Retirements, Mass Transfers, and Mass Adjustments. Content (required): I wanted to delete my Incomple…
-
Why do I have this error when I run Mass Revaluation on FBDI?Summary: Content (required): My open period is May-23 but I'm trying to backdate my Revaluation Date which is March 2023. Is that possible? Version (include the version …
-
Asset Additions by Responsibility Report returns no dataSummary: Asset Additions by Responsibility Report returns no data Content (required): Assets have been added for Jul-23 and Jun-23 with back dated effective dates. When …
-
Is there a way to remove non-FBDI data from interface tables (sample: FA_ADJUSTMENTS_T)?Summary: We want to delete non-FBDI data from Fixed Assets interface tables such as: FA_ADJUSTMENTS_T, FA_TRANSFERS_T, FA_RETIREMENTS_T. What other ways we can explore w…
-
Is there a report showing depreciated assets?Summary: We have a customer wanting a report to show depreciated assets. Content (required):We have built a Journal Entry Reserve Ledger analysis based on the Fixed Asse…
-
Any reports that show the depreciation adjustment amount separate from the depreciation amount?Summary: Any reports that show the depreciation adjustment amount separate from the depreciation amount? Content (required): Any reports that show the depreciation adjus…
-
Options to link Financial Fixed Asset with Maintenance / Install Base Fixed AssetSummary Options to link Financial Fixed Asset with Maintenance / Install Base Fixed AssetContent Hi Client uses both Financial Fixed Asset register and the Maintenance /…
-
Any report could be generated with PO details related to fix assetSummary: Any report could be generated with PO details related to fix asset? Content (required): Version (include the version you are using, if applicable): Code Snippet…
-
Depreciation issueHello, we are facing an issue in FA. we added an asset for 9 years, without depreciation in the first place. Then we adjust it to depreciate after 7 months. the problem … -
How to link Oracle Purchasing (PO Receiving) to Oracle Assets (mass addition asset by PO Receiving)Summary: setup the CAPITALIZATION OF FIXED ASSETS FOR EXPENSE DESTINATION RECEIPTS IN THE PROCUREMENT PROCESS (https://www.oracle.com/webfolder/technetwork/tutorials/tut…
-
Mass Addition FBDI Depreciation MethodSummary: Hi Team, I am facing an error "The depreciation method for this book is invalid." while trying to import Asset data through FBDI. Content (required): Hi Team, W… -
Creating Asset Cost Summary Report in OTBISummary: Creating Asset Cost Summary Report in OTBI Content (required): I created "Asset Cost Summary Report" in OTBI, however, I am not getting back the balances as the…
-
SQL query to get remaining life, depreciation for the month, depreciation expense account in FusionSummary: SQL query to get remaining life, depreciation for the month, depreciation expense account in Oracle Fusion for Assets Content (required): Version (include the v…
-
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… -
How to flow a DFF field from AP Invoice Distribution to Asset Categories DFF under Asset AdditionsSummary: How to flow a DFF field from AP Invoice Distribution to Asset Categories DFF under Asset Additions page? Content (required): We have a requirement to flow the p…
-
Converted Asset - YTD depreciation wrongSummary: We have converted assets, where the file was loaded with depreciation calculated for the month, and then at month end, depreciation ran again for same month. So…
-
Database Update for Fixed Asset AdjustmentSummary: When is the database updated when an asset is adjusted? Content (required): We are in the process of building an integration to a 3rd party. We are finding that… -
Asset Assignment History is not available in FA_TRANSFER_T and FA_TRANSFER_DISTS_T tablesSummary: Asset Assignment History is not available in FA_TRANSFER_T and FA_TRANSFER_DISTS_T tables. Content (required): We want to get all the asset assignment details. … -
Projection report for Fixed Assets in Oracle Cloud similar to EBSSummary: Hi All, Our client is currently on EBS and in EBS there is a functionality to run Projection Detail Report and Projection Summary Report for Fixed Assets Deprec…
-
Report for assets deleted from queueSummary: Can a report be built for assets which are deleted from the queue and not posted in FA module. Can we store them somewhere and pull the details in a report? Ple…
-
Difference between What-if Analysis report and Trial Balance report, on a specified Account.Hello, I am facing an issue. There is a difference between the "what-if analysis" and the trial balance. Can anyone give some tips?
-
The issue: No results has been found in report and the impairment cannot be posted.Dear All, Kindly not the following Steps that I took: 1- From Assets --> Taskbar --> Impair asset --> Click on "+" icon to download the spread sheet 2- In the Spreadshee…
-
How to Post Impairment of an asset?Hello, I have 3 questions: 1) How to Post Impairment of an asset? 2) How to add the Net Book Value? 3) What are the steps to be taken after posting so that the report of…
-
How to modify Asset Cost Summary ReportSummary: I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Summary Data Model. If I save the sql (as-is, no modifi…
-
What is the purpose of the Include User Transaction Identifiers parameter in FA Create Accounting?Summary: What is the purpose of the Include User Transaction Identifiers parameter in FA Create Accounting? Content (required): I have gone through Support notes 1501617…
-
Need to impair bulk group of fixed assets (Category)Summary: Content (required): There is a requirement to impair more than 200,000 fixed assets. This can be done if there is an option to impair whole category. Is there a… -
Mass Unplanned DepreciationSummary Mass Unplanned DepreciationContent Hi All, I have a bunch of assets on the secondary books that need depreciation adjusted by a few pennies in order to align to …