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