My Oracle Support Banner

ECM: Treasury Accounting Process, TR_ACCTG, Fails Due to "cannot insert NULL into PS_TRA_ACCTG_LINE.MC_AMOUNT_SW" Error at Step TR_ACCTG.TRV1210.INSERT (Doc ID 2615529.1)

Last updated on NOVEMBER 28, 2019

Applies to:

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

Symptoms

Treasury Accounting process, TR_ACCTG, is failing.

Steps:

1) Create a VAT applicable Letter of Credit.
2) Push the payment using Financial Gateway
3) Run Treasury Accounting process, TR_ACCTG.

Error:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_TRA_ACCTG_LINE"."MC_AMOUNT_SW")
Failed SQL stmt: INSERT INTO PS_TRA_ACCTG_LINE (BUSINESS_UNIT , ACCOUNTING_ID , ACCOUNTING_LINE , ACCOUNTING_DT , ACCOUNT , ALTACCT , DEPTID , PROJECT_ID , STATISTICS_CODE , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , FOREIGN_AMOUNT , FOREIGN_CURRENCY , RT_TYPE , MONETARY_AMOUNT , CURRENCY_CD , STATISTIC_AMOUNT , JRNL_LN_REF , DESCR60 , LINE_DESCR , ACCOUNTING_PERIOD , FISCAL_YEAR , BUSINESS_UNIT_GL , LEDGER , LEDGER_GROUP , JOURNAL_ID , GL_DISTRIB_STATUS , COMBO_STATUS , APPL_JRNL_ID , RATE_MULT , RATE_DIV , JOURNAL_LINE , PROCESS_INSTANCE , IU_ANCHOR_FLG , IU_SYS_TRAN_CD , IU_TRAN_CD , ACCTG_LINE_SOURCE , AMOUNT_CALC_TYPE ,DOC_TYPE ,DOC_SEQ_NBR ,DOC_SEQ_DATE ,DOC_SEQ_STATUS ) SELECT 'XXXXX' , '0022502544' , 3 , TO_DATE('2019-07-26','YYYY-MM-DD') , '1120901' , ' ' , ' ' , ' ' , ' ' , ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ' , 1350000 , 'INR' , 'CRRNT' , 1350000 , 'INR' , 0 , ' ' , ' ' , ' ' , 0 , 0 , 'XXXXX' , 'LOCAL' , 'ACTUALS' , ' ' , 'N' , 'V' , 'TR_ENTRIES' , 1 , 1 , 0 , 21589660 , 'N' , 'TRFEE' , 'TR' , 'TRA' , ' ' ,'TR-JG' ,' ' ,NULL ,' ' FROM PS_INSTALLATION

Process 21589660 ABENDED at Step TR_ACCTG.TRV1210.INSERT (SQL) -- RC = 1400 (108,524)

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.