Undocumented Tables Added in PS21 Causing Partition_utils to Fail (Doc ID 2506623.1)

Last updated on AUGUST 10, 2023

Applies to:

Goal

On: 7.5.0.21.0 version, after upgrading from ps17 to ps21:

• New tables were added as part of PS21 upgrade but are not referenced anywhere in the release notes.
• List of tables is as below :
  
  ALLOWANCE_T
  AU_HISTORY_SUBSCRIBER_CONTRA_T
  AU_SUBSCRIBER_CONTRACT_T
  DELIVERABLE_PRODUCT_T
  DELIVERABLE_T
  ENTITLEMENT_T
  EVENT_ACT_SSP_MILESTONE_INFO_T
  EVENT_CONTRACT_CANCEL_T
  EVENT_CONTRACT_MODIFY_T
  EVENT_CONTRACT_RENEW_T
  EVENT_CONTRACT_START_T
  EVENT_CONTRACT_T
  EVENT_PRODUCT_FEE_PENALTY_T
  EVT_ACT_MSTONE_EVENTS_T
  EVT_ACT_MSTONE_INFO_T
  FEATURE_T
  HISTORY_SUBSCRIBER_CONTRACT_T
  JOURNAL_BAL_IMPACTS_T
  JOURNAL_MASTER_T
  RATE_RBI_INFO_T
  RECURRING_ALLOWANCE_T
  REVENUES_PROD_T
  REVENUE_BASIS_ITEM_T
  REVENUE_DETAILS_T
  REVENUE_DISTRIBUTION_T
  REVENUE_EVENT_BAL_IMPACTS_T
  REVENUE_EVENT_T
  REVENUE_PRODUCT_T
  REV_EVENT_DELIVERABLE_T
  REV_PROD_DELIVERABLE_T
  SERVICE_ENTITLEMENTS_T
  SUBSCRIBER_CONTRACT_T
  SUBSCRIPTION_TERMS_T
  
  
• From the above list, below are the new non-partitioned event sub-classes/tables (that are making partition_utils to fail)
  
  /event/customer/contract
  EVENT_CONTRACT_T

  /event/customer/contract/cancel
  EVENT_CONTRACT_CANCEL_T

  /event/customer/contract/create
  EVENT_CONTRACT_START_T

  /event/customer/contract/modify
  EVENT_CONTRACT_MODIFY_T

  /event/customer/contract/renew
  EVENT_CONTRACT_RENEW_T

  /event/activity/ssp/milestone
  EVENT_ACT_SSP_MILESTONE_INFO_T

  /event/billing/product/fee/cancel/penalty
  EVENT_PRODUCT_FEE_PENALTY_T

• Below is the command being used to create a new partitions in the system:
  
  "partition_utils -o add -t realtime -s 01102019 -e 02102019 -q 1 -u month -c /event"
  
  
• and it is failing with error:
  
  "ORA-20017: PARTITION_LASTPartition not exists in table EVENT_CONTRACT_START_T,ORA-20017: PARTITION_LAST Partition not exists in table EVENT_CONTRACT_RENEW_T "

Question :

How to resolve this error ?

Solution

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