Performance With PC_TL_TO_PC At Step PC_TL_TO_PC.DEL_EST.RES_DEL (Doc ID 2215700.1)

Last updated on DECEMBER 19, 2016

Applies to:

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

Symptoms

Performance with PC_TL_TO_PC
It get stuck at Step PC_TL_TO_PC.DEL_EST.RES_DEL

INSERT INTO PS_PROJ_RES_DEL (PROCESS_INSTANCE, BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, RESOURCE_ID, RESOURCE_ID_FROM, BUSINESS_UNIT_GL, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ, JOURNAL_LINE, FISCAL_YEAR, ACCOUNTING_PERIOD, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUS_UNIT_GL_FROM, CURRENCY_CD, STATISTICS_CODE, LEDGER_GROUP, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, RES_USER1, RES_USER2, RES_USER3, RES_USER4, RES_USER5, TRANS_DT, ACCOUNTING_DT, OPRID, DTTM_STAMP, JRNL_LN_REF, OPEN_ITEM_STATUS, LINE_DESCR, JRNL_LINE_STATUS, JOURNAL_LINE_DATE, FOREIGN_CURRENCY, RT_TYPE, FOREIGN_AMOUNT, RATE_MULT, RATE_DIV, CUR_EFFDT, PC_DISTRIB_STATUS, GL_DISTRIB_STATUS, PROJ_TRANS_TYPE, PROJ_TRANS_CODE, RESOURCE_STATUS, DESCR, SYSTEM_SOURCE, UNIT_OF_MEASURE, EMPLID, EMPL_RCD, SEQ_NBR, TIME_RPTG_CD, JOBCODE, COMPANY, BUSINESS_UNIT_AP, VENDOR_ID, VOUCHER_ID, VOUCHER_LINE_NUM, APPL_JRNL_ID, PYMNT_CNT, DST_ACCT_TYPE, PO_DISTRIB_STATUS, BUSINESS_UNIT_PO, REQ_ID, REQ_LINE_NBR, REQ_SCHED_NBR, REQ_DISTRIB_NBR, PO_ID, DUE_DATE, LINE_NBR, SCHED_NBR, DISTRIB_LINE_NUM, AM_DISTRIB_STATUS, BUSINESS_UNIT_AM, ASSET_ID, PROFILE_ID, COST_TYPE, BOOK, INCENTIVE_ID, MSTONE_SEQ, CONTRACT_NUM, CONTRACT_LINE_NUM, CONTRACT_PPD_SEQ, BI_DISTRIB_STATUS, BUSINESS_UNIT_BI, BILLING_DATE, INVOICE, REV_DISTRIB_STATUS, BUSINESS_UNIT_AR, CUST_ID, ITEM, ITEM_LINE, ITEM_SEQ_NUM, DST_SEQ_NUM, BUSINESS_UNIT_IN, SCHED_LINE_NO, DEMAND_LINE_NO, INV_ITEM_ID, PAY_END_DT, BUSINESS_UNIT_OM, ORDER_NO, ORDER_INT_LINE_NO, EX_DOC_ID, EX_DOC_TYPE, RESOURCE_QUANTITY, RESOURCE_AMOUNT, BUDGET_HDR_STATUS, KK_AMOUNT_TYPE, KK_TRAN_OVER_FLAG, KK_TRAN_OVER_OPRID, KK_TRAN_OVER_DTTM, BUDGET_OVER_ALLOW, BUDGET_LINE_STATUS, BUDGET_DT, LEDGER, BD_DISTRIB_STATUS, BUSINESS_UNIT_BD, FA_STATUS, TIME_SHEET_ID, SHEET_ID, DT_TIMESTAMP, VCHR_DIST_LINE_NUM, PM_REVIEWED, PRICED_RATE, ACTIVITY_ID_DETAIL, CST_DISTRIB_STATUS, TXN_LMT_TRANS_ID, EVENT_NUM, CA_FEE_STATUS, BUSINESS_UNIT_WO, WO_ID, WO_TASK_ID, RSRC_TYPE, RES_LN_NBR, COMPRESS_ID, AMOUNT_IN_EXCESS, RECLAIMED_FROM_OL, FND_DIST_STATUS, SEQ_TRANS_ID, DIST_TRANS_ID, ADJ_LINE_TYPE, FEEDER_SUM_ID, PRICE_SUM_ID, DEPOSIT_BU, DEPOSIT_ID, PAYMENT_SEQ_NUM) SELECT 1258840, B.BUSINESS_UNIT, B.PROJECT_ID, B.ACTIVITY_ID, B.RESOURCE_ID, B.RESOURCE_ID_FROM, B.BUSINESS_UNIT_GL, B.JOURNAL_ID, B.JOURNAL_DATE, B.UNPOST_SEQ, B.JOURNAL_LINE, B.FISCAL_YEAR, B.ACCOUNTING_PERIOD, B.ACCOUNT, B.ALTACCT, B.DEPTID, B.OPERATING_UNIT, B.PRODUCT, B.FUND_CODE, B.CLASS_FLD, B.PROGRAM_CODE, B.BUDGET_REF, B.AFFILIATE, B.AFFILIATE_INTRA1, B.AFFILIATE_INTRA2, B.CHARTFIELD1, B.CHARTFIELD2, B.CHARTFIELD3, B.BUS_UNIT_GL_FROM, B.CURRENCY_CD, B.STATISTICS_CODE, B.LEDGER_GROUP, B.ANALYSIS_TYPE, B.RESOURCE_TYPE, B.RESOURCE_CATEGORY, B.RESOURCE_SUB_CAT, B.RES_USER1, B.RES_USER2, B.RES_USER3, B.RES_USER4, B.RES_USER5, B.TRANS_DT, B.ACCOUNTING_DT, B.OPRID, B.DTTM_STAMP, B.JRNL_LN_REF, B.OPEN_ITEM_STATUS, B.LINE_DESCR, B.JRNL_LINE_STATUS, B.JOURNAL_LINE_DATE, B.FOREIGN_CURRENCY, B.RT_TYPE, B.FOREIGN_AMOUNT, B.RATE_MULT, B.RATE_DIV, B.CUR_EFFDT, B.PC_DISTRIB_STATUS, B.GL_DISTRIB_STATUS, B.PROJ_TRANS_TYPE, B.PROJ_TRANS_CODE, B.RESOURCE_STATUS, B.DESCR, B.SYSTEM_SOURCE, B.UNIT_OF_MEASURE, B.EMPLID, B.EMPL_RCD, B.SEQ_NBR, B.TIME_RPTG_CD, B.JOBCODE, B.COMPANY, B.BUSINESS_UNIT_AP, B.VENDOR_ID, B.VOUCHER_ID, B.VOUCHER_LINE_NUM, B.APPL_JRNL_ID, B.PYMNT_CNT, B.DST_ACCT_TYPE, B.PO_DISTRIB_STATUS, B.BUSINESS_UNIT_PO, B.REQ_ID, B.REQ_LINE_NBR, B.REQ_SCHED_NBR, B.REQ_DISTRIB_NBR, B.PO_ID, B.DUE_DATE, B.LINE_NBR, B.SCHED_NBR, B.DISTRIB_LINE_NUM, B.AM_DISTRIB_STATUS, B.BUSINESS_UNIT_AM, B.ASSET_ID, B.PROFILE_ID, B.COST_TYPE, B.BOOK, B.INCENTIVE_ID, B.MSTONE_SEQ, B.CONTRACT_NUM, B.CONTRACT_LINE_NUM, B.CONTRACT_PPD_SEQ, B.BI_DISTRIB_STATUS, B.BUSINESS_UNIT_BI, B.BILLING_DATE, B.INVOICE, B.REV_DISTRIB_STATUS, B.BUSINESS_UNIT_AR, B.CUST_ID, B.ITEM, B.ITEM_LINE, B.ITEM_SEQ_NUM, B.DST_SEQ_NUM, B.BUSINESS_UNIT_IN, B.SCHED_LINE_NO, B.DEMAND_LINE_NO, B.INV_ITEM_ID, B.PAY_END_DT, B.BUSINESS_UNIT_OM, B.ORDER_NO, B.ORDER_INT_LINE_NO, B.EX_DOC_ID, B.EX_DOC_TYPE, ((RESOURCE_QUANTITY) * ( -1)), ((RESOURCE_AMOUNT) * ( -1)), B.BUDGET_HDR_STATUS, B.KK_AMOUNT_TYPE, B.KK_TRAN_OVER_FLAG, B.KK_TRAN_OVER_OPRID, B.KK_TRAN_OVER_DTTM, B.BUDGET_OVER_ALLOW, B.BUDGET_LINE_STATUS, B.BUDGET_DT, B.LEDGER, B.BD_DISTRIB_STATUS, B.BUSINESS_UNIT_BD, B.FA_STATUS, B.TIME_SHEET_ID, B.SHEET_ID, B.DT_TIMESTAMP, B.VCHR_DIST_LINE_NUM, B.PM_REVIEWED, B.PRICED_RATE, B.ACTIVITY_ID_DETAIL, B.CST_DISTRIB_STATUS, B.TXN_LMT_TRANS_ID, B.EVENT_NUM, B.CA_FEE_STATUS, B.BUSINESS_UNIT_WO, B.WO_ID, B.WO_TASK_ID, B.RSRC_TYPE, B.RES_LN_NBR, B.COMPRESS_ID, B.AMOUNT_IN_EXCESS, B.RECLAIMED_FROM_OL, B.FND_DIST_STATUS, B.SEQ_TRANS_ID, B.DIST_TRANS_ID, B.ADJ_LINE_TYPE, B.FEEDER_SUM_ID, B.PRICE_SUM_ID, B.DEPOSIT_BU, B.DEPOSIT_ID, B.PAYMENT_SEQ_NUM FROM PS_PC_TLB_BAL_TAO B WHERE (B.PROCESS_INSTANCE = 1258840 AND ANALYSIS_TYPE = 'TLA') OR EXISTS ( SELECT 'X' FROM PS_PC_TLB_BAL_TAO A WHERE A.PROCESS_INSTANCE = 1258840 AND B.PROCESS_INSTANCE = 1258840 AND (( A.RESOURCE_ID = B.RESOURCE_ID AND A.BI_DISTRIB_STATUS IN ('N','I','U') AND A.ASSET_ID = ' ' AND A.AM_DISTRIB_STATUS <> 'D' AND A.CA_FEE_STATUS = ' ') OR (A.RESOURCE_ID = B.RESOURCE_ID AND A.BI_DISTRIB_STATUS IN ('P','C') AND A.GL_DISTRIB_STATUS IN ('C', 'N') AND A.SYSTEM_SOURCE IN ('PRP','PRR', 'PRC') AND A.ASSET_ID = ' ' AND A.AM_DISTRIB_STATUS <> 'D' AND A.CA_FEE_STATUS = ' ' ) OR (B.RESOURCE_ID = A.RESOURCE_ID_FROM AND A.SYSTEM_SOURCE IN ('PRP','PRR', 'PRC') AND A.BI_DISTRIB_STATUS IN ('P','C','N') AND A.GL_DISTRIB_STATUS IN ('C', 'N') AND A.ASSET_ID = ' ' AND A.AM_DISTRIB_STATUS <> 'D' AND A.CA_FEE_STATUS = ' ')))

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