R12: AP: FA.PLSQL.FA_MASS_ADDITIONS_PKG.Create_Lines ORA-01422 (Doc ID 2358095.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Symptoms

On : R12 version, Invoice Issues & MassAdd

After run mass addition create program and no data transfer to FA

ERROR
---------------
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE Parameters:  Book Type Code: 2015_ASSET_BOOK, Accounting Date: 2018/01/31 00:00:00

FA.PLSQL.FA_MASS_ADDITIONS_PKG.create_lines Insert FA_MASS_ADDITIONS lines for primary ledger  has the value of 2015_ASSET_BOOK 25-1る -18 #######

FA.PLSQL.FA_MASS_ADDITIONS_PKG.create_lines "OFAFA_SHARED_ORACLE_ERRNORACLE_ERRORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at ""APPS.FA_MASS_ADDITIONS_BRI"", line 38

ORA-04088: error during execution of trigger 'APPS.FA_MASS_ADDITIONS_BRI'" 25-1る -18 #######

It is expected to  be able to transfer the asset item to FA module

The issue can be reproduced at will with the following steps:
1. Log in EBS
2. Switch to Payable Responsibility
3. Click Request -> Submit New Request
4. Execute <Mass Addition Create>


Due to this issue, users cannot transfer the asset item to FA module

Cause

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