How is the Counter end date is calculated while the enable flag is un checked in a usage contract ?

Dec 22, 2011 8:03PM

Hi,

In Oracle service contracts R12.1.1, I end dated a counter in a usage contract by below given navigation.

1. Open Active Usage contract

2. Navigate to Lines -> Counters

3. Actions -> counter setup

4. In counter setup form, for a counter, the enable flag is un checked and saved.

But when i see in CSI_COUNTERS_B table,

I thought "end_date_active" column will hold either sysdate or trunc(sysdate). [sysdate at the time of transaction]

But what i see is "trunc(sysdate)-1" some thing like below.

end_date_active last_update_date

---------------------------------------------------------------

22-DEC-2011 00:00:00 23-DEC-2011 01:17:59

I need to know why end date gets stored in this way "trunc(sysdate)-1" ?

Install Base and Asset Tracking - EBS (MOSC)