Financial Management - PSFT (MOSC)

MOSC Banner

Inquiry on Inserting Rows for Parent and Record Tables

edited Jul 8, 2013 8:00PM in Financial Management - PSFT (MOSC) 4 commentsAnswered
Hi,
I was creating an insert script to copy journal entries from the ADJUSTMENT ledger to the ACTUALS ledger. What I did was use an INSERT INTO SELECT format of the script so that I could directly copy the journal entries. I created insert scripts for PS_JRNL_HEADER, PS_JRNL_LN and PS_JRNL_CF_BAL_TBL. I placed these three scripts in one file. While I was running the file, the insert was successful in PS_JRNL_HEADER, but I encountered unique constraint errors in PS_JRNL_LN. When I checked backend, the journal line entries from the ADJUSTMENT ledger were already copied to the ACTUALS ledger in PS_JRNL_LN and PS_JRNL_CF_BAL_TBL.

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