Cannot Set 7 DECIMAL for WIP_JOB_DTLS_INTERFACE.QUANTITY_PER_ASSEMBLY
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.
When set 7 decimal places (ex: .0000003 ) for WIP_JOB_DTLS_INTERFACE.quantity_per_assembly then run WIP Mass Load, it occurs following error:
Component yield must be greater than 0.
Steps to Reproduce
- Create JOB as Start Qty:3600 and a Component Material Requirement:
- Create WIP_JOB_DTLS_INTERFACE for update Material Requirement as follows:
QUANTITY_PER_ASSEMBLY : .0000003
REQUIRED_QUANTITY : .00108
Yield : Null
- Run WIP mass Load
- WIP Mass Load was completed as Warning with the error message and the target WIP_JOB_DTLS_INTERFACE is not processed.
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