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 JANUARY 10, 2018

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 a 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