Why Does Pcm_op_cust_update_customer Opcode Not Delete A Phone Number ? (Doc ID 880488.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0
Information in this document applies to any platform.

Goal

When the users want to delete a phone, they omit it from PIN_FLD_PHONES array, but the missed element is not deleted from database. Why?

-- Steps to Reproduce
1. Create an account as below :

0 PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account -1 0
0 PIN_FLD_BAL_INFO      ARRAY [0] allocated 20, used 2
1     PIN_FLD_POID           POID [0] 0.0.0.1 /balance_group -1 0
1     PIN_FLD_BILLINFO      ARRAY [0] allocated 0, used 0
0 PIN_FLD_BILLINFO      ARRAY [0] allocated 20, used 4
1     PIN_FLD_PAY_TYPE       ENUM [0] 10003
1     PIN_FLD_POID           POID [0] 0.0.0.1 /billinfo -1 0
1     PIN_FLD_BILLINFO_ID     STR [0] "Account Billinfo"
1     PIN_FLD_PAYINFO       ARRAY [1]     NULL array ptr
0 PIN_FLD_ACCTINFO      ARRAY [0] allocated 20, used 4
1     PIN_FLD_POID           POID [0] 0.0.0.1 /account -1 0
1     PIN_FLD_BAL_INFO      ARRAY [0] allocated 0, used 0
1     PIN_FLD_CURRENCY        INT [0] 840
1     PIN_FLD_ACCOUNT_NO      STR [0] "BRM117_002"
0 PIN_FLD_NAMEINFO      ARRAY [1] allocated 20, used 9
1     PIN_FLD_ZIP             STR [0] "94086"
1     PIN_FLD_STATE           STR [0] "CA"
1     PIN_FLD_CITY            STR [0] "Sunnyvale"
1     PIN_FLD_ADDRESS         STR [0] "BRM117_002"
1     PIN_FLD_PHONES        ARRAY [0] allocated 20, used 2
2         PIN_FLD_PHONE           STR [0] "408-111-2222"
2         PIN_FLD_TYPE           ENUM [0] 1
1     PIN_FLD_LAST_NAME       STR [0] "BRM117_002"
1     PIN_FLD_COUNTRY         STR [0] "USA"
1     PIN_FLD_FIRST_NAME      STR [0] "BRM117_002"
1     PIN_FLD_CONTACT_TYPE    STR [0] "Billing"
0 PIN_FLD_PAYINFO       ARRAY [1] allocated 20, used 3
1     PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_CC_INFO       ARRAY [0] allocated 20, used 8
3             PIN_FLD_NAME            STR [0] "MyVISA"
3             PIN_FLD_DEBIT_NUM       STR [0] "XXXX"
3             PIN_FLD_ZIP             STR [0] "94086"
3             PIN_FLD_STATE           STR [0] "CA"
3             PIN_FLD_CITY            STR [0] "Sunnyvale"
3             PIN_FLD_DEBIT_EXP       STR [0] "XXXX"
3             PIN_FLD_ADDRESS         STR [0] "BRM117_002"
3             PIN_FLD_COUNTRY         STR [0] "USA"
1     PIN_FLD_POID           POID [0] 0.0.0.1 /payinfo/cc -1 0
1     PIN_FLD_PAY_TYPE       ENUM [0] 10003
0 PIN_FLD_PROFILES      ARRAY [0] allocated 20, used 3
1     PIN_FLD_PROFILE_OBJ    POID [0] 0.0.0.1 /profile/order -1 0
1     PIN_FLD_NAME            STR [0] "BRM117_002"
1     PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 1
2         INTU_FLD_ORDER_ITEMS  ARRAY [0] allocated 20, used 2
3             INTU_FLD_ITEM_NO        STR [0] "A00025"
3             INTU_FLD_SERVICE_ID     STR [0] "BRM117_002"
0 PIN_FLD_POID           POID [0] 0.0.0.1 /plan 115797 0
0 PIN_FLD_CREATED_T    TSTAMP [0] (1245858892) Wed Jun 24 08:54:52 2009
0 PIN_FLD_MOD_T        TSTAMP [0] (1245858892) Wed Jun 24 08:54:52 2009
0 PIN_FLD_READ_ACCESS     STR [0] "B"
0 PIN_FLD_WRITE_ACCESS    STR [0] "S"
0 PIN_FLD_DEAL_OBJ       POID [0] 0.0.0.0 / 0 0
0 PIN_FLD_DESCR           STR [0] "A00025"
0 PIN_FLD_FLAGS           INT [0] 0
0 PIN_FLD_NAME            STR [0] "Customers Online Monthly Plan"
0 PIN_FLD_SERVICES      ARRAY [0] allocated 20, used 7
1     PIN_FLD_BAL_INFO_INDEX    INT [0] 0
1     PIN_FLD_DEAL_OBJ       POID [0] 0.0.0.1 /deal 116517 0
1     PIN_FLD_SERVICE_ID      STR [0] "BRM117_002"
1     PIN_FLD_SERVICE_OBJ    POID [0] 0.0.0.1 /service/telco/gsm/telephony -1 0
1     PIN_FLD_SUBSCRIPTION_INDEX    INT [0] 0
1     PIN_FLD_LOGIN           STR [0] "BRM117_002"
1     PIN_FLD_PASSWD_CLEAR    STR [0] "XXXX"
0 PIN_FLD_START_T      TSTAMP [0] (1247234611) Fri Jul 10 07:03:31 2009
0 PIN_FLD_END_T        TSTAMP [0] (1247234611) Fri Jul 10 07:03:31 2009




2. Now add a phone :


0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 148006 8
0 PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account 148006 8
0 PIN_FLD_PROGRAM_NAME    STR [0] "INTU"
0 PIN_FLD_NAMEINFO      ARRAY [1] allocated 20, used 10
1     PIN_FLD_CONTACT_TYPE    STR [0] "Billing"
1     PIN_FLD_LAST_NAME       STR [0] "BRM117_002"
1     PIN_FLD_FIRST_NAME      STR [0] "BRM117_002"
1     PIN_FLD_ADDRESS         STR [0] "BRM117_002"
1     PIN_FLD_CITY            STR [0] "Sunnyvale"
1     PIN_FLD_STATE           STR [0] "CA"
1     PIN_FLD_ZIP             STR [0] "94086"
1     PIN_FLD_COUNTRY         STR [0] "USA"
1     PIN_FLD_PHONES        ARRAY [0] allocated 20, used 2
2         PIN_FLD_PHONE           STR [0] "408-111-2222"
2         PIN_FLD_TYPE           ENUM [0] 1
1     PIN_FLD_PHONES        ARRAY [1] allocated 20, used 2
2         PIN_FLD_PHONE           STR [0] "408-111-3333"
2         PIN_FLD_TYPE           ENUM [0] 2


3. Now try to delete a phone :


0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 148006 8
0 PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account 148006 8
0 PIN_FLD_PROGRAM_NAME    STR [0] "INTU"
0 PIN_FLD_NAMEINFO      ARRAY [1] allocated 20, used 10
1     PIN_FLD_CONTACT_TYPE    STR [0] "Billing"
1     PIN_FLD_LAST_NAME       STR [0] "BRM117_002"
1     PIN_FLD_FIRST_NAME      STR [0] "BRM117_002"
1     PIN_FLD_ADDRESS         STR [0] "BRM117_002"
1     PIN_FLD_CITY            STR [0] "Sunnyvale"
1     PIN_FLD_STATE           STR [0] "CA"
1     PIN_FLD_ZIP             STR [0] "94086"
1     PIN_FLD_COUNTRY         STR [0] "USA"
1     PIN_FLD_PHONES        ARRAY [0] allocated 20, used 2
2         PIN_FLD_PHONE           STR [0] "408-111-2222"
2         PIN_FLD_TYPE           ENUM [0] 1


4. Called opcode pcm_op_cust_update_customer in both cases. The phone 408-111-3333 still remains with account.


Solution

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