Inquiry & Reporting
Discussion List
-
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 561 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…
-
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
-
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…
-
Is it possible to create DFF in FA, that appear in Assets Inquiry page ?Summary: Is it possible to create DFF in FA, that appear in Assets Inquiry page, When you search any Asset in Assets inquiry page, we have the below fields called — Book…
-
how to Inquiry assets entered manuallySummary: Hi need to prepare a query to find the assets entered manually in Fixed Assets ? The Additions Report nor the Additions By Source Report reflects it was entered…maria.torres 31 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
how to execute Source Lines ReportSummary: is there a Source Lines Report under Fixed Assets ? Content (please ensure you mask any confidential information): Under Reports and Analytics it is not listed …
-
REST/SOAP Api to update fixed asset mass additions distribution unitsHi , In Fixed Asset Mass Addition I want to update the Units using REST/SOAP API the below Rest API is not allowing me update the same : fscmRestApi/resources/11.13.18.0…
-
MACRS Table Rates - Where did Oracle get the Table Rates from for Bonus Depreciation Methods?Summary: Where did Oracle get the tables rates for the seeded data population for Bonus Depreciation Methods in Document 2334665.1 for 40% and in Document 2860300.1 for …
-
View approval in fixed assetWe could not see the View approval buttons in the asset Inquiry > Transaction page as shown below in the white paper, do I need to assign any role or any missing configu…
-
How to remove record from adjustment infotile with error transaction- REQUEST ID NOT AVAILABLESummary: I tried to purge a transaction from the adjustment infotile which have "Error" Status but I could not gather the Request ID using the provided SQL REQUEST ID NO…
-
Assets Clearing Account to trasfer from AP to FASummary Assets Clearing Account to trasfer from AP to FAContent Hello : As far as I know this is the accounting to transfer assets from AP to FA AP Invoice Debit Asset C…gabriel kinovisques-163562 90 views 7 comments 0 points Most recent by Shyam Sundar Arunachalam Assets
-
How i make a custom role (transfer asset ) only for userSummary: i copied a role and remove priviladge but it didn't work or tell me which specific role i should take Can any one please help Content (please ensure you mask an…