Cannot Set 7 DECIMAL for WIP_JOB_DTLS_INTERFACE.QUANTITY_PER_ASSEMBLY

(Doc ID 2381246.1)

Last updated on APRIL 09, 2018

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
When set 7 decimal places (ex: .0000003 ) for WIP_JOB_DTLS_INTERFACE.quantity_per_assembly then run WIP Mass Load, it occurs following error:

Error
Component yield must be greater than 0.

Steps to Reproduce

  1. Create JOB as Start Qty:3600 and a Component Material Requirement:
        Per Assembly:1
        Yield:1
        Required: 3600
  2.  Create WIP_JOB_DTLS_INTERFACE for update Material Requirement as follows:
             QUANTITY_PER_ASSEMBLY : .0000003
              REQUIRED_QUANTITY      : .00108
              Yield                              : Null
  3. Run WIP mass Load
  4. WIP Mass Load was completed as Warning with the error message and the target WIP_JOB_DTLS_INTERFACE is not processed.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms