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

Last updated on APRIL 12, 2016

Applies to:

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

Symptoms

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:

Error:
-- 13:28:44.852 Process 11125 ABENDED at Step AMALLOC.UPDDIST.Step01A (Action SQL) -- RC = 1400
ROLLBACK
/
-- 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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms