How to create Fixed Assets in Oracle EBS?

This may be the propose template fro creating Fixed Assets in Oracle EBS Module. However, it may vary from company to company OR process to process.

Fixed Asstes in Oracle EBS

Activities	Oracle module	Prerequisite	Input	System processing	Output	Accounting	Generic business rule
Tag invoice distributions to Asset account & Asset Book  in Payables	Payables	Payables invoice is entered	Track as an Asset check box enabled in the  invoice distribution lines that are to be accounted  asset	Flags the invoice lines and distributions to be transferred to Assets Module	Entered Payables invoice with information for transfer to Assets	None	Only invoice distribution that needs to be capitalized in Assets module is  automatically tagged by enabling the check box for field track as an asset flag for  the relevant distribution lines having natural account segment of type asset
Invoice Accounted & transferred to GL	Payables	Payables invoice is validated	Payables invoice is validated	Creating accounting process is completed without error	Invoice accounted & transferred to GL	Asset Clearing A/c Dr    To Liability	Invoice accounting lines which are transferred to GL will be eligible for Mass additions create program
Import Invoice Distributions in FA	Payables	Invoice distribution is accounted, track as an asset check box is enabled	Invoice Accounted or Asset Clearing account & Track as Asset Check Box enabled	Imports all the relevant Invoice distribution lines into FA Mass Additions Table	Asset invoice distributions imported	None	Invoice accounting lines which are transferred to GL will be eligible for Mass additions create program
Add Asset Capitalization details in Assets Module	Assets	Asset Invoice distributions imported into FA Mass Additions Table	Asset details  such categories, date placed in service, location & depreciation details	Tagging of an asset to a category, location, employee & DPIS	Asset Invoice distributions tagged to category, location, asset key, employee & DPIS	None	None
Review assets to be capitalized	Assets	Asset details are entered	Mass Additions Report Request	Execution of the report request	Mass Addition Report Output  for assets to be capitalized	None	None
Capitalize Assets	Assets	Full Asset details are entered and no more changes required. No invoice distribution for the current period in Unposted Mass Additions Report	Asset Creation Program	Creation of Assets	Asset number generated in the system	Asset Cost A/c Dr   To Asset Clearing	Accounting for asset creation would be generated when Create Accounting Process is run which is shown as a part of Assets Depreciation Process
Review asset addition report	Assets	Assets Creation program is completed	Report parameters for Asset Additions Report, Additions by period report	Execution of a verification report	Asset Additions Report & Additions by period report	None	None

Bank Reconciliation process design for ERP

This process may give an overview to solve Bank Reconciliation in ERP environment. However, Process may vary from enterprise to enterprise.

Activities	Prerequisite	Input	System processing	Output	Accounting	Generic business rule
Upload a bank statement	The bank, bank branch, bank account & bank trx codes should have been defined.	Soft copy of the bank statement	Records the bank statement details. Bank statements in Prescribed format will be uploaded	Bank statement created in Cash Management module.	None	None
Run auto reconciliation process	Bank statement should have been imported / entered manually in the Cash Management module.	Trigger the auto reconciliation process by providing the mandatory parameters	Automatically reconciles the Payables / Receivables transactions  with the corresponding statement lines based on the transaction number.	Bank statement reconciled with Payables / Receivables transactions.	None	None
Review unreconciled items	Auto-reconciliation process should have been completed	The Auto reconciliation execution report provides details of transactions which have not been reconciled in the auto reconciliation process.	None	The unreconciled transactions have been  identified & reviewed.	None	None
Manually Adjust / reconcile unreconciled items where required	Unreconciled transactions have been reviewed by the Finance Team.	Unreconciled transactions from the auto reconciliation execution report.	Transactions unreconciled during the auto reconciliation process will be manually reconciled.	Unreconciled transactions are reconciled.	None	Most of the transactions originating from Oracle System will get automatically reconciled, except transactions which are originating from the bank
Create Miscellaneous receipts for transactions originating from Bank	Transaction originating from the bank in bank statement	Miscellaneous Receipt creation	Enter receipt details with appropriate receivables activity to account for these transactions	Miscellaneous receipt created	Dr. Bank Charges             Cr. Bank Account	The following could account for Transactions originating from the Bank. Bank charges & Bank Interest
Generate GL reconciliation report	All statements in Cash Management should be reconciled, All entries from Payables / Receivables should have been transferred to General ledger.	Run the GL Reconciliation Report	Generates the GL Reconciliation Report	GL Reconciliation Report	None	The bank account should reconcile in GL and CM after posting to GL has been completed