R12 Not Able To Add CIP Member To Group If Tax Book Is Associated To Corp Book Errors With 'ORA-01403: no data found' (Doc ID 1957454.1)

Last updated on JUNE 08, 2017

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,

Not able to add CIP member asset to Group if Tax book is associated with Corporate Book.
Expect: Should be able to add CIP member asset to Group.

Steps
-----------------------
Using FA Responsibility

1. Add corporate book and associated tax book by enabling 'Allow CIP members in Group Assets' in both books;
enable copy of member asset assignments;
enable allow cip assets in Tax Book-Tax rules tab.
2. Add group asset in corporate book.
3. Add CIP asset as member to the group. This can be tried either from asset
workbench or mass additions from payables or additions integrator.

An error is thrown as follows:

Error
-----------------------
ORA-01403: no data found
Error: function fa_util_pvt.get_asset_fin_rec returned failure
Error: function fa_addition_pub.do_addition returned failure
 
Note:
CIP asset can be added successfully to a group if tax book is not associated
to corporate book.

 

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