Removing a Ship Set From the Service Line Does Not Remove the Ship Set From Table OE_SET (Doc ID 3038112.1)

Last updated on AUGUST 05, 2024

Applies to:

Symptoms

Finds that the record is not removed from table OE_SETS when a ship set is removed from a service line / bill only line.
Expects the ship set to be deleted when it is last line where ship set was present.
If the ship set is removed from product line, then the record is properly removed from table OE_SETS

The issue can be reproduced at will with the following steps:

1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Enter or query order header
4. Click on line items tab
5. Place cursor on service line and add a ship set.
6. Save.
7. Run query
    select * from apps.oe_sets where header_id = &header_id;
    --1 record is shown
8. Then remove ship set for the service line
9. Run query and find record is not deleted from oe_sets table.
    select * from apps.oe_sets where header_id = &header_id;
    --1 record is still shown
10. Place cursor on product line and add a ship set
11. Save.
12. Run query and record is shown
13. Remove ship set from the product line
14. Run query and no records are shown.
     The record is deleted from oe_sets table.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.