Dear Wisnu,
Saya menggunakan start date untuk kondisi request aplikasi EBS Anda pada periode desember 2007 sudah tidak ada lagi yang di eksekusi pada periode januari 2008 (tidak ada schedule job untuk purging request) Namun jika Anda melakukan purging request secara sheduling periodik, maka sebaiknya menggunakan actual_completion_date. Hasil count / jumlah dari query tersebut yang nantinya di gunakan sebagai acuan parameter age pada request purging. Regards, Defry ________________________________ From: wisnu dwi hidayat <[email protected]> To: [email protected] Sent: Wed, August 18, 2010 9:43:25 AM Subject: Re: [indo-oracle] purge data lama di EBS11i Dear Pak Defry. Query sudah bisa di jalankan SQL> conn apps/apps Connected. 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.requested_start_date,'MMRRRR') > '122007' 8 ; COUNT(*) ---------- 4096 tapi knapa pakai start_date bukan end_date ?? dan hasilnya kok 4096, apa mungkin ini saya masukkan di age nya ?? mohon pencerahannya pak.. Regards, Wisnu ________________________________ From: defri afrian <[email protected]> To: [email protected] Sent: Wed, August 18, 2010 8:48:48 AM Subject: Re: [indo-oracle] purge data lama di EBS11i Dear Wisnu, Kolom transaction_date Anda ganti dengan requested_start_date Regards, Defry ________________________________ From: wisnu dwi hidayat <[email protected]> To: [email protected] Sent: Wed, August 18, 2010 8:38:19 AM Subject: Re: [indo-oracle] purge data lama di EBS11i Dear Pak Defry, Saya sudah menggunakan user apps tapi ada error seperti berikut; SQL> conn apps/******** Connected. 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'; and to_char(fcr.transaction_date,'MMRRRR') > '122007' * ERROR at line 7: ORA-00904: "FCR"."TRANSACTION_DATE": invalid identifier Regards, Wisnu ________________________________ From: defri afrian <[email protected]> To: [email protected] Sent: Wed, August 18, 2010 8:26:08 AM Subject: Re: [indo-oracle] purge data lama di EBS11i 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] [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]
