Report Output Generating Wrong Date Using pin_inv_doc_gen Function (Doc ID 2271720.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Communications Billing and Revenue Management (BRM) 7.5.0, when generating invoices using pin_inv_doc_gen, the dates in the report are not the correct/expected values.

After adding the below date format in the Rich Text Format (RTF) template and running the docgen utility to generate a PDF:

<?bipext:infTimetToStr(//invoice/BILLINFO/START_T,1)?>

Displays the correct format (MM/DD/YYYY) and generates correct date.

<?format-date:(xdoxslt:ora_format_date_offset('1970-01-01',//invoice/BILLINFO/END_T div 86400 + 0.125,'+'));'DD/MM/YYYY'?>

Displays the correct format (MM/DD/YYYY) but generates a date 1 day earlier than expected.

For example, the first format results in "22-05-2016" whereas the second format shows "21-05-2017".

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms