My Oracle Support Banner

EBI9.2: Credit Cards Failing When BICRC000 Application Engine Runs (Doc ID 2377520.1)

Last updated on MARCH 22, 2018

Applies to:

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

Symptoms

When attempting to run BICRC000, the following error occurs.

ERROR
-----------
BICRC000 Started. (12600,37)

Value 1 = SUCCESS. (39999,1)
Value 2 = The transaction was successful.. (39999,1)
Value 3 = The transaction was successful.. (39999,1)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_CRCARD_PAYMENT"."SHORT_PAY_REASON")
Failed SQL stmt: INSERT INTO PS_CRCARD_PAYMENT (BUSINESS_UNIT ,CUST_ID ,ITEM ,ITEM_LINE ,HIST_SEQ ,CURRENCY_CD ,AMOUNT ,PROCESS_STATUS ,PROCESS_INSTANCE ,DEPOSIT_BU ,DEPOSIT_ID ,PAYMENT_SEQ_NUM) VALUES (:1 ,:2 ,:3 ,0 ,:4 ,:5 ,:6 ,'N' ,0 ,' ' ,' ' ,0)

Process ABENDED at Step BICRC000.INSPMNT.INSPMNT (SQL) -- RC = 1400 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 09.18.18 2017-10-31


STEPS
----------
The issue can be reproduced at will with the following steps:

  1. Run BICRC000 process under Billing > Generate Invoices > Process Credit cards > Request Credit Card processing.

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