E-Business Tax (MOSC)

MOSC Banner

Reducing your Oracle EBS Data Footprint

in E-Business Tax (MOSC) Question

Reducing your Oracle E-Business Suite Data Footprint

We Started in 2003 with 11.5.8 and did some upgrades during the time and 2017 we went to 12.2.6. Since then the EBS DB is growing very quickly.

Top 10 Tables are AR, ZX, INV and GL tables. and they grow very fast.

SLA (xla) and EB-TAX combinated with AR and GL is the trigger to this i guess.

I must ask, is there any way to get this under control. In 11i we did not have this growth rate.

just

ZX_LINES_DET_FACTORS

ZX_LINES

are  175 Gb in Size

and

RA_CUSTOMER_TRX_LINES_ALL

RA_CUST_TRX_LINE_GL_DIST_ALL

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

EBS Tax 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