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 947081.1)

Last updated on NOVEMBER 21, 2016

Applies to:

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

Symptoms

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

ERROR

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

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

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

**Starts**02-OCT-2009 10:43:04
**Ends**02-OCT-2009 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 To Reproduce:
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