- ERP System: Oracle
- MarkView Version: All versions
- After submitting receipts the Oracle workflow will transition out of the MarkView Node in the Oracle Expenses workflow and an error similar to the following will be raised:
Build Receipt Information For Approval Letter #EXCEPTION -6502
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.CALLBACKFUNCTION, APEXP, 17842, SET_CTX) Wf_Engine_Util.Execute_Selector_Function(APEXP, 17842, SET_CTX)
Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.BUILDMANAGERAPPRVLMESSAGE, APEXP, 17842, 576723, RUN)
- This issue is caused by an Oracle defect in how the date format is derived when certain Oracle patches are applied.
- In order to resolve this issue Oracle Patch Number 11870353 can be applied to your environment.