Dear Pak Fahmi, Terima kasih masukannya.. Saya akan coba pelajari dulu.. Bagi yg ada documentasinya mohon share ya...
Regards, Wisnu. ________________________________ From: Fahmi <[email protected]> To: [email protected] Sent: Tue, August 17, 2010 7:34:41 AM Subject: Re: [indo-oracle] purge data lama di EBS11i Pak Wisnu, untuk purging data di EBS, masing-masing modul memilikinya (Misal : INV --> Transaction Purge, AP-PO Purge). Namun ada beberapa pertimbangan yang perlu dilakukan sebelum dilakukan purging. 1. Apakah datanya sudah tidak dipakai lagi sehingga bisa langsung di purge? 2. Jika sudah tidak dipakai, apakah user masih perlu mengaksesnya suatu saat? 3. Jika user tidak perlu mengakses, apakah ada regulasi pemerintah yang membuat data tersebut harus di keep sekian tahun (utk pajak biasanya). 4. Sebelum dilakukan purging, jangan lupa backup offline dan purging programnya bisa diakses dari masing2 modul super user (PO Super User, INV Super User dsb). Jika no 2 & 3 menjadi pertimbangan, maka ILM bisa menjadi solusinya. Namun jika yang dimaksud purging data history request/log/sign on dsb, bisa masuk ke responsibility sysadmin. Dan mungkin pak wisnu sudah rutin melakukannya. Regards, Fahmi Fahlevi 2010/8/16 wisnu dwi hidayat <[email protected]> > > > dear pak defri, > > aku coba query nya ada error > > SQL> select count(*) > > 2 from fnd_concurrent_requests fcr, > 3 fnd_concurrent_programs_vl fcpv > 4 where fcr.concurrent_program_id=fcpv.concurrent_program_id > 5 and fcpv.user_concurrent_program_name in ('Cost Manager', 'Manager: Lot > Move > 6 Transactions', 'Process transaction interface', 'WIP Move Transaction > Manager') > 7 and to_char(fcr.transaction_date,'MMRRRR') > '122007' > 8 ; > > fnd_concurrent_programs_vl fcpv > * > ERROR at line 3: > ORA-00942: table or view does not exist > > regards, > > wisnu > > ________________________________ > From: defri afrian <[email protected] <def_rian80%40yahoo.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Mon, August 16, 2010 4:23:13 PM > > Subject: Re: [indo-oracle] purge data lama di EBS11i > > Jalankan query ini : > > select count(*) > from fnd_concurrent_requests fcr, > fnd_concurrent_programs_vl fcpv > where fcr.concurrent_program_id=fcpv.concurrent_program_id > and fcpv.user_concurrent_program_name in ('Cost Manager', 'Manager: Lot > Move > Transactions', 'Process transaction interface', 'WIP Move Transaction > Manager') > and to_char(fcr.transaction_date,'MMRRRR') > '122007' > > Cek jumlah dari hasil query di atas. Jika jumlahnya 40, maka kolom age pada > > parameter requestPurge Concurrent Requests And/Or Manager anda isikan 40. > Dan > jalankan request ini sekali saja (tidak perlu di schedule secara periodik). > Data request yang aka di hapus adalah yang transaction_date <= '122007' > > Regards, > Defry > > ________________________________ > From: wisnu dwi hidayat <[email protected] <wisnu_dh%40yahoo.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Mon, August 16, 2010 4:00:39 PM > Subject: Re: [indo-oracle] purge data lama di EBS11i > > kalo Purge Concurrent Requests And/Or Manager Data sudah saya lakukan > seperti yg > > pak defri beritahu.. > tapi yg saya tanyakan adlah.. menghapus data lama, data yg lama (December > 2007-kebawah) dibuang.. > > saya baru di AppsDBA.. gmana ya si boss minta kaya gitu.. > > Mohon bantuannya.. > > Wisnu > > ________________________________ > From: defri afrian <[email protected] <def_rian80%40yahoo.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Mon, August 16, 2010 3:47:14 PM > Subject: Re: [indo-oracle] purge data lama di EBS11i > > Dear Wisnu, > > Masuk ke responsibility system administrator, running request purging > request > (buat secara schedulling / periodik) > Pilih all, dan pada kolom age masukkan jumlah request yang akan tetap > tersimpan > dalam server. > > Misal : jika kolom age anda isi 30, artinya request selama 30 hari terakhir > > sampai dengan sekarang akan tetap tersimpan di server. Sisanya akan > terhapus > pada saat request purge pada oracle EBS statusnya complete normal. > > Regards, > Defry > > ________________________________ > From: wisnu dwi hidayat <[email protected] <wisnu_dh%40yahoo.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Mon, August 16, 2010 3:35:16 PM > Subject: [indo-oracle] purge data lama di EBS11i > > Dear All, > > Ada yg pernah lakukan purge buat data yg udah lama ga ?? > Misal data yg lama (December 2007-kebawah) dibuang ?? > Tapi menggunakan EBS 11i ... Mohon bantuannya.. > > Regards, > > Wisnu > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links [Non-text portions of this message have been removed]
