EGL: Allocation Request Fails With The Subtract And Range Of Values (Doc ID 2095956.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Allocations

Allocation request fails with the subtract and range of values

ERROR
-----------------------
Processing Step VHS_SUB in Group VIDANT for Business Unit US001. (5810,33)

File: ................SQL error. Stmt #: 1620 Error Position: 986 Return: 933 - ORA-00933: SQL command not properly ended
Failed SQL stmt:INSERT INTO PS_ALC_GL_P_TAO4 (BUSINESS_UNIT, LEDGER, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, BUDGET_PERIOD, SCENARIO, BOOK_CODE, GL_ADJUST_TYPE, CURRENCY_CD, STATISTICS_CODE, FISCAL_YEAR, ACCOUNTING_PERIOD, POSTED_TOTAL_AMT, POSTED_BASE_AMT, POSTED_TRAN_AMT, BASE_CURRENCY, FOREIGN_CURRENCY, MONETARY_AMOUNT, FOREIGN_AMOUNT, STATISTIC_AMOUNT, JRNL_LN_REF, JOURNAL_ID, DTTM_STAMP_SEC, PROCESS_INSTANCE) SELECT BUL.BUSINESS_UNIT, BUL.LEDGER, B.ACCOUNT, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', BUL.BASE_CURRENCY, ' ', 0, 0, 0, 0, 0, BUL.BASE_CURRENCY_LED, ' ', 0, 0, 0, ' ', ' ', NULL, 12641 FROM PS_GL_ACCOUNT_TBL B, PS_SET_CNTRL_REC SB, PS_ALC_BULED_TAO4 BUL WHERE (B.ACCOUNT >= '620000' AND B.ACCOUNT <= '621200')B.EFFDT = (SELECT MAX(X.EFFDT) FROM PS_GL_ACCOUNT_TBL X WHERE X.SETID = B.SETID AND X.ACCOUNT = B.ACCOUNT)B.SETID = SB.SETID AND SB.SETCNTRLVALUE = BUL.BUSINESS_UNIT AND SB.RECNAME = 'GL_ACCOUNT_TBL' AND BUL.PROCESS_INSTANCE = 12641 AND NOT EXISTS ( SELECT 'X' FROM PS_LEDGER A WHERE FISCAL_YEAR = 2004 AND (ACCOUNTING_PERIOD IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)) AND (CURRENCY_CD = BASE_CURRENCY AND CURRENCY_CD <> ' ' AND BASE_CURRENCY <> ' ') AND A.ACCOUNT = B.ACCOUNT AND A.BUSINESS_UNIT = BUL.BUSINESS_UNIT AND A.LEDGER = BUL.LEDGER )

Process 12641 ABENDED at Step FS_ALLC_POOL.iNRZero.iPool (SQL) -- RC = 933 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create allocation step type 'Arithmetic Operation'.
2. Run 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