Unable To Load ASCP Data Into Demantra Using Download Plan Scenario ODPM-70446: Failed to update combination

(Doc ID 1682973.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

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

Symptoms

Customer is running the download plan scenario data workflow, it is not loading the data into Demantra. There is data in both BIIO_Other_Data staging tables and also in both views, they can see the data


They are running it as

a. First create plan in ASCP and ensure that option "Use for Sales and Operations Planning" is enabled.
b. Login to Demantra Workflow Manager and launch workflow "Download Plan Scenarios".
c. Login to Collaborator workbench as sop/sop. On right side in "Dashboard Supply Review", right click ASCP Plan and click "Load Scenario Data"

They mention that the only thing they have done is before the end-to-end User testing, they used a package 'DATA_CLEANIP' to clean up data in Demantra. Along with Demantra, the source EBS instance was also cleaned. Since then they have only setup few items, customer, Inv-orgs in EBS, created Sales-Orders to collect into Demantra & ASCP.
Then created forecast for those items and published to ASCP, now we are trying to collect (Dependent Demand and Constrained Forecast) back from ASCP into Demantra but it errors out

Most of the following tables are empty



Checked the grants, access, ran the update synonyms.


The collaborator logs shows the following:

#######################################################
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: Import Data.
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: ODPM-20044: Run Start Time: 04-11-2014 10:05:05
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: ODPM-20045: Interface Name: Plan Data
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: ODPM-20046: Profile Name: Other Plan Data
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: ODPM-20052: Owner: sop
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: ODPM-20053: Profile From Date: 04-09-2012
2014-04-11 10:05:05,694 CDT WFProcess_196 INFO appserver.integration: ODPM-20054: Profile Until Date: 04-04-2016
2014-04-11 10:05:07,913 CDT Update_38 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-Q154059, Organization-E4T:ESI, Site-0, Demand Class-0, Sales Channel-0
2014-04-11 10:05:07,929 CDT Update_104 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-Q100501, Organization-E4T:WSI, Site-0, Demand Class-0, Sales Channel-0
2014-04-11 10:05:08,351 CDT Update_47 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-Q154059, Organization-E4T:WSI, Site-0, Demand Class-CLASS_C, Sales Channel-0
2014-04-11 10:05:08,351 CDT Update_46 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-Q196100B, Organization-E4T:WSI, Site-0, Demand Class-CLASS_C, Sales Channel-0
2014-04-11 10:05:08,366 CDT Update_69 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-201399A-10, Organization-E4T:WSI, Site-0, Demand Class-CLASS_C, Sales Channel-0
2014-04-11 10:05:08,366 CDT Update_78 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-Q06665, Organization-E4T:ESI, Site-0, Demand Class-0, Sales Channel-0
2014-04-11 10:05:08,382 CDT Update_86 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-200357C-10, Organization-E4T:ESI, Site-0, Demand Class-0, Sales Channel-0
2014-04-11 10:05:08,382 CDT Update_127 ERROR appserver.integration: ODPM-70446: Failed to update combination:Item-201399A-10, Organization-E4T:WSI, Site-2021::1042, Demand Class-CLASS_C, Sales Channel-0
2014-04-11 10:05:08,382 CDT Update_92 ERROR appserver.integration: ODPM-70446: Failed to update combination:[Item-201399A-20, Organization-E4T:ESI, Site-0, Demand Class-0,




The following queries return rows

 

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