Lines Stuck in Awaiting Export Screening Due to ITM 500 Internal Server Error Raised (Doc ID 1677537.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Intl Trade Mgmt Integration

Order lines are not being processed in (ITM)International Trade Management.  Lines are stuck at workflow AWAITING EXPORT SCREENING. The following errors can be seen in ITM log file:


ERROR
-----------------------

48785858 Worker3 (WARN) Error in Adapter.handleOAGAcknowledgment() String index out of range: -1
52392530 Worker0 (WARN) Response XML document is unavailable
201062726 Worker0 (INFO) Error in Adapter.callCustomProcedure : java.sql.SQLException: ORA-53203: security violation
HTML>500 Internal Server Error

Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

193023181 Worker2 (INFO) Error in Adapter.callCustomProcedure : java.sql.SQLException: ORA-53203: security violation
ORA-06512: at "SYS.UTL_FILE", line 77
ORA-06512: at "SYS.UTL_FILE", line 690
ORA-06512: at "APPS.WSH_ITM_POST_PROCESS_HANDLER", line 257
ORA-53203: security violation
ORA-06512: at line 1 

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Enter and Book new order

3. Workflow progresses order to Export Screening step. An xml file is sent to the third party export screener.
4. During this process, the error messages are displayed.

Cause

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 hundreds of Community platforms