Inquiry & Reporting
Discussion List
-
How to schedule ESS job and receive output through emailSummary: Hi, We want to schedule an ESS job 'Create Mass Additions' and it will also submit the child program 'Create Mass Additions Report' so user need the output file… -
Null Asset_ID in Asset_ID column of FA_APPROVAL_SUMMARY table impacts approval reportsSummary: I am trying to create a report that would list all the approvals that occur for our asset transactions. When I ran the table for FA_APPROVAL_SUMMARY for additio… -
FA Approval WorkflowHello, I have the following scenario: There are 5 approvers for Asset retirement Scenario (Serial) how can this be implemented in the approval excel sheet? Please advise… -
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… -
SQL Query for Fixed Asset YTD DepreciationSummary: Hello, We have a customized Oracle BI Publisher Report for Fixed Asset's YTD Depreciation. Our business requirement is that : When an asset is fully depreciated…
-
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…
-
To have a formal process for asset retirements including documentation and approvalsHello, is this feasible?
-
Where is the depreciation accounting string stored?Hi, I need to pull in the periodic depreciation accounting string (more specifically the description on the cost center value) into a report - which column is this store…
-
In Use Flag not checked on converted AssetsSummary: We converted a bunch of Assets and when running the Asset register report we are not seeing them on the report output. After some digging, we come to find that …Mary Frize 61 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
feasibility to clear the Asset Clearing account on a monthly basisHello, the business is requesting the check the feasibility to clear the Asset Clearing account on a monthly basis, even without having an invoice… is this feasible?
-
Asset Reinstatement identifier for linking with original retirementSummary: Asset Reinstatement identifier for linking with original retirement for Custom report Content (please ensure you mask any confidential information): Hi, We have…
-
Assets fully depreciated in the system, but still being used in real lifeHello, I have the following scenario: the clients acquired some assets many years ago. These assets were depreciating normally until they are fully depreciated on the sy…
-
Snapshot of assets for any periodSummary: We need to get historical data of asset within a particular period for audit requirement we are mainly concerned about attribute such as as cost, accumulate dep… -
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… -
-
FA to GL Reconciliation Report at Asset Category (Capital Asset Rollforward Report)Hi Team We are building a custom report to reconcile FA cost and Accumulated depreciation balances between FA and GL, at the Asset Category level.. We are facing few cha… -
Approval workflows for Asset transferHello, can we implement an Approval Workflow for transferring assets between employees, locations or Categories?
-
How can I find the depresiation_reserve field of the Asset Inquiry screen in Oracle Fusion in tablesHello, I am trying to obtain a value that I see on the Oracle Fixed Assets/Asset Inquiry in fusion screen, when doing the search and selecting the book in the financial …
-
What are the roles which provide blanket BU access or grant access to other asset books in FA moduleWhat are the roles which provide blanket BU access or grant access to other asset books in FA module -
Is it possible for me to have PO purchase item information within the FA, via flexfield or report?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is it possible to adjust the original cost of a fixed asset that was added from an invoice?I added an asset from an invoice, and it was successfully added and prepared. However, the original cost shows as 0, which is incorrect. I want to adjust the cost to mat…
-
What depreciation method to be used for Reducing Balance Method - Asset DepreciationSummary: Content (required): What method is to be used if the requirement of depreciation is reducing balance method? The depreciation calculation should be on the NBV. …
-
Duplicate records in FA_BALANCE_EXTRACT tableSummary: We are having issues with reconciling FA amount with GL amount due to some of the asset transactions have duplicate entries in the FA_BALANCE_EXTRACT table. Our…
-
How to set a depreciation fixed amount for an assetHello, We are using a "Flat" Method type with "NBV" as Calculation Basis with a ratio acordind to the remainig useful life of the asset, but the customer needs to change…
-
Fixed Asset OTBII am building an OTBI report for Fixed Asset where the objective is to display the Asset Cost, depreciation reserve and YTD dep at a summarized level for an asset When I…
-
Do we have unplanned depreciation report in Fusion Fixed assets ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PL Karthick Ramanathan 11 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
How to identify if the asset has been amortized or not?I am adjusting the cost of the asset and I am enabling amortization. When inquiring the asset, how can we identify that the asset has been amortized? Thank you
-
How to place the extract of a job sets which is using a seeded report "Asset Cost Reserve Report".I have created a job sets which will be running in parallel using the same report, but with different parameters. The only delivery channels present are Fax, Printers, E…
-
How to create a unique sequence for each asset, other than the asset number?Summary: Content (please ensure you mask any confidential information): We need a unique sequence for each asset, other than the asset number or tag number. Currently th…
-
Asset Cost Adjustment - NBV not as expectedHello, I have the following Scenario: I have an asset with Current cost = 7,434,175.00 and NBV = 5,204,938.30. This asset is already placed in service a couple of years …