Inquiry & Reporting
Discussion List
-
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… -
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… -
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 31 views 5 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Accounting Journal Entries Generated When Doing A Revaluation In Fixed Assets ?Summary Accounting Journal Entries Generated When Doing A Revaluation In Fixed Assets ?Content Hello I have read the following note : How Are The Accounting Journal Entr…
-
Privilege or Duty role to run any Custom or seeded ESS JobSummary: Privilege or Duty role to run/submit any Custom or seeded ESS Job. I am aware it is present in Application Implementation Consultant Role. Content (please ensur…V P Aravind 273 views 3 comments 0 points Most recent by alexey.shtrakhov Fusion Applications Administration
-
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…
-
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… -
Expenditure Type at Source Lines from ORACLE PROJECTSSummary: For some source Lines the Expenditure Type is missing, for SOURCE=ORACLE PROJECTS Content (please ensure you mask any confidential information): at Projects, we…
-
What is the data retention period for FA_MASS_ADDITIONS? Does the data get auto-purged?Summary: What is the data retention period for FA_MASS_ADDITIONS? Does the data get auto-purged? Content (please ensure you mask any confidential information): Version (…
-
Need sql query to join between subledger and fixed asset and asset invoicesSummary: We are pulling the general and sub-ledgers for fixed assets and asset invoices in order to create a custom BI report for fixed asset reconciliation. Since we ar…
-
Procurement > Purchasing infolet to show count for all users not just for the current userSummary: How to make the infolet counts for Orders Pending Acknowledgment ; Requisition Lines ; Orders Requiring Attention and Incomplete show numbers for all users incl…
-
Asset Transaction Flexfield does not show at Asset Impairment screen or spreadsheetHi, I would like to enable flexfield to show at the asset impairment screen and excel spreadsheet. But when I enabled flexfield at Asset Transactions level as below, The…
-
'Asset Summary Report Germany' in Oracle Fusion.Summary: We had a report 'Asset Summary Report Germany' in EBS Release 12, this report is providing us the information required for Statutory/Audit reporting. We would l…
-
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' …
-
Asset addtions reportHi, Running the asset additions report we only get the new asset additions, where the source-lines from AP added to existing assets are handled as adjustments and theref…Tim Jespersson-Oracle 1 view 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
💡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… -
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…
-
Asset workbench activity details before PostSummary: I would like to know the details of actions taken on asset workbench after mass addition ( Merge, Add to Asset, Split etc) before the post them. This helps busi…
-
Issues with customizing Journal Entry Reserve Ledger Report / ESS JobSummary: Issues with customizing Journal Entry Reserve Ledger Report / ESS Job Content (please ensure you mask any confidential information): We are encountering report …
-
what report displays the feeder system name?Summary: hI, what report displays the FEEDER_SYSTEM_NAME? which is the Source colum at the Source Lines tab, per screenshot: example feeder system name= ORACLE FBDI or O…
-
How to reconcile expense valuation type transactions against asset specific natural account?This is to share a critical case for seeking technical guidance regarding the reconciliation process of expense-related stock valuation records with trial balance report…