Order Fallout Due To Account Updation In Middle in AIA BRM integration (Doc ID 1391937.1)

Last updated on MARCH 15, 2019

Applies to:

Symptoms

On : 7.4.0.0.0 version, Customer Registration

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) On Aug 1 2011, customer account is created in Siebel.
2) Two orders are created for the account on Aug 1 2011
3) On Aug 1 2011, one order is submitted and processed successfully. Assets are created in Siebel
4) Second order is not submitted due to pending payment collection confirmation.
5) On Aug 2 2011 account contact information is updated and change is reflected in BRM. AIA flow calls PCM_OP_CUST_SET_STATUS every time there is an update on customer in Siebel (even though the customer status may not be updated)
6) On Aug 3 2011, payment confirmation is received and the 2nd order is submitted

Since in step # 5 PCM_OP_CUST_SET_STATUS is invoked, in BRM the date of last status change field is updated to Aug 2 2011. The order processed in step #6 fails as BRM does not allow you to backdate the product or discount purchase if the backdated purchase date is prior to the date of the last status change of the account or service

In order to address this issue, the opcode PCM_OP_CUST_SET_STATUS needs to enhanced such that it would NOT update last_status field if there is no change in status.

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.