My Oracle Support Banner

EAM-Brazil: Asset Allocation Abend At AMALLOC.UPDDIST.Step01A -ORA-01400: Cannot Insert NULL COMPLEMENT_TP_ABL (Doc ID 2124936.1)

Last updated on JANUARY 25, 2021

Applies to:

PeopleSoft Enterprise FIN Asset Management Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


The Peopletools version is 8.54.15 and the DMO environment is with bundle 18.

The process AMALLOC(Process allocation) returns with the following error:

-- 13:28:44.852 Process 11125 ABENDED at Step AMALLOC.UPDDIST.Step01A (Action SQL) -- RC = 1400
-- 13:28:44.906 SQL Error: ORA-01400: cannot insert NULL into ("EMDBO"."PS_DIST_LN"."COMPLEMENT_TP_ABL")

Replications steps:
1 – Add a new Asset
2 - Run Depreciation Calculation
3 – Create accounting entries and close depreciation
4 – Executing the Asset Allocation - Am- Accounting entries- allocate depr expense- asset allocations
5 – Error in the execution in the process of Allocate Assets - Am- Accounting entries > process allocation


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.