My Oracle Support Banner

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

Last updated on AUGUST 11, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


On : R12 version, Invoice Issues & MassAdd

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

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


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.