R12: AP: Payables Period Close Analyzer - Ends with Error "Cause: fdlget failed due to ORA-24345: A Truncation or null fetch error occurred", "Error in main at step 15: ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
(Doc ID 2880057.1)
Last updated on JUNE 29, 2022
Applies to:
Oracle Payables - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run Payables Period Close Analyzer, this is giving error when the user is selection Operating Unit parameter:
ERROR
-----------------------
Error in main at step 15: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Cause: fdlget failed due to ORA-24345: A Truncation or null fetch error occurred.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Payables Manager
2. (N) Other > Request > Run
2. Run Payables Period Close Analyzer
2. When click on the Operating Unit List of values, the error mentioned above occurs.
Changes
Setup Operating Unit with more than 30 characters
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |