R12: OIE: When Auditing an Expense Report, Verify Receipts Results in Workflow Error - ORA-06502 (Doc ID 2728029.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Symptoms

Oracle Internet Expenses - Version 12.1 to 12.2 [Release 12.2]

When Auditing an expense report, Verify Receipts results in workflow error

"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

Changes

 Navigation:  Expenses Audit
1. Query an expense report ready for audit with cash or credit card expense lines
with receipts required
2. Go to the Process Exceptions Tab
3. Click Verify Receipts for all where it’s needed but one line
4. For the last line select the new audit reason from the LOV (Missing
Required Receipt)

Workflow error results:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.