Oracle API Table Definitions Fixed Assets

Posted on October 20th, 2007 by Sanjit Anand | Print This Post | Email This Post

Here is reference note for API table definitions based out of my for previous article for Oracle API Availability -Oracle Assets (FA).

FA_ACE_BOOKS

FA_ACE_BOOKS, the ACE conversion table, is organized into the following columns which store ACE information:

 

FA_BUDGET_INTERFACE

FA_BUDGET_INTERFACE, the budget interface table, is organized into columns in which Oracle Assets stores budget information.

FA_INV_INTERFACE

To use the Physical Inventory feature in Oracle Assets, you must load physical inventory data that you have collected into the FA_INV_INTERFACE table in Oracle Assets.

FA_PRODUCTION_INTERFACE

FA_PRODUCTION_INTERFACE, the production interface table, is organized into columns in which Oracle Assets stores production information. Enter values for the following required columns

Name Null? Type
ASSET_NUMBER NOT NULL VARCHAR2(30)
PRODUCTION NOT NULL NUMBER
START_DATE NOT NULL DATE
END_DATE NOT NULL DATE

1. Oracle Fixed Assets Process Overview
2. Oracle API Availability -Purchasing
3. ABC: An Introduction to Asset Books in Oracle Fixed Asset
4. Oracle API Availability – Oracle Receivables (AR)
5. Oracle API Availability -Oracle General Ledger (GL)