R12: AP: Validate Invoice Error Out After Create New DFF Which Refer 'Invoice_Type_Lookup_Code' (Doc ID 1606016.1)

Last updated on OCTOBER 27, 2015

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, EB Tax

When attempting to validate the new created prepayment invoice after define a Payable prepayment Invoice DFF which refer 'Invoice_type_lookup_code',
the following error occurs.

ERROR
-----------------------
Unexpected error occurred during Tax Calculation.
Exception: User-Defined Exception
Please correct the problem or contact your System Administrator.

ORA-06510: PL/SQL: unhandled user-defined exception

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Log in Payables responsibility
2.Navigate to Setup > Flexfields > Descriptive > Segment,search Title=invoice
3.Define a prepayment DFF and "reference filed" -> 'Invoice_type_lookup_code'
4.Navigate to Invoice > Entry > Invoice,create a Prepayment invoice,then validate prepayment invoice
5.Error out

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms