Distribution - JDE1 (MOSC)

MOSC Banner

Considerations for changing Primary Location via SQL

edited Feb 21, 2014 12:00PM in Distribution - JDE1 (MOSC) 2 commentsAnswered

We have a large number of items that are included on open purchase orders.  Since we import from overseas, our POs typically stay open for months.

We are making some big changes to our warehouse, so next week we will need to change the Primary designation on a large number of items.  Management is determined to do this using SQL, since it cannot be done in the software (because of the open POs).  I would like to know how foolish this is.  Is it just a matter of making the change to PBIN in the F41021?  Are there other considerations?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center