Inactive Asset Book Used in Create Mass Additions From Payables(From Metalink)-优快云博客

Subject:	Inactive Asset Book Used in Create Mass Additions From Payables
	Doc ID:	Note:303512.1	Type:	PROBLEM
	Last Revision Date:	22-NOV-2008	Status:	PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Assets - Version: 11.0
This problem can occur on any platform.
EXECUTABLE:FAMACR - Mass Additions Create

Symptoms

Mass Additions Create from Oracle Payables was allowed to be run for an asset book that is disabled.

Cause

The Validation Set "FA_CORP_BOOK" does not exclude disabled books.

This is the Validation Set in use. The issue is logged as Bug 1599195.

Solution

The fix to prevent this in the future is available by applying patchset 11.0.FA.G - Patch 1626136, or higher.

To delete the current Mass Addition rows and reset the invoices in Oracle Payables, so that they can be created
again, please raise a Service Request with Oracle Support, referring to this note number and request a datafix.

@ Internal - datafix
@
@ The following steps can be run:
@
@ 1) Run this SQL:
@
@ update AP_INVOICE_DISTRIBUTIONS_ALL
@ set ASSETS_ADDITION_FLAG = 'U'
@ where INVOICE_ID in
@ (select INVOICE_ID
@ from FA_MASS_ADDITIONS
@ where BOOK_TYPE_CODE = '&BOOK_NAME'
@ and POSTING_STATUS = 'NEW');
@
@ delete from FA_MASS_ADDITIONS
@ where BOOK_TYPE_CODE = '&BOOK_NAME'
@ and POSTING_STATUS = 'NEW';
@
@ 2) Rerun Create Mass Additions for the desired book.
@