Financial Management - PSFT (MOSC)

MOSC Banner

Question on Archiving PS_PENDING_DST table

in Financial Management - PSFT (MOSC) 2 commentsAnswered ✓

Hi,

We are working on to archive the PS FIN core tables. Part of this, we are looking to archive PS_PENDING_DST table which is one of high volume table (300M+ rows). However run into dilemma with the delivered archive query critieria which includes like GROUP_TYPE <> 'P'. We are looking to archive any transaction older than year 2012 only. But adding this GROUP_TYPE <> 'P' criteria excludes pretty much 80% transactions. Wondering why this criteria included and if this will have any impact if we exclude GROUP_TYPE <> 'P' criteria. Appreciate if someone could provide some insight on this. So accordingly

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

PSFT Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center