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 220.127.116.11 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