Payables and Cash Management - EBS (MOSC)

MOSC Banner

AP_IMPORT_VALIDATION_PKG.v_populate_lines_misc return ORA-06503

edited Jan 19, 2014 3:26PM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center