- OracleApps Epicenter - http://www.oracleappshub.com -

Oracle API Table Definitions Fixed Assets

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

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

2 Comments (Open | Close)

2 Comments To "Oracle API Table Definitions Fixed Assets"

#1 Comment By Anil Reddy On November 26, 2007 @ 9:14 pm

Good info for customer conversion, if possible updt API that can be used in customer conversion.

#2 Comment By Arunasish Sircar On July 23, 2010 @ 11:57 am

Can you please let us have the same information for Oracle Financials R12 as quickly as you can?

Thanks

Arun