Derive Asset Location from Payables Ship-To Location Feature Not Working - Prepare Process Ends In Error 'User-Defined Exception' (Doc ID 2794877.1)

Last updated on APRIL 04, 2023

Applies to:

Symptoms

When attempting to copy invoices from AP to FA with Ship-To Location populated on invoice and Location Mapping done in FA,
the following error occurs when the Prepare Assets Transaction Data job is ran:

ERROR
-----------------------
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: calling has the value of FND_FLEX_EXT.GET_SEGMENTS
FA.PLSQL.FA_MASSADD_PREPARE_PKG.prepare_mass_additions: error has the value of User-Defined Exception
FA_MASSADD_PREPARE_PKG.prepare_mass_additions
User-Defined Exception

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. setup the Derive Asset Location feature based on HR Location mapping
2. create invoice in AP
3. run Create Mass Additions
4. the child process Prepare Assets Transaction Data ends in error. The asset source line gets created, but the Location is not defaulted on it based on the location mapping setup.

Cause

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