SQL Developer Database Copy: I Really Like This Tool!

SQL Developer Database Copy

Recently, my team has been involved in a pretty detailed migration from a Development Instance to our QA instance prior to a final promotion to Production.  In the past, some of the team members were moving PL/SQL packages between instances by doing this:

  • Opening them up
  • Continue reading

    The Final Note – Kscope14

    music-notes-clip-artKScope14 was hosted in Seattle, the City of Music, and what an experience it was.  For six days, Oracle experts and professionals descended upon the City to share with and learn from each other.  We kicked off on Saturday with a … Continue reading

    Let The Games Begin! – #Kscope14

    images-jackjohnsonmusic-com-oniricfs-us-uploads-communitygroups-Nature_Consortium_2-160x229We kicked off KScope 14 with a great Community Service event with the Nature Consortium.  If you saw my tweet earlier, we HANDLED that Himalayan Blackberry.  I’ve got some of that stuff or a very close relative growing in my back … Continue reading

    Using Shell Scripts as Concurrent Programs in EBS

    Using Shell Scripts as Concurrent Programs in EBS

    Recently, I started looking at way to address a scheduling problem when moving files associated with our business partners. We currently have a three step process:

  • Schedule a Concurrent Program to produce a file
  • Set up a cronjob to schedule a shell … Continue reading
  • Oracle EBS: Life Events, Life_Event_Occurred_Date (lf_evt_ocrd_dt) and last_update_date

    Whenever we talk about Date Tracking in EBS, we always refer to the effective_start_date and effective_end_date fields.  Does code like this look familiar?

    SELECT *
    FROM per_all_people_f papf
    WHERE sysdate between papf.effective_start_date and papf.effective_end_date

    While this great for making sure you have the record on the date you are looking … Continue reading