Are Packages like ASAP.PKG_BBM_* and Stored Procedures like ASAP.SP_BBM_* Still needed in M6 or can be dropped for Customers in MetaSolv Solution Software ? (Doc ID 2277140.1)

Last updated on DECEMBER 03, 2019

Applies to:

Goal

QUESTIONS:

Q1. Why MSS is throwing PKG_BBM_TEMPSYS_PUSH can not compile ?

The Package PKG_BBM_TEMPSYS_PUSH can not compile.

Error: ORA-00947: not enough values.

Caused by: line 3416 of package body.

  insert into asap.ns_network_system
  select v_new_nsid,
  decode(sf_lookup_id(nst_config_type_id, 1), -1, nst_config_type_id,
  sf_lookup_id(nst_config_type_id, 1)),
  v_asap_nsnmshort,
  ns_nm_long,
  desc_100,
  status,
  ns_dt_created,
  ns_dt_in_service,
  sysdate,
  gv_user_id,
  ns_provider_sys_id,
  ns_customer_sys_id,
  ns_hard_soft_assign_cd,
  same_chnnl_assignmnt_ind,
  inherently_prot_ind
  from bbm.ns_network_system
  where ns_id = netsys_rec.ns_id;

Q2. Are the following stored procedures still necessary or can be dropped ?

1. SP_BBM_CUSTOM_BWVOICE_CONNSPEC
2. SP_BBM_CUSTOM_CANCEL_CONNSPEC
3. SP_BBM_CUSTOM_CHOOSE_CONNSPEC
4. SP_BBM_CUSTOM_CIRCUIT_BYPASS
5. SP_BBM_CUSTOM_CONSPEC_FOR_CUST
6. SP_BBM_CUSTOM_CREATE_EXTENSION
7. SP_BBM_CUSTOM_DETERMINE_BSC
8. SP_BBM_CUSTOM_GET_BW_ENDPT
9. SP_BBM_CUSTOM_GET_FS_ENDPT
10. SP_BBM_CUSTOM_GET_VIRTCONSPEC
11. SP_BBM_CUSTOM_GET_VIRT_ENDPT
12. SP_BBM_CUSTOM_LOAD_ASSGNMTS
13. SP_BBM_CUSTOM_NTWK_FOR_CONN
14. SP_BBM_CUSTOM_NTWK_FOR_CUST
15. SP_BBM_CUSTOM_NTWK_FOR_ELEMENT
16. SP_BBM_CUSTOM_VIRTTERM_NSID

 

Solution

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