EBI 9.2: BIGIVCPN Error Datetime Field Overflow On Microsoft (Doc ID 2093323.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Billing Finalization/Proforma Image 13

SQL Error "SQL Server Native Client 11.0] Datetime field overflow. occurred in BIGIVCPN

ERROR
-----------------------
BIGIVCPN Error: SQL Status = 0, SQL Error = [Microsoft] [SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a contract and send to Billing
2. Run Billing interface to create the temp bill
3. Approve the Temp bill and Generate the Bill by running BIJOB03

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete BIJOB03.

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