Apply patch if EP_LOAD_SALES Does Not Compile - or Errors in EP_LOAD_MAIN 731*

(Doc ID 1507516.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

On : 7.3.1.3 version, Load Data procedures

We have recently upgrade demantra to 7.3.1.3, and now ep_load_sales ( $Revision: 1.129.2.4.4.25.2.1 $) has compilation errors :
We are using the procedure as part of the collection program, and it fails because of these errors:
  Error: PL/SQL: ORA-00913: too many values Line: 338 Text: INSERT INTO T_SRC_SALES_TMPL_TMP (Error: PL/SQL: ORA-00947: not enough values Line: 369 Text: INSERT INTO T_SRC_SALES_TMPL_ERR

At our recommendation, applied patch 13916833 on PEMCRP . BugDB #13916833 - PERFORMANCE EP_LOAD_SALES PERFORMANCE
  After patch application the table T_SRC_SALES_TMPL_TMP did have the missing two columns, and ep_load_sales compiles with no errors.
  Also run EXEC CALL_DATA_MODEL , as advised in readme.

Error 1.
---------
Text: INSERT INTO T_SRC_SALES_TMPL_ERR
looking into it I see that the select select 2 coluns more than the table T_SRC_SALES_TMPL_TMP has . COMPONENT_CODE_LEGACY  '6'

Error2,
after recommended patch and run exec.call data_model.
-----------------------------------------------------
Now when we try to run the collections we get another error :
14-OCT-2012 14:45:15 Error in Main - ORA-20002: -20003 ORA-20003: Error in PROCEDURE EP_LOAD_MAIN line 22 executing ACTIVE_PROC_DYN('ep_check_location('A')') -20002 +-----------
and the procedure ep_load_locations does not compile.
Compilation errors for PROCEDURE MSDEM.EP_LOAD_LOCATIONS
Error: PLS-00103: Encountered the symbol "T_EP_ORGANIZATION_NAME_EP_ID" when expecting one of the following:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 7203 to 7313 platform only, observed 2 columns are missing in sales staging table
  - - Error1
  -- http://myforums.oracle.com/jive3/message.jspa?messageID=6290989&tstart=0

2. Applied recommended patch 7.3.1 5 7310041 14/10/2012 11:50:55
  BugDB #13916833 - PERFORMANCE EP_LOAD_SALES PERFORMANCE

3. Run as advised EXEC CALL_DATA_MODEL after patch - Error 2 appeared


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