Billing and Revenue Management (MOSC)

MOSC Banner

Backdated or future account creation

edited Nov 14, 2010 5:02PM in Billing and Revenue Management (MOSC) 1 commentAnswered
I would be grateful if you could help me with the following cases.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center