My Oracle Support Banner

Upgrade From R11.50.2 To R12 did not Update Contingency-Ids in Billing Transactions (Doc ID 2296349.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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


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.

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 ()

The issue can be reproduced at will with the following steps:
1. Upgrade OLFM From 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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.