R12 Post Mass Additions (FAMAPT): Errors With "ORA-01403: NO DATA FOUND" And "ERROR: FUNCTION FA_INVOICE_PVT.INV_ENGINE RETURNED FAILURE" (Doc ID 785655.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Assets - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
FAMAPT - Mass Additions Post


Symptoms

Post Mass Additions (FAMAPT) fails with the following error for all assets:

ORA-01403: no data found
APP-OFA-48208: entering has the value of if h_mesg_count > 1.
APP-OFA-48208: entering has the value of loop for get.
APP-OFA-48208: at has the value of top of loop for get.
Error: function fa_invoice_pvt.inv_engine returned failure
APP-OFA-48208: at has the value of top of loop for get.
Error: function fa_addition_pub.do_addition returned failure
APP-OFA-48208: at has the value of top of loop for get.
Mass Addition ID: #### ==> ** Failed **

If profile "FND: Debug Log Level = YES", Mass Additions Post will complete without error but caused performance issue.

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