Dear Wisnu,
Query yang Saya berikan harusnya bisa karena biasanya Saya gunakan query tersebut untuk analisa concurrent request. Anda harus login sebagai user apps atau system untuk execute query tersebut. Regards, Defry ________________________________ From: wisnu dwi hidayat <[email protected]> To: [email protected] Sent: Mon, August 16, 2010 4:59:33 PM Subject: Re: [indo-oracle] purge data lama di EBS11i 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]> To: [email protected] 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]> To: [email protected] 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]> To: [email protected] 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]> To: [email protected] 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]
