Shipment Booking History error - 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 JUNE 21, 2023

Applies to:

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

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