R12 FA AND AR

R12 FA AND AR

R12 FA I AR

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.