R12.1:JL:AP: Error When Assigning Third In Ap Distribution

(Doc ID 2319745.1)

Last updated on OCTOBER 20, 2017

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Colombian Payables

When attempting to assign a Third Party to the distribution using the TAXPAYER ID field,
the following error occurs.

APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A truncation or null fetch occurred


The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Colombia localization - 12.1.3
Production and Test instances

2. Path: Invoices -> Enter -> Invoices (APXINWKB)
3. Query an invoice
Invoice Num: GASTOS DP GTA 032017-2
Supplier: GERSON TAKESHI ANDO

4. Go to Distributions
5. Try to assign a Third Party to the distribution using the TAXPAYER ID field.

Additional Information for Colombia

Context Value: Invoice Distribution Information
Ship to Location: PALMIRA
Taxpayer ID:

The following error occurs (step_by_step.docx):


APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A truncation or null fetch occurred

The SQL statement being executed at the time of the error was:

SELECT PV.SEGMENT1,NVL(PAPF.NATIONAL_IDENTIFIER,NVL(PV.INDIVIDUAL_1099,PV.NUM_1099))
VALUE,NVL(PAPF.NATIONAL_IDENTIFIER,NVL(PV.INDIVIDUAL_1099,PV.NUM_1099))
DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y), NVL
(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), "J'), 0), PV.VENDOR_NAME
"Supplier Name", PV.SEGMENT1 "Supplier Number"
FROM (SELECT INDIVIDUAL_1099,VENDOR_NAME,EMPLOYEE_ID,SEGMENT1
FROM PO_VENDORS) PV, (SELECT DISTINCT PERSON_ID,NATIONAL_IDENTIFIER
FROM PER_ALL_PEOPLE_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE) PAPF
WHERE (NVL(PV.EMPLOYEE_ID, -99) = PAPF.PERSON_ID (+))
AND 'Y' = 'Y'
AND TO_DATE(:A00, 'YYYY/MM/DD HH24:MI:SS') BETWEEN NVL(TRUNC(TO_DATE(NULL)),
TO_DATE(:A01, 'YYYY/MM/DD HH24:MI:SS'))
AND NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A02, 'YYYY/MM/DD HH24:MI:SS'))
ORDER BY


6. Value set error (error.png)

Value set: JLCO_AP_THIRDPARTY_ID
Type: List of values

Max Size: 240

Error:

The maximum size should not exceed the column size of the table.
Reducing the maximum size.


The issue has the following business impact:
Due to this issue, users cannot assign a Third Party to the distribution using the TAXPAYER ID field

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