Collect Shipment And Booking History - ORA-29273: HTTP request failed , ORA-06512: at "SYS.UTL_HTTP" line 1577 ORA-12541: TNS:no listener (Doc ID 1944142.1)

Last updated on APRIL 30, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to Collect Shipment and Booking History the following error occurs:


MSDDEMCHD module: Collect Shipment and Booking History
+---------------------------------------------------------------------------+

Current system time is 02-OCT-2014 10:43:04

+---------------------------------------------------------------------------+

**Starts**02-OCT-2014 10:43:04
**Ends**02-OCT-2014 10:43:06
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-12541: TNS:no listener
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Collect History Data - Actions

Date From (DD/MM/RRRR) - 01/01/1000
Date To (DD/MM/RRRR) - 31/12/4000
Deleting data from sales staging table - T_SRC_SALES_TMPL
Begin Delete data from ERR table - T_SRC_SALES_TMPL_err
Analyzing Table - T_SRC_SALES_TMPL
For the selected series, the old data will be purged from '03-JAN-00' to '25-DEC-00'
Warning: can not purge old shipment/booking history data.


Steps :
The issue can be reproduced at will with the following steps:
1. run Shipment and Booking History collection

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