FS_BP_CKBUD.BDEXISTS.EXISTS (SQL) RC = 942 (108,524) TABLE OR VIEW DOES NOT EXIST (Doc ID 973780.1)

Last updated on JUNE 15, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.
*** checked for relevance 15-JUN-2017 ***

Symptoms

1. Why are we getting the below FS_BP budget checking process abend?

"FS_BP_CKBUD.BdExists.Exists (SQL) RC = 942 (108,524) table or view does not exist"

Also, why is the table 'B' blank in the failed SQL statement below?

Failed SQL stmt:SELECT 'Y' FROM PS_LED_GRP_LED_TBL A , PS_ B WHERE A.SETID= :1 AND A.LEDGER_GROUP= :2 AND A.LEDGER_TYPE_KK='0' AND B.BUSINESS_UNIT= :3 AND B.LEDGER=A.LEDGER AND B.CURRENCY_CD= :4 AND B.STATISTICS_CODE= :5 AND B.ACCOUNT= :6 AND B.DEPTID= :7 AND B.BUDGET_PERIOD = :8 AND B.OPERATING_UNIT = :9 AND B.PRODUCT = :10 AND B.FUND_CODE = :11 AND B.CLASS_FLD = :12 AND B.PROGRAM_CODE = :13 AND B.BUDGET_REF = :14 AND B.AFFILIATE = :15 AND B.AFFILIATE_INTRA1 = :16 AND B.AFFILIATE_INTRA2 = :17 AND B.CHARTFIELD1 = :18 AND B.CHARTFIELD2 = :19 AND B.CHARTFIELD3 = :20 AND B.BUSINESS_UNIT_PC = :21 AND B.PROJECT_ID = :22 AND B.ACTIVITY_ID = :23 AND B.RESOURCE_TYPE = :24


2. When is it ok to 'turn off' a budget ledger group assigned to a GL BU via the Ledgers for A Unit, Commitment Control Options page?

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