Budget Checking Journals
I'm planning to budget check a large number of historical journals—8,000 journals with a total of 65,000 lines. Is there any risk that using the batch editing process for these journals might impact the system or App Engine?
These journals are historical, and we're adding activity IDs to G projects to ensure they populate in KK ledgers. Here's the process we're following:
UPDATE PS_JRNL_HEADER
SET JRNL_HDR_STATUS = 'N', BUDGET_HDR_STATUS = 'N', KK_SKIP = '0'
WHERE (JOURNAL_ID || '-' || JOURNAL_DATE) IN ('XXXXXXXXXX');
UPDATE PS_JRNL_LN
SET ACTIVITY_ID = '1', BUSINESS_UNIT_PC = 'SMETH'
WHERE (JOURNAL_ID || '-' || JOURNAL_DATE) IN ('XXXXXXXXXX')