AP_IMPORT_VALIDATION_PKG.v_populate_lines_misc return ORA-06503
Hi All
My client has applied a project accounting patch 17839156. Afterwards, the invoice import customization program failed at calling a standard API AP_IMPORT_VALIDATION_PKG.
Before Patch:
apiimvtb.pls 120.121.12010000.100
After Patch:
apiimvtb.pls 120.121.12010000.109
The API validation process failed at function V_POPULATE_LINES_MISC. When I replace the syntax as follow, the program seems to be running well.
Original Syntax:
--IF ( NVL(AP_IMPORT_INVOICES_PKG.tab_get_info_rec(p_invoice_rec.org_id).p_approval_workflow_flag, 'N') = 'N' )
Replaced-by Syntax:
IF ( NVL(p_invoice_rec.workflow_flag, 'N') = 'N' )
Does anyone face the same issue? Any newer version of apiimvtb.pls which I should try? Thanks.
Tagged:
0