Inquiry on Inserting Rows for Parent and Record Tables
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.
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.
0