EAR9.2: ARUPDATE ABENDS AT AR_PGG_SERV.SEQ_NUM.INSCFINH (Doc ID 1644951.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, AR Update - Posting

ARUPDATE ABENDS AT AR_PGG_SERV.SEQ_NUM.INSCFINH

ISSUE: Items coming from Billing fail when ARUPDATE processes at step AR_PGG_SERV.SEQ_NUM.INSCFINH

ERROR
-----------------------

-- 21.00.51 Process 21407 ABENDED at Step AR_PGG_SERV.SEQ_NUM.INSCFINH (Action SQL) -- RC = 947
ROLLBACK
/
-- 21.00.51 SQL Error: ORA-00947: not enough values




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Process invoice from Billing in Single Action job
2. Run ARUPDATE


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot post AR items or activities

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