Purchase And Cycle End Details In Purchased_product Object Are Set Incorrectly If All End Dates Are Not Changed (Doc ID 2527483.1)

Last updated on MARCH 29, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
-----------------------
purchase/cycle end details in /purchased_product are set incorrectly if all end dates are not changed

EXPECTED BEHAVIOR
-----------------------
purchase/cycle end details in /purchased_product are set correctly if all end dates are not changed

STEPS
-----------------------

1. PVT 22 OCT : In Customer Center, create account and purchase any product (note that Windows time is same as PVT) [PVT = pin virtual time]
2. check details in database :
   Example:
   select utl.date_t(purchase_end_t), purchase_end_details, utl.date_t(cycle_end_t),cycle_end_details,utl.date_t(usage_end_t),usage_end_details from purchased_product_t where account_obj_id0=374171;
   0 2 0 2 0 2
   
   Note: utl.date_t is just a script to convert unix timestamp to readable format. One can use their own script for same purpose.
3. Open product details page and set the purchase, cycle, usage end dates to a date (eg. 31st Oct) and save.
4. Check database :
   select utl.date_t(purchase_end_t), purchase_end_details, utl.date_t(cycle_end_t),cycle_end_details,utl.date_t(usage_end_t),usage_end_details from purchased_product_t where account_obj_id0=374171;
   31-OCT-18 12:30:00 0 31-OCT-18 12:30:00 0 31-OCT-18 12:30:00 0
5. Go back to Plans page and open the product details page and change any one of the end dates ( for example, change usage end date to 25th Oct) and save.
6. Check database:
   select utl.date_t(purchase_end_t), purchase_end_details, utl.date_t(cycle_end_t),cycle_end_details,utl.date_t(usage_end_t),usage_end_details from purchased_product_t where account_obj_id0=374171;
   31-OCT-18 12:30:00 2 31-OCT-18 12:30:00 2 25-OCT-18 12:30:00 0
   
   See here that purchase_end_details and cycle_end_details has changed to 2 from 0, while expected is to stay as 0.
7. Refresh the product details page in Customer Center and check the end dates of purchase/cycle/usage. It is seen that purchase and cycle end date is showing as NEVER, while expected is to show as 31st OCT as per changes in step 3.

Changes

Cause

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