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]
