Financial Management - PSFT (MOSC)

MOSC Banner

Budget Checking Journals

edited Aug 29, 2024 6:21PM in Financial Management - PSFT (MOSC) 6 commentsAnswered

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center