Upgrade From R11.50.2 To R12 did not Update Contingency-Ids in Billing Transactions

(Doc ID 2296349.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, INSTALL

OLFM Upgrade from R11i to R12 did not update Contingency-Ids in Billing Transactions. This is resulting errors in Program: Receivables Invoice Transfer to AR as in 11i this program was using Contingency-Code and now using Contingency_id.

ERROR
-----------------------
06202192|okl.plsql.okl_arintf_pvt.get_rec_feeder.debug|Inserting into ar_contingency
406202193|okl.plsql.okl_arintf_pvt.get_rec_feeder.debug|Exception: For interface lines, error 1 occurred during iteration 1
406202194|okl.plsql.okl_arintf_pvt.get_rec_feeder.debug|Oracle error is ORA-01400: cannot insert NULL into ()


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade OLFM From 11.5.10.2 to R12.2.5
2. Take contracts that were booked in R11i and maybe partially billed in R11i as well and have cash basis billing streams
3. Process billing to generate future billing and the records are erroring in Receivables Invoice Transfer to AR process and records are not inserted into AR interface table.

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