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