My Oracle Support Banner

Retirement API Error: ORA-01400: Cannot Insert NULL Into ("FA"."FA_RETIREMENTS"."STATUS") when Retiring CIP Assets (Doc ID 2831913.1)

Last updated on JULY 05, 2023

Applies to:

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


When retiring CIP assets using retirement API in Corp Book, the following error occurs when "Allow CIP Asset" is enabled for the Tax Book.

Error: ORA-01400: cannot insert NULL into ("FA"."FA_RETIREMENTS"."STATUS")

The issue can be reproduced at will with the following steps:

1/ Confirm 'Allow CIP Asset' is checked for the Tax Book

    FA > Setup  > Asset System > Book controls : Query a tax book belongs to the Corp book

     Under Tax Rule tab, confirm 'Allow CIP Asset' is checked

2/ Retire a CIP assert using Retirement API in Corp Book

     206476.1 - Oracle Assets Retirements and Reinstatements API Documentation Supplement




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

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