Syed Saad Ali
Syed Saad Ali
Fixed Assets
August 1, 2017
Oracle Assets Profile Options
Configurations-FAFixed AssetsOracle Functional
Oracle Assets Profile Options
Below are the most common profile options used in Oracle Asset Module.
August 1, 2017
Oracle financials interface tables
Accounts PayablesAccounts ReceivablesAPPS DBAConfigurations-APConfigurations-ARConfigurations-CMConfigurations-FAConfigurations-GLFixed AssetsGeneral LedgerInstallations/Configurations-ApplicationsOracle FunctionalScripts
General Ledger Interface Tables
- GL_BUDGET_INTERFACE
- GL_DAILY_RATES_INTERFACE
- GL_DRM_HIERARCHY_INTERFACE
- GL_DRM_SEGVALUES_INTERFACE
- GL_IMP_COA_ERR_INTERFACE
- GL_IMP_COA_NORM_HIER_INTERFACE
- GL_IMP_COA_SEG_VAL_INTERFACE
- GL_IEA_INTERFACE
- GL_INTERFACE
- GL_INTERFACE_CONTROL
- GL_INTERFACE_HISTORY
- GL_REPORT_INTERFACE
- GL_XFR_INTERFACE
Account Payables (AP) Interface Tables
- AP_INTERFACE_CONTROLS
- AP_INTERFACE_REJECTIONS
- AP_INVOICE_INTERFACE
- AP_INVOICE_LINES_INTERFACE
- OIE_POL_RATES_INTERFACE
Account Receivables (AR) Interface Tables
- AR_PAYMENTS_INTERFACE_ALL
- AR_TAX_INTERFACE
- HZ_PARTY_INTERFACE
- HZ_PARTY_INTERFACE_ERRORS
- RA_CUSTOMERS_INTERFACE_ALL
- RE_INTERFACE_DISTRIBUTION_ALL
- RA_INTERFACE_ERRORS_ALL
- RA_INTERFACE_LINES_ALL
- RA_INTERFACE_SALESCREDITS_ALL
- AR_INTERFACE_CONTS_ALL
- AR_PMTS_INTERFACE_HEADER_GT
- AR_PMTS_INTERFACE_LINES_GT
- AR_PMTS_INTERFACE_LINE_DETAILS
- HZ_DQM_SH_SYNC_INTERFACE
- HZ_DQM_SYNC_INTERFACE
- RA_INTERFACE_REQID_GT
Fixed Assets (FA) Interface Tables
- FA_BUDGET_INTERFACE
- FA_INV_INTERFACE
- FA_PRODUCTION_INTERFACE
- FA_TAX_INTERFACE
- FA_TRANSACTION_INTERFACE
Cash Management (CE) Interface Tables
- CE_ARCH_INTERFACE_HEADERS
- CE_ARCH_INTERFACE_HEADERS_ALL
- CE_ARCH_INTERFACE_LINES
- CE_HEADER_INTERFACE_ERRORS
- CE_LINE_INTERFACE_ERRORS
- CE_STATEMENT_LINES_INTERFACE
- CE_UK_VALIDATIONS_INTERFACE
July 1, 2017
descriptive flexfield with application name iAssets (IA) and name IA Request Headers (IA_REQUEST_HEADERS) is not frozen
Errors/Workarounds-FAFixed AssetsOracle Functional
ERROR
The descriptive flexfield with application name iAssets (IA) and name IA Request Headers (IA_REQUEST_HEADERS) is not frozen. Please contact your system administrator.
July 1, 2017
How to Setup Asset Impairments in Oracle R12
Configurations-FAFixed AssetsOracle Functional
How to Setup Asset Impairments in Oracle R12
Step 1. Setup Cash Generating Unit (CGU):
- Navigate to Assets responsibility: (N) Setup > Asset System > Cash Generating Units
- Define or maintain Cash Generating Units for each book that needs Impairment functionality.
Step 2. Assign Cash Generating Units to Assets:
There are two possibilities to assign Cash Generating Units:
A. Manually via Asset Workbench:
- Navigate to Assets responsibility: (N) Assets > Asset Workbench
- Query for the existing assets that needs to be assigned to Cash Generating Units.
- Press “Books” and select from LOV the book name.
- Go to Impairment tab and use the LOV from the Cash Generating Unit field to assign or change CGU assignment.
B. By mass assignment via WEB ADI:
- Navigate to Assets responsibility: (N) Assets > Impairment > Assign Cash Generating Units.
- Enter Book, Asset Number and CGU.
- From the main toolbar go Oracle > Upload for uploading the assignment information to the assets.
Step 3. Setup Impairment Accounts:
Setup Impairment Expense account and Accumulated Impairment account in the Asset Categories form.
- Navigate to Assets responsibility: (N) Setup > Asset System > Asset Categories
- Query for Asset Categories and Books.
- Enter the accounting information for Impairment Expense account and Accumulated Impairment.