Upload Production

Tags:
fa3Remove my vote on this tag create new tag

Table of Contents

Transaction Description

If production quantities are available from another system, you can upload the information using the production interface. The interface table is named FA_PRODUCTION_INTERFACE. The batch job is submitted as a concurrent request named Upload Production. The only parameter is the book. The Production History report shows the status of imported items. Since maintenance is performed manually using the Periodic Production window, take care to make sure the data is prepared correctly.

The columns of the FA_PRODUCTION_INTERFACE table that you must populate (use SQL*Loader) are ...

  • Asset_number - an alphanumeric column representing the unique asset
  • Production - a numeric column representing the production amount
  • Start_date - first date for which the production quantity applies
  • End_date - last date for which the production quantity applies
note The unit of measure and the book are not part of this interface.

Request Details

Screen Shot

  • Name
  • Operating Unit
  • Parameters
  • Language

Parameters

List of Fields

  • Book





Comments

 

Links

This Topic Is Referenced By These Topics:
Related Links: FA12ProductionEnter



Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.
Choice
leftbarmainbarrightbar Somewhat Useful (1)

Collaborating Authors and Reviewers: -- DianeMcHugh, JimCrum

Topic revision: r4 - 22 Jan 2009 - 22:42:17 - JimCrum
 
This site is powered by the TWiki collaboration platformCopyright © 2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Permission to copy, distribute and/or modify is granted for this document under the GNU Free Documentation License.
Ideas, requests, problems regarding WikiOraApps? Send feedback