My Oracle Support Banner

Assign Lease To Tax Book Error: Asset_schedule_num Cannot Be Null For Tax Book. ORA-01403 No Data Found (Doc ID 2671394.1)

Last updated on MAY 18, 2020

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

When copying lease without asset from corp book to tax book, the following error is received:

ERROR:
----------
FA.PLSQL.fa_lease_gen_int_sch_pkg.prepare_asset_schedules:
Asset_schedule_num cannot be null for tax book has the value of <nr>
fa_lease_gen_int_sch_pkg.prepare_asset_schedules
ORA-01403: no data found

Steps to Reproduce:
--------------------------
  go to UI -> Assets -> Book: DE LOCAL GAAP BOOK -> Manage Leases
  find the lease to copy to tax book
  click on Assign Book
  Generate Lease Schedules process is triggered. This ends in Error.

This occurs only for leases which are associated to zero assets in the Corporate Book (which have the Assets to Add = 0).

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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