FA.PLSQL.FA_MASS_ADDITIONS_PKG.Create_Lines ORA-01422

(Doc ID 2358095.1)

Last updated on FEBRUARY 06, 2018

Applies to:

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

Symptoms

On : R12 version, Invoice Issues & MassAdd

ACTUAL BEHAVIOR
---------------
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 1354927

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 1354928


EXPECTED BEHAVIOR
-----------------------
Can transfer the asset item to FA module

STEPS
-----------------------
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>


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot transfer the asset item to FA module

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms