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, the ACE conversion table, is organized into the following columns which store ACE information:
FA_BUDGET_INTERFACE, the budget interface table, is organized into columns in which Oracle Assets stores budget information.
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, 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