R12 FA_ACTIVE_CORP_BOOK Value Set Does Not Display Asset Books End-Dated in the Future (Doc ID 1621280.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Assets - Version 12.1 and later
Information in this document applies to any platform.
FAMACR - FA MAss Additions Create Program
APMACR - AP MAss Additions Create Program


Symptoms

FA_ACTIVE_CORP_BOOK Value Set Does not Display Asset Books End-Dated in the Future.

Trying to run Mass Additions Create on an asset book that has a future inactive-date.
However, the value set that Create Mass Addition uses, FA_ACTIVE_CORP_BOOK, only displays books with a null value in the date_ineffective column.

It does not take into account that we have a "future" date in that column for one of our books.
Therefore, this book does not appear in the drop-down for the Mass Additions Create program.

 

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