Retirement API Error: ORA-01400: Cannot Insert NULL Into ("FA"."FA_RETIREMENTS"."STATUS") when Retiring CIP Assets
(Doc ID 2831913.1)
Last updated on JANUARY 10, 2022
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