Wednesday, June 12, 2013

How to Purge Sale Order Records in Order Management

Details

Purging old data creates space in your database and can improve performance of transactions and maintenance. Please check with your planner in regards to how much sales order history is needed for forecasting within your Company, before setting this up.

The Purge Orders concurrent program enables you to purge selected closed orders and their workflow history. You first determine which orders you wish to purge by creating a Purge Set. Once orders have been selected for purging within a purge set, you can then choose to purge the entire set, a subset of the Purge set, or to cancel the purge. Details for how to set this up are outlined below.

Purge Restrictions

Orders can only be purged if they meet the following conditions:
  • Orders must be closed.
  • No open demand exist for orders, open work orders, open invoices, open returns, and open requisitions.
Order Tables Purged by Order Purge Concurrent Program
The following Order Management tables are purged of selected order data,
dependent upon the input parameters and a successful submission of the Order
Purge concurrent program.
  1. OE_HOLD_RELEASES
  2. OE_HOLD_SOURCES
  3. OE_LINE_SETS
  4. OE_LOT_SERIAL_NUMBERS
  5. OE_ORDER_HEADERS_ALL
  6. OE_ORDER_HOLDS
  7. OE_ORDER_LINES_ALL
  8. OE_PRICE_ADJ_ATTRIBS
  9. OE_PRICE_ADJ_ASSOCS
  10. OE_PRICE_ADJUSTMENTS
  11. OE_SETS
  12. OE_SALES_CREDITS
  13. Additionally, Oracle Foundations (FND) tables will be purged of any attachments for orders selected for purging by the Order Purge concurrent program.

Purge Set Creation

A purge set is a set which will contain orders to be purged based upon user specified criteria. Purge set can be created in the two following ways: 

  • Purge Set Creation using the Create Purge Set Concurrent Program
  • Multi-selection of orders within the Order Organizer window and then invoking the Create Purge Set Concurrent Program from the Tools Menu. Purge Set Creation using the Create Purge Set Concurrent Program

To create a purge set by specifying the where (selection) condition:

1. Navigate to the Order Purge Selection concurrent Program
OM > Orders, Returns > Purge > Order Purge Selection
2. Within the Purge Set name field, enter a unique name to identify the purge set.
3. Within the Purge Set Description, enter a description for your purge set.
4. Optionally, determine if you wish to purge a single order number or range of order numbers, by entering values for Order Number Low, Order Number High, or both input parameters. All orders created within the range entered will be selected for purging, provided other input parameters also enable purging.
5. Optionally, determine if you wish to purge orders for a specific Order Type by selecting a value in the Order Type input parameter. All orders created that utilize the Order Type selected will be purged, provided other input parameters also enable purging.
6. Optionally, determine if you wish to purge orders for a specific Order category by selecting a value in the Order Category input parameter. All orders created that utilize the Order Category selected will be purged, provided other input parameters also enable purging.
7. Optionally, determine if you wish to purge orders for a specific Customer Name by selecting a Customer Name in the Customer Name input parameter, provided other input parameters also enable purging.
8. Optionally, determine if you wish to purge orders created on a specific date or range of dates by selecting a value for the Creation Date Low, the Creation Date Order Purge / Order Purge Selection Concurrent Programs High, or both input parameters. All orders created for the date range specified are selected within the purge set, irrespective of the current order status.
9. Click Submit.












Purge Set Creation by multi-selection


Create a purge set by selecting multi-selecting orders within the Order Organizer, and then, from the menu, selecting Tools, Purge, Purge Set.
1. Enter the Purge Set name and a description for the purge set.
2. Click Submit to create a purge set with all the records (orders) you have selected within the Order Organizer.

To Submit the purge Request

Navigate to the Order Purge window
OM > Orders, Returns > Purge > Purge Set
Query by Purge Set name.
Purge sets can be submitted for purge, exclude certain orders within the set from being purged, or
completely deleted (provided the records have been previously purged).



















To View Process Exceptions
If the selection criteria includes orders that do not meet the purge restrictions (order is not closed, outstanding reservations exist, etc.) or if the purge process encounters an issue, a process error occurs. These errors can be viewed by viewing the purge set within the Order Purge window. Navigate to the Order Purge window is:
OM > Orders, Returns > Purge > Purge Set

For example, suppose when submitting the Order Purge Selection concurrent program a user specified all orders for customer Business World. When you navigate to the Order Purge window, you may find certain orders were ineligible for purge, and have been marked as such (within error column, a note would display the order is not closed, and the Purge Eligible check box is not enabled).

7 comments:

  1. Anonymous5:00:00 AM

    Please allow me to share some background and insight into the magic of HOLLYWOOD CLASSICAL CINEMA and then tie in how that
    approach to meeting audience expectations could have a
    positive impact on your bottom line. Like writing articles, practice in this discipline
    is essential, and this should be conveyed
    in your content. If you can qualify for insurance licensing, you
    can learn these marketing techniques too.

    My web page ... online marketing assistant job descriptions ()

    ReplyDelete
  2. Anonymous6:10:00 PM

    A fascinating discussion is worth comment. There's no doubt that that you need to publish more on this topic, it
    might not be a taboo matter but typically people do not speak about these issues.
    To the next! All the best!!

    my homepage; Dirk Craen

    ReplyDelete
  3. Anonymous11:04:00 PM

    What's up, after reading this amazing paragraph i am as
    well cheerful to share my familiarity here
    with mates.

    Visait my web page maternity swimwear by bra size

    ReplyDelete
  4. Anonymous11:50:00 AM

    (1) Remodeling can be a great way to transform a home from
    functional to a showcase of personality and lifestyle. - Immediate access to a gorgeous
    deck or patio outdoors also adds to the return. Your kitchen should be able
    to accommodate the stock of your monthly groceries
    with ease.

    my website - Pine Returned End

    ReplyDelete
  5. Anonymous10:25:00 PM

    obviously like your web-site but you have to test the spelling on quite a few of your posts.
    Several of them are rife with spelling issues and I find it very
    troublesome to inform the reality on the other hand I'll surely come again again.

    Also visit my web-site - jailbreak iphone ios 8

    ReplyDelete
  6. Anonymous12:52:00 PM

    Considerable planning will keep the sales drive flowing and
    your income. Whether it be calming, exciting, vintage, or modern, it should give the room a certain aura that is consistent with
    what the designer initially intended. You should only email
    about your sites, its updates, available goods and latest articles to individuals those people who are interested in the topic of your site.


    Feel free to visit my web site: bisdistributor mukena,distributor mukena katun jepang anaqu,distributor mukena anak karakternis 2017 - -

    ReplyDelete
  7. Anonymous3:16:00 PM

    It would be best if your teen can try on the clothes first so they know just how well or how poorly they fit the
    body. The way teenagers wear their clothes has been an ongoing
    issue for many decades, especially when so many people have their opinions on what looks good.

    This has made clothing the most populated category on e - Bay.


    Review my page mukena katun jepang murah,distributor mukena anak karakter murah,distributor mukena anak

    ReplyDelete






Please provide your valuable feedback ............