Son of discrete pieces of work resulted in a single stock is negative
BOM in the definition of recent users, we had pieces of the parent / child ratio of 1:1 parts consumption may be due to user error, the results of the parent items / sub-items for the consumption of more than 1:1000, single work in the completion of discrete sub-pieces lead to a negative value.
Measures: Move Transaction Form the job done for the return interface operation, which used to solve the problem of negative inventory. BOM table and then modify the new discrete work orders, re-completion of work order
Analysis: why in the analysis until the parameters of the Organization "Allow negative Stock" has not been checked, why such matters can lead to negative stock it?
Check information provided by: INV: Override Neg for Backflush for Yes
INV: Override Neg for Backflush
Indicates whether backflush transactions can drive the inventory negative even if the inventory organization parameter Allow Negative Balances is unchecked. Inventory predefines a value of Yes for this profile option upon installation. A value of No does not allow backflush transactions to drive on-hand inventory negative even when the inventory
organization parameter Allow Negative Balances is unchecked.
This profile is updateable at all levels.
Related Posts of Son of discrete pieces of work resulted in a single stock is negative
-
Oracle RMAN backup of the physical meaning of RMAN configuration
Rman details below to talk about the meaning of the configuration: rn 1, Configuring the Default Device Type for Backups: configure the default backup device rn Rman default default disk backup device for disk, also can be configured as other media s ...
-
Detailed rules Optimize Oracle statement
1. The types of Oracle Optimizer Oracle's Optimizer total of three kinds: a.RULE (rule-based) b.COST (based on cost) c.CHOOSE (optional) Optimize the default settings, you can file through the init.ora parameters OPTIMIZER_MODE various statements ...
-
Oracle Database Exp / Imp tools for performance tuning
Abstract: Oracle Exp / Imp instrument is a simple, convenient and flexible backup and restore data transfer tool, it can implement the entire class library, user-level, table-class data backup and recovery. For the amount of data in class G or G with ...
-
Detailed: database name. Instance name. ORACLE_SID. Database name
Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some
-
oracle pl / sql examples of practice
The first part: oracle pl / sql examples of practice (1) First, use the scott / tiger user under the emp table and dept table finish the following exercises, the structure described below emp employee table (empno number of staff / ename employee nam ...
-
Database tuning problem (parameter binding, Histogram Analysis)
1, histogram Analysis of depth. . 20080901 ~ 20060101 ~ 99991231 2, the binding parameters The use of different parameters of the different analysis. . . The use of index Scanning the entire table is slightly
-
setting to discuss filing oracle10g
Oracle Database 10g Enterprise Edition Release 10.2.0 .4.0 - Prod PL / SQL Release 10.2.0 .4.0 - Production IXDBA.NET Community Forums CORE 10.2.0 .4.0 Production TNS for Solaris: Version 10.2.0 .4.0 - Production NLSRTL Version 10.2.0 .4.0 - Producti ...
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply