Collect Shipment and Booking History Is Erroring Out ORA-00904: A.COMPONENT_CODE: invalid identifier (Doc ID 1468249.1)

Last updated on SEPTEMBER 05, 2012

Applies to:

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

Symptoms

Shipment & Booking History collection is failing due to ORA-00904: "A"."COMPONENT_CODE": invalid identifier


STEPS
--------
Run the shipment and booking history collection.

+---------------------------------------------------------------------------+
Demand Planning: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

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

Current system time is 06-JUN-2012 13:14:14

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

**Starts**06-JUN-2012 13:14:14
**Ends**06-JUN-2012 13:14:16
ORA-00904: "A"."COMPONENT_CODE": invalid identifier
+---------------------------------------------------------------------------+
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 - DEM.T_SRC_SALES_TMPL
Fetched the schema name as : DEM
Begin Delete data from ERR table - DEM.T_SRC_SALES_TMPL_err
Exception(1): msd_dem_collect_history_data.collect_series_data - 06-JUN-2012 13:14:16
ORA-00904: "A"."COMPONENT_CODE": invalid identifier
Error(17): msd_dem_collect_history_data.collect_history_data - 06-JUN-2012 13:14:16
Error while collecting Shipment History - Requested Items - Shipped Date
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
11652


Finished executing request completion options.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Collect Shipment and Booking History" has completed with error.

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