Pay Invoices Transfer to AP Invoice Interface Fails for some Records (Doc ID 1349279.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 01-Jun-2014

Symptoms

When attempting to run the program "Pay Invoices Transfer to AP Invoice Interface" , some records fail with the following errors and none of the records get processed.

ERROR
Processing Vendor Id: 4
++++++++++ Invoice #: 373 Vendor Invoice Number: 372
++++++++++ Invoice Date: 06-MAY-11 Invoice Amount: 1000
==================================================================
--Contract id: Line id:
--Install location id: Location id: Ship to id:
--Inventory item id:
Tax call failed for invoice line id: of invoice id: 5046
Tax call failed:1: OKC_CONTRACTS_UNEXPECTED_ERROR (SQLcode=-6502)
(SQLerrm=ORA-06502: PL/SQL: numeric or value error: character string buffer too small)


STEPS
The issue can be reproduced at will with the following steps:
1. Run the set of standard programs to process AP transactions that originates from OLFM (Oracle Lease Management Module)

2. If there are any failed contracts in the "Pay Invoices Transfer to AP Invoice Interface" process, the successful records do not even get processed. The output shows as the following:
Number of Invoices Prepared in ap_invoices_interface :0

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