Search This Blog

Sunday, December 30, 2012

Delete Option from Plan on Test Instance before Go Live - Oracle Advanced Benefits(OAB)


select * from ben_prtt_enrt_rslt_f where oipl_id = 9002
select * from per_all_people_f where person_id = 1497
select * from ben_oipl_f where oipl_id = 9002
select * from ben_opt_f where opt_id = 9003
delete from ben_prtt_enrt_rslt_f where oipl_id = 9002

select * from ben_elig_per_elctbl_chc where oipl_id = 9002
delete from ben_elig_per_elctbl_chc where oipl_id = 9002

Note - This is for my future reference. Oracle does not recommend it.

No comments:

Post a Comment