ESC-ASCP Plan Names Are Not Downloaded In Demantra ODPM-10421: Population Attribute, Error:ODPM-10422: Invalid Population,ODPM-10071

(Doc ID 1450277.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Sep-2014***

Symptoms

 ASCP R12.1.1 CU 3 (patch # 8602258)
Demantra 7.3.0.1

ASCP Plan names are not getting downloaded into Demantra after running workflow "Download Plan Scenario"
The customer has not been able to load any plans yet.

Support and Customer checked the following:

1. Reviewed white paper DemantraSOP_ASCP_Integration.docx

2. From APS Check: MSD_DEM: Host URL    http://at1odemap102.onerheem.com/demantra    
   From sys_params: AppServerURL    http://at1odemap102.onerheem.com/demantra

3. Collaborator.log

   2012-02-28 14:50:03,563 CST [WFProcess_8] INFO  appserver.integration: ODPM-20297: Import Level.
   2012-02-28 14:50:03,563 CST [WFProcess_8] INFO  appserver.integration: ODPM-20044: Run Start Time: 02-28-2012 14:50:03
   2012-02-28 14:50:03,563 CST [WFProcess_8] INFO  appserver.integration: ODPM-20045: Interface Name: Plan Scenarios
   2012-02-28 14:50:03,563 CST [WFProcess_8] INFO  appserver.integration: ODPM-20046: Profile Name: Plan Scenarios
   2012-02-28 14:50:03,563 CST [WFProcess_8] INFO  appserver.integration: ODPM-20047: Level: Plan Scenario
   2012-02-28 14:50:03,844 CST [WFProcess_8] INFO  appserver.integration: ODPM-20182: Rows processed: 0.
   2012-02-28 14:50:03,922 CST [WFProcess_8] INFO  appserver.integration: ODPM-20048: Run End Time: 02-28-2012 14:50:03
   2012-02-28 14:50:03,922 CST [WFProcess_8] INFO  appserver.integration: ODPM-20049: Run Duration Time (hh:mm:ss:msec):0:0:0.359

4. No relevant entry in db_exception_log

5. BIIO_SUPPLY_PLANS_err
   "[ODPM-10421: Population Attribute, Error:ODPM-10422: Invalid Population,ODPM-10071: Member Code '0' Not Found in Level 425.]
"

6. BIIO_SUPPLY_PLANS_POP_ERR -- receive error 'invalid population' on Item,Demand Class, Organization, Site, Sales Channel

7. BIIO_OTHER_PLAN_DATA_ERR -- no records returned

8. Executed the following procedure during an OWC to make sure the privileges are present:
     
     begin
     demantra.api_notify_aps_integration(399);
     end;

9. Check proper privileges has given to the demantra schema or not.If not given,you need to give them manually.For more information about the privileges you can review these documents
   Additional Database Privilege needed for Demantra Schema when Running on Oracle 11g Database (Doc ID 730883.1)
   Additional Configurations needed when Running Demantra on Oracle 11g Databases (Doc ID 1064995.1
   uploaded output from:
   SELECT * from dba_role_privs where grantee = 'APPS'
   SELECT * from dba_sys_privs where grantee = 'APPS'

10.Based on error "Member Code '0' Not Found in Level 425"
   Note 751171.1: Run the Upgrade Model process (Business Modeler --> Data Model Wizard) again to restore this default member to the table, recheck for the default member (select * from t_ep_organization;) and then re-try the Download Plan Scenarios workflow.
   t_ep_organization is uploaded.  Support asked to manually change the default to 0 based on previous SR.
   
   update t_ep_organization set organization =  '0' where t_ep_organization_ep_id = 0;
   commit;
   
   Customer's response: "I upgraded the model as per Note 751171.1 and ran download plan data workflow but still the plan names are not getting populated in supply dashboard"

11.Note 1353293.1:  manually run the following grant statements -
   grant execute on api_notify_aps_integration to apps;
   grant execute on API_MODIFY_INTEG_SERIES_FDATE to apps;
   Still no plan names downloaded.

12.From customer APS Check:

MSD_DEM_SOP                    msddemsopb.pls       120.17.12010000.11                       BODY VALID                                                                                                                                                  
MSD_DEM_SOP                    msddemsops.pls       120.2.12010000.2                         SPEC VALID

-- most current version of msddemsopb.pls is 120.62
-- most current version of msddemsops.pls is 120.15

From section 5.3 in APS Check:


From section 29 in APS Check:
Invalid objects: MSD_DEM_SCN_ENTRIES_MV              MATERIALIZED VIEW    INVALID    APPS
-- no action taken on this yet.

13. Run the Call_Data_Model procedure to validate the schema and insert missing default level members.
Then run Update Synonyms again and retest.  Same results.

14. Please check if the following views show data for the plan (filter by plan_id, use plan_id value from msc_plans table).

MSD_DEM_CONSTRAINED_FORECAST_V - available
MSD_DEM_PLANNED_PRODUCTION_V  -available
MSD_DEM_AVAIL_RESOURCE_CAP_V - available
MSD_DEM_REQR_RESOURCE_CAP_V - available
MSD_DEM_AVAIL_SUPPLIER_CAP_V - No data
MSD_DEM_REQR_SUPPLIER_CAP_V - No data
MSD_DEM_SAFETY_STOCKS_V  -available
MSD_DEM_BEGINING_ONHAND_V  - available
MSD_DEM_DEPENDENT_DEMAND_V - available
MSD_DEM_PLANNED_SHIPMENTS_V - available

If the views show data, run the following from backend (as demantra schema user) :
 
begin
apps.msd_dem_sop.load_plan_data(15021);
end;

select * from T_SRC_ITEM_TMPL; --uploaded
select * from T_SRC_LOC_TMPL;  --uploaded
select * from T_SRC_SALES_TMPL; --uploaded
select * from BIIO_SUPPLY_PLANS; --no rows returned
select * from BIIO_SUPPLY_PLANS_POP; --no rows returned
select * from BIIO_OTHER_PLAN_DATA; --no rows returned
select * from BIIO_RESOURCES; --no rows returned
select * from BIIO_RESOURCE_CAPACITY; --no rows returned
select * from BIIO_SCENARIO_RESOURCES; --no rows returned
select * from BIIO_SCENARIO_RESOURCE_POP; --no rows returned
select * from BIIO_SUPPLY_PLANS_err; --uploaded
select * from BIIO_SUPPLY_PLANS_POP_err; --uploaded
 
15. No errors in

BIIO_CTO_LEVEL_ERR;
BIIO_CTO_POPULATION_ERR;
BIIO_CTO_DATA_ERR;

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