Billing and Revenue Management (MOSC)

MOSC Banner

UTC OFFSET IN RATED CDR / INVOICE

edited Oct 31, 2014 10:01AM in Billing and Revenue Management (MOSC) 2 commentsAnswered

Hi All,

Can you confirm / clarify whether below configuration is possible in BRM by OOTB.

we are using UTC timestamp values in all TIMESTAMP Fields of input cdr. Once the CDR is rated the same timestamp will be reflected in the output CDR ( UTC_OFFSET is +0000 ) and same will be loaded into DB. In Invoice we are getting 1hr difference due to BST timestamp of the server ( this is based on daylight saving time ).

Actual :

Eg:- CDR TIME 01 Jan 2014 13:00:00 ->  OUTPUT TIME 01 Jan 2014 13:00:00 -> EVENT_T TIME 01 Jan 2014 13:00:00 -> INVOICE TIME 01 Jan 2014 12:00:00

Expected

Eg:- CDR TIME 01 Jan 2014 13:00:00 ->  OUTPUT TIME 01 Jan 2014 12:00:00 -> EVENT_T TIME 01 Jan 2014 12:00:00 ->  INVOICE TIME 01 Jan 2014 12:00:00

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