Financial Management - PSFT (MOSC)

MOSC Banner

Run Data Conversion AE - DCTR25180418 running 15hrs +, Please help and suggest on the same

1) We are doing PUM Update from PUM 5 TO 35.

2) As part of the Image update Change Package (MTP) There is step (Run Data Conversion AE - DCTR25180418 )

3) As part of Data Conversion AE - DCTR25180418 , Below is the update Sql which is running more than 20+hrs


Run Data Conversion AE - DCTR25180418

======================================

UPDATE PS_BANK_STMT_TBL SET TRAN_LINE = 1 + ( SELECT COUNT(1) FR

OM PS_BANK_STMT_TBL B WHERE B.BNK_ID_NBR = PS_BANK_STMT_TBL.BNK_

ID_NBR AND B.BANK_ACCOUNT_NUM = PS_BANK_STMT_TBL.BANK_ACCOUNT_NU

M AND B.RECON_CYCLE_NBR = PS_BANK_STMT_TBL.RECON_CYCLE_NBR AND B

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