Financial Management - PSFT (MOSC)

MOSC Banner

Extracting manually entered journals from Production into Test Environment.

edited Jul 28, 2013 8:27PM in Financial Management - PSFT (MOSC) 8 commentsAnswered ✓
There were 350 manually entered journals in Production and they are in POSTED status.

I will have to move these journals from Production into our test environment and POST them again in the test environement.

To achieve this, i thought of manually moving the data from the 4 tables: JRNL_HEADER, JRNL_HEADER_IU, JRNL_LN, JRNL_CF_BAL_TBL into the test environement and then re-set some flags/statuses on these tables so that they can be POSTED again in our test environment. Anyone tried this method? Are there any drawbacks with this method? I think that it is the simplest way to achieve my goal. Any comments?

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

PSFT Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center