FS_BP_CKBUD.BDEXISTS.EXISTS (SQL) RC = 942 (108,524) TABLE OR VIEW DOES NOT EXIST
(Doc ID 973780.1)
Last updated on DECEMBER 12, 2019
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
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 |