Oracle Transportation Management (MOSC)

MOSC Banner

SQL Script to delete disabled organizations from shipping network lines

edited Sep 6, 2017 2:56AM in Oracle Transportation Management (MOSC) 1 commentAnswered

We have lots of shipping network defined for one organizations. These shipping networks are attached to account segments for code combinations.

For last few years, lot of these organizations are closed and subsequently , there accounting valueset is disabled.

The normal process would be to delete lines in form "shipping network" when a store/Organization is closed / shut down.
We have not done this over the years, so we have issues in this form when searching for the setup for an inventory

Navigation   -->

Go to Shipping networks (Setup / Organizations / Shipping Networks)
Hit button FIND

Now you will get an error message for each line where the store is closed.

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