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… -
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…
-
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…
-
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… -
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
-
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 …Alexandra Pickett 21 views 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…
-
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 32 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…
-
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… -
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…
-
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 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…
-
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…
-
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 21 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
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…