My Oracle Support Banner

Error ORA-01400 When Creating Obligations Using Rest Service (Doc ID 2814008.1)

Last updated on OCTOBER 14, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to create Obligation using Rest Service the following error occurs.
PACKAGE_ERROR@1ORA-01400: cannot insert NULL into (\"RMS01\".\"ALC_COMP_LOC\".\"ACT_VALUE\")@2ALC_ALLOC_SQL.INSERT_ALC_COMP_LOCS

Steps To Recreate:
1. Set up cost components and create a PO in Approved status
2. Try to upload an obligation via MFCS Obligations Upload REST service.
3. Note the above error.

Changes

 

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
Changes
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.