1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12-FA Changes and Tables

Discussion in 'Oracle Apps Technical' started by Ramji, Feb 7, 2012.

  1. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Fixed Assets

    New Tables

    Table Name

    Feature Area

    Brief Description

    CSI_FA_HEADERS

    Notification Process for newly added assets.

    This table captures asset related information about Fixed assets that are manually added using the Assets Workbench – The generated data is then used in the Generate Notification concurrent process.

    CSI_FA_TRANSACTIONS

    Notification Process for newly added assets.

    This table captures transactional information about Fixed assets that are manually added using the Assets Workbench – The generated data is then used in the Generate Notification concurrent process.

    CSI_I_ASSET_INTERFACE

    Open Interface for Instance to Fixed Asset Association

    This table if loaded with the instance and asset link information will be used by the “Install Base Open Interface” program to create the association between the item instance and the fixed asset.

    Changed Tables

    Table Name

    Feature Area

    Brief Description of Change

    CSI_I_ASSETS

    Improved Integration with Fixed Assets/Common Asset Repository

    Added NEW Columns

    · FA_SYNC_FLAG – This tracks whether the Fixed Assets and Item Instances are in sync with respect to quantities and Location Mapping.

    · FA_MASS_ADDITION_ID – This is the new linking column that stores the information about the record that is written in to FA_MASS_ADDITIONS table when the Asset Tracking concurrent program creates the interface data to create a fixed asset.

    · CREATION_COMPLETE_FLAG – Column that determines whether the instance to asset link is complete or not.

    CSI_INSTANCE_INTERFACE

    Install Base Open Interface

    · Added Asset Maintenance (EAM) support columns

    · Added instance attributes from 16 to 30

    · Added operational status code column

    · Added Sync up family column for internal processing.

    Obsolete Tables

    Table Name

    Feature Area

    Optional - Replaced By

    CSI_I_ASSET_TXN_TEMP

    Improved Integration with Fixed Asset

    This table was used to temporarily hold data before creating assets in FA. Primarily used for grouping purpose. The grouping logic is now handled in the code.

    iReceivables

    New Tables

    Table Name

    Feature Area

    AR_IREC_SELFREG_CUST_QS

    Self Registration

    AR_IREC_SELFREG_SITE_QS

    Self Registration

    ARI_REG_VERIFICATIONS_GT

    Self Registration

    AR_IREC_PRINT_REQUESTS

    Print Request

    Changed Tables

    Table Name

    Feature Area

    Brief Description of Change

    AR_SYSTEM_PARAMETERS_ALL

    System Options Setup, the Receivables Activity type used for Convenience Charges.

    Added column column IREC_SERVICE_CHARGE_REC_TRX_ID NUMBER(15)

    Obsolete Tables

    Table Name

    Feature Area

    Optional - Replaced By

    AR_CUST_SEARCH_GT

    Customer Search

    AR_CUST_SEARCH_GT_ALL

    AR_IREC_CUSTOM_CUST_GT

    Custom Customer Search

    AR_IREC_CSTM_CUST_GT_ALL

    AR_IREC_CUSTOM_SRCH_GT

    Custom Transaction Search

    AR_IREC_CSTM_SRCH_GT_ALL

    AR_IREC_PAYMENT_LIST_GT

    Transaction List/Payment Page

    AR_IREC_PAYMENT_GT_ALL

    HZ_REGISTRATIONS

    Self Registration

    HZ_REG_VERIFICATIONS

    Self Registration

    New Views

    View Name

    Feature Area

    ARI_CUSTOMER_SEARCH_V

    Customer search for internal users

    Changed Views

    N/A

    Obsolete Views

    N/A

    iExpenses

    New Tables

    Table Name

    Feature Area

    Brief Description

    OIE_PDM_DAILY_BREAKUPS

    Enhanced Global Per Diem and Mileage

    This table holds per diem data for a rate period.

    OIE_PDM_DESTINATIONS

    This table holds per diem destination information.

    OIE_ADDON_MILEAGE_RATES

    This table stores additional information for a mileage expense type.

    OIE_POL_RATES_INTERFACE

    Staging table for uploading CONUS and OCONUS rates.

    OIE_ALLOCATION_PREFS

    Expense Allocations

    This table stores a person's allocation preferences.

    OIE_DISTRIBUTION_SETS

    This table stores distribution sets that make up an allocation preference.

    OIE_SET_DISTRIBUTIONS

    This table holds the distribution lines that belong to a distribution set.

    OIE_AME_NOTIFY_GT

    Data in OIE_AME_NOTIF_GT will be used for displaying instructions to the approver in the approval notification. Example, You are responsible for approving expenses that total 250.00 USD for cost center 420.

    OIE_AME_APPROVER_AMT_GT

    Data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver Amount in the approval notification.
     
    Bharat likes this.