My Oracle Support Banner

Shipping Purge Completes With Error (Doc ID 2433505.1)

Last updated on AUGUST 09, 2018

Applies to:

Oracle Shipping Execution - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Open Interfaces & Public APIs

Executing Concurrent Process WSH Module purge completes with Error.
  
ERROR
-----------------------
Error occurred in WSH_PURGE.GET_PURGE_SET

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect to Applications using an Order Management or Shipping Responsibility
2. Execute the Interface Shipping Purge Concurrent process
3. Process fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the Shipping purge process cannot be executed,
old transactions cannot be removed from the system to improve the performance.

Changes

The current DB Parameters are set as recommended in the documentation (Limit is 2x Target)

SELECT name, value
FROM v$parameter
WHERE name like 'pga%';

NAME VALUE
pga_aggregate_limit 6442450944
pga_aggregate_target 3221225472

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.