My Oracle Support Banner

R12 Prepare Mass Additions (FAXMADDS): Is Not Processing Data in Specific Order (Doc ID 2042216.1)

Last updated on JULY 06, 2020

Applies to:

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


Prepare Mass Additions is processing data in no specific order. The issue is in FA_MASSADD_PREPARE_PKG.prepare_mass_additions. Cursor GET_MASS_ADD has no ORDER BY specified. For that reasons associated (child) rows can get processed before the main (parent) distribution lines are processed causing issues for customization in FA_MASSADD_PREP_CUSTOM_PKG.prepare_attributes for interdependent rows (for example tax lines associated to invoice distribution lines).


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.