Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Why does PC_INTFEDIT app engine have a hard coded range of interfaces excluded from deletion?

edited Dec 31, 2019 1:43PM in Enterprise Service Automation (ESA) - PSFT (MOSC) 6 commentsAnswered

PC_INTFEDIT has hard coded exclusion range of completed interfaces between 10000000 and 10999999 being deleted from INTFC_PROJ_RES.  Over time this will cause this table to contain an enormous amount of data.  Is this going to cause performance issues with loading future interfaces down the road?  Can there be a configuration created in future images that gives you the functionality to say how many interfaces you want to keep (keep last 10 interfaces, etc) without having to update the range in the program.

Financials/SCM 9.20.30.000

Tagged:

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