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 JANUARY 10, 2022

Applies to:

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

Symptoms


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")

ERROR

ORA-01400


STEPS

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


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.