Payables and Cash Management - EBS (MOSC)

MOSC Banner

CE_STMT_INT_TMP - Intermediate table - OK for multiple concurrent statement processing

edited Aug 20, 2021 8:46AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

Hi All

My team are uncertain whether the bank statement interface process is meant to handle multiple bank statement interfaces at a time.

We see that there is a SQL loader routine that fills CE_STMT_INT_TMP from the bank flat file and then a 'Load Bank Statement Data' that applies the map and then fills the ORG_ID striped Interface tables.

But will multiple submissoins of the loader processes start to conflict with each others use of ce_stmt_int_tmp ... ie. delete rows just added by the previous process ... that's still running.

I feel sure that there must be some kind of table lock protection going on ?

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