Invalid Alternate Bill/Routing When Updating non Standard Jobs Through WIP Mass Upload (Doc ID 2157336.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

When updating a non standard discrete job, following error happens.

ERROR

Alternate Routing is invalid. Choose a routing that exists for this assembly or routing reference.
Alternate Bill is invalid. Choose a bill that exists for this assembly or bill reference.


EXPECTED BEHAVIOR

No error happens on WIP Mass Upload


STEPS

The issue can be reproduced at will with the following steps:
1. Insert into wip_job_schedule_interface
    - To update non standard job which has assembly item, but it has no routing/bill.
    - Leave alternate_bom_designator/alternate_routing_designator null

2. Run WIP Mass Upload Program



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