Extract Assets Reporting Data Errors With "Retrieving A Row From The FA_BOOK_CONTROLS Table For The Book {BOOK} Failed." (Doc ID 2552407.1)

Last updated on FEBRUARY 08, 2024

Applies to:

Symptoms

When the Create Accounting program is scheduled, the Extract Assets Reporting Data is kicked off and it ends with the following error:

"Retrieving a row from the FA_BOOK_CONTROLS table for the book {BOOK} failed.

fa_cache_pkg.fazcbc

ORA-01403: no data found"

The issue can be reproduced at will with the following steps:
1. Create Accounting program is scheduled
2. System kicks off the Extract Assets Reporting Data process

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.