My Oracle Support Banner

AR9.2: ARUPDATE ABENDED At Step AR_POSTING.UPD_COLL.Step01 (Doc ID 2764791.1)

Last updated on OCTOBER 25, 2021

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run ARUPDATE, the following error occurs:

ARUPDATE ABENDED at Step AR_POSTING.UPD_COLL.Step01 (SQL):

-- 2021-06-09 16:27:01.964 Process 2410077 ABENDED at Step AR_POSTING.UPD_COLL.Step01 (Action SQL) -- RC = 8601
ROLLBACK
/
-- 2021-06-09 16:27:02.719 SQL Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'COLLECTOR', table 'FISBX.dbo.PS_RP_PNDITM_TAO4'; column does not allow nulls. UPDATE fails.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statemen÷


Replication Steps:

1. Create an Item that has more than 1 Item Activity;
2. Create a Maintenance Worksheet and Write-off the Item Balance;
3. Submit the Worksheet to the Workflow when necessary;
4. Change the Worksheet Status to Batch Standard and run the AR_UPDATE;
5. The AR_UPDATE will run No Success.
 

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.