Inquiry & Reporting
Discussion List
-
Which report can be used to reconcile balances between Assets and the General Ledger?Which report can be used to reconcile balances between Assets and the General Ledger? -
💡What If Depreciation Analysis Report - Limitations and FunctionalitySummary: What is the logic behind the functionality of the What-If Depreciation Analysis Report? Solution: Running the What-If Depreciation Analysis Report is a two step… -
Intercompany DFF Values Dependency on the Original Transaction BatchSummary: We have two DFF's on the Distribution lines and we are reversing the original transaction batch manually, it is possible to retrieve the two DFF's to Compare by… -
Impact of deleting asset after depreciation method changeHello Oracle Community, We are seeking guidance regarding the potential impact of deleting an asset in Oracle Fusion Cloud Fixed Assets in our production environment. Ba…
-
Fixed Asset Original Cost doesn't match with Asset details Line Amount.Summary: When Asset us added into FA from Projects, Asset created with type Addition and current cost is 26,802.54. But if you to go Source lines and select Project Numb…
-
How are temp tables FA_BALANCES_REP_GT and FA_RSV_LEDGER_REP_GT populated?Summary: Would like to know how these temporary tables are getting populated. Which table is it getting the fields from like amount, cost_begin_balance, source_type_code…
-
Fixed Asset RegisterSummary Looking for a fixed asset register reportContent We have recently implemented the fixed asset module. We are looking for a fixed asset register report whereby it… -
How to add credit note for an invoice from previous month to current month on a retired asset.We have a scenario that is disturbing our books. We received an invoice in Feb, that got transferred to Assets and Asset got successfully created. The team then retired …
-
Modify Asset Inquiry Search Via SandboxSummary: Content (please ensure you mask any confidential information):On the Asset Inquiry page, we want to modify the Tag Number field name embedded in the search quer…
-
oracle fusion assets 'property tax report' don't have any dataSummary: oracle fusion assets 'property tax report' don't have any data Content (please ensure you mask any confidential information): Version (include the version you a…
-
How to add Lessor name in Journal description rule for FA lease entriesSummary: Business wants to add Lessor Name in Journal description rule for FA Lease entries Content (please ensure you mask any confidential information): Version (inclu…
-
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…
-
Inactive Date on Fixed Asset BookSummary: Due to tax issues we had to create a new legal entity and business unit for one of our groups and move the existing BU to the new legal entity and business unit…
-
Asset Key Flexfield - one of the segments as dateSummary: Is it possible to set-up one of the the Key Asset Flexfield segments as date? Meaning the Validation Type Independent / or alternatively/ Format Only Value Data… -
Process prepaid invoice amortization using Fixed AssetSummary Process prepaid invoice amortization using Fixed AssetContent We started to use Fixed Asset to track/handle prepaid invoices amortization. Is there anyone else d…
-
Displaying PO Line and Receipt Number in Asset After PO Receipt Mass AdditionWe have a requirement to track purchase orders in detail, including the PO receipt, from the mass addition asset process. We executed the standard program "Transfer Rece…
-
Journals for mexico reportI am trying to run Journals for Mexico report . every time i run the report it is STATUS shows retrying. it is not producing any output. Can anyone tell me in the parame…
-
Unable to fetch accounting information from asset transactions screenHi, We have a requirement to fetch accounting information for an asset transaction for a particular class. We need to understand the links in between to create a BI repo… -
Employee Name list of value on Asset Inquiry page lists all employee across LE. How to restrict thisSummary: Employee Name list of value on Asset Inquiry page lists all employee across LE. Business requirement is to restrict list of values to show only employees for th… -
Is it possible to Migrate the assets created in the Book by defining another BookHi Team, We have migrated the assets in one book, Due to Account Changes in the Category business wants to migrate the assets again by defining Another Book. Is it possi…
-
Physical inventory taken date is recorded in oracle fusion assets, unable to extract same in reportIn Oracle Fusion Cloud Assets, the “Physical Inventory Taken Date” is a feature designed to record the date when a physical inventory count is conducted for fixed assets…
-
Deleting assets from transfer queueSummary: Trying to delete assets from the transfer queue in assets page of stratus. I have successfully deleted assets from the retirement queue, but process is not the …
-
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 …
-
SQL Query to Link Maintenance Work Order Asset to Fixed AssetDear all, Could anyone please share the SQL query to link the maintenance work order asset to the fixed asset? Thanks and best regards, George Mattar
-
Problems with OTBI "Asset Transactions Real time" subject areaSummary When creating an analysis, some data is lostContent Hi, I have faced some issues with subject area "Asset Transactions Real Time" and I was wondering if anyone e…
-
Issue with a date column in customized Asset Register report in Oracle FusionHi, We customized the Fixed Assets "Asset Register" report. There's a date column whose logic is as below. (SELECTTO_DATE(TO_CHAR(fcp.end_date, 'MM-DD-YYYY'), 'MM-DD-YYY…
-
URGENT: Asset Cost Balances Custom Report: Tables and Columns requiredSummary: Custom Asset Cost Balances Report (Summary) Content (required): Hi We are building a custom "Cost Summary Report" with the full combination for asset cost accou…
-
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…
-
We want to update the closed FA period name in cloud. Please suggest the possibilities.Summary: We want to update the closed FA period name in cloud. Wrong naming convention of the asset calendar period is causing some reporting issues so we would like to …PrudhviGajula 33 views 5 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets