Purge and Delete Obsolete Information of the EBS R12.1

in ; Hi friends; Someone of you could tell me what are the processes of deleting and purging of obsolete information that ...
+ Post Reply + Post New Topic
Results 1 to 7 of 7
  1. #1
    tomloera's Avatar
    tomloera is offline Forum Expert
    Points: 4,260, Level: 41
    Join Date
    12 Feb 2011
    Location
    Monterrey Mexico
    Posts
    156
    Points
    4,260

    Purge and Delete Obsolete Information of the EBS R12.1

    Hi friends;

    Someone of you could tell me what are the processes of deleting and purging of obsolete information that must run on the EBS R12.1

    Thanks a lot of your help

    Regards
    Tom


  2. #2
    apps_expert's Avatar
    apps_expert is offline Forum Expert
    Points: 4,110, Level: 40
    Join Date
    20 Dec 2008
    Location
    Chennai, India
    Posts
    325
    Points
    4,110

    Re: Purge and Delete Obsolete Information of the EBS R12.1

    Quote Originally Posted by tomloera View Post
    Hi friends;

    Someone of you could tell me what are the processes of deleting and purging of obsolete information that must run on the EBS R12.1

    Thanks a lot of your help

    Regards
    Tom
    Hi Tom, what do you mean my "obsolete information"? Can you be more specific?

    Do you mean old concurrent request logs? Because historic transaction data is always relevant. And Moreover accounting principles dictate that a certain number of years data be kept in the live system and older than that archived. Generally in my experience, Database systems are backed up to archive old data.

  3. #3
    tomloera's Avatar
    tomloera is offline Forum Expert
    Points: 4,260, Level: 41
    Join Date
    12 Feb 2011
    Location
    Monterrey Mexico
    Posts
    156
    Points
    4,260

    Re: Purge and Delete Obsolete Information of the EBS R12.1

    Hi apps_expert;

    Well the "obsolete information" is about logs, estadistics, etc.

    For example.- And any documentation i found is necesary run the concurrent "Delete Data from Temporary Tables" but in my version (12.1) not found this concurrent.

    I dont now if is necessary run the next concurrents:

    Purge Concurrent Request and/or Manager Data
    Purge Signon Audit Data
    Purge Obsolete Workflow Runtime Data
    Purge Obsolete Generic File Manager
    Purge Debug Log
    Purge Messages
    Run estadistics

    If you can help me and what are the necessary procees for obtain a better performance of my instance, would greatly appreciate it.

    Regards
    Tom

  4. #4
    Sadik's Avatar
    Sadik is offline Administrator
    Points: 34,680, Level: 100
    Join Date
    03 Aug 2008
    Location
    Kolkata, India
    Posts
    1,855
    Points
    34,680

    Re: Purge and Delete Obsolete Information of the EBS R12.1

    Quote Originally Posted by tomloera View Post
    Hi apps_expert;

    Well the "obsolete information" is about logs, estadistics, etc.

    For example.- And any documentation i found is necesary run the concurrent "Delete Data from Temporary Tables" but in my version (12.1) not found this concurrent.

    I dont now if is necessary run the next concurrents:

    Purge Concurrent Request and/or Manager Data
    Purge Signon Audit Data
    Purge Obsolete Workflow Runtime Data
    Purge Obsolete Generic File Manager
    Purge Debug Log
    Purge Messages
    Run estadistics

    If you can help me and what are the necessary procees for obtain a better performance of my instance, would greatly appreciate it.

    Regards
    Tom
    Hi Tom,

    Whether or not you decide to Purge any of the above mentioned data is a matter of business policy. You can run all the requests that you mention and they will purge the data which they are meant to. It will not affect your day to day business transactions. However companies like to keep old Concurrent Request Data and Signon data for auditing purposes. Like I said, it's a matter of business policies and from a purely technical standpoint you can delete use all of these requests to free up whatever database space they are occupying.
    Learn Oracle with Oracle forum. Check out General Discussion Forums

  5. #5
    tomloera's Avatar
    tomloera is offline Forum Expert
    Points: 4,260, Level: 41
    Join Date
    12 Feb 2011
    Location
    Monterrey Mexico
    Posts
    156
    Points
    4,260

    Re: Purge and Delete Obsolete Information of the EBS R12.1

    Hi Sadik;

    Thanks of your comments, this is my firts six months with the system and need more experience.

    In the last two months the system is slower, what is necessary for have better performance in the system for run the concurrents, because the users reportiing to me when run the accounting of the modules of AP and AR each concurrent takes one hour or more for company and we have 8 companies.

    If you have any recommendations would be helpful to me

    Thanks a lot my friend
    Tom

  6. #6
    Sadik's Avatar
    Sadik is offline Administrator
    Points: 34,680, Level: 100
    Join Date
    03 Aug 2008
    Location
    Kolkata, India
    Posts
    1,855
    Points
    34,680

    Re: Purge and Delete Obsolete Information of the EBS R12.1

    Hi Tom,

    While I do not have any specific recommendations currently, you can read tips mentioned in these docs,

    http://documents.club-oracle.com/dow...do=file&id=277
    http://documents.club-oracle.com/dow...o=file&id=2210
    Learn Oracle with Oracle forum. Check out General Discussion Forums

  7. #7
    tomloera's Avatar
    tomloera is offline Forum Expert
    Points: 4,260, Level: 41
    Join Date
    12 Feb 2011
    Location
    Monterrey Mexico
    Posts
    156
    Points
    4,260

    Re: Purge and Delete Obsolete Information of the EBS R12.1

    Hi Sadik;

    Thanks a lot of your help
    Regards
    Tom



    Quote Originally Posted by Sadik View Post
    Hi Tom,

    While I do not have any specific recommendations currently, you can read tips mentioned in these docs,

    http://documents.club-oracle.com/dow...do=file&id=277
    http://documents.club-oracle.com/dow...o=file&id=2210

Other Solutions
  1. information regarding project accounting
    By roopalimba in forum Oracle Projects
    Replies: 1
    Last Post: 12-05-2013, 10:25 AM
  2. Historial AR Information
    By tomloera in forum Oracle Financials
    Replies: 0
    Last Post: 02-24-2011, 03:11 PM
  3. need OCA Exam information
    By laxman in forum Training and Certification
    Replies: 1
    Last Post: 10-29-2009, 04:08 AM
  4. oracle beginner information
    By abiodun ebunoluwa in forum Training and Certification
    Replies: 4
    Last Post: 08-20-2009, 04:03 AM
  5. Information on FND_MESSAGES
    By malli_18arjun in forum System Administration & Application DBA
    Replies: 2
    Last Post: 08-11-2009, 06:07 AM