Upgrade From R11.50.2 To R12 did not Update Contingency-Ids in Billing Transactions
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.
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 188.8.131.52 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms