Previous  Next          Contents  Index  Navigation  Glossary  Library

Assigning Values to Required Columns in the FA_PRODUCTION_INTERFACE Table

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:

ASSET_NUMBER: Alphanumeric column. The asset number of the units of production asset for which you want to enter production.

PRODUCTION: Numeric column. The production amount for the asset between Start_Date and End_Date.

START_DATE: Date column. The first date to which this production amount applies.

END_DATE: Date column. The last date to which this production applies

See Also

Customize the Production Interface SQL*Loader Script

Uploading Production into Oracle Assets

Entering Production Amounts


         Previous  Next          Contents  Index  Navigation  Glossary  Library