top of page
Search

Find a patch that modified a file in EBS R12.2

Retrieve the file details from the apps.ad_files table

SELECT file_id, filename, subdir
FROM apps.ad_files
WHERE filename LIKE '%afcpprog%'
FETCH FIRST 1 ROWS ONLY;

Get the patch_run_bug_id using the below query

SELECT file_id, patch_run_bug_id, patch_file_version_id, last_update_date
FROM ad_patch_run_bug_actions
WHERE file_id = '&file_id'
ORDER BY last_update_date;

Get the bug_number/patch_number using below query

SELECT patch_run_id, bug_id, orig_bug_number
FROM ad_patch_run_bugs
WHERE patch_run_bug_id = '&patch_run_bug_id';

22 views0 comments

Recent Posts

See All

Comments


Contact Me

Tel: 7989359581

Lakshminarayana0071@gmail.com

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon

Thanks for submitting!

© 2023 by Phil Steer . Proudly created with Wix.com

bottom of page