Backdated or future account creation
I am using the PCM_OP_CUST_CREATE_CUSTOMER opcode in order to create an active customer either in the past or in the future (related to now).
Backdated account creation case
- I have executed the aforementioned opcode setting all the mandatory fields and the PIN_FLD_START_T to a past date.
- system date is Wed Sep 15 01:01:57 2010 and PIN_FLD_START_T is Fri Aug 20 13:00:00 2010
- Outcome: In the output flist the start date is as has been set (Fri Aug 20 13:00:00 2010) but the PIN_FLD_END_T is set to system date and the EFFECTIVE_T in the DB has been set to system date and not to Fri Aug 20 13:00:00 2010. Example input and output flists are attached below