Loading data using SQL Loader Scenario: Suppose we have some legacy system(Main Frame) and now we want to transfer data into new system (Oracle). Export data from legacy system(Here I… Continue reading "SQL LOADER program to load data into Oracle EBS"
EBS Table: fnd_Responsibility (Responsibility name) fnd_concurrent_programs_tl (Concurrent program name) Query to get Responsibility using concurrent program name SELECT frt.responsibility_name, frg.request_group_name, fcpt.user_concurrent_program_name FROM fnd_Responsibility fr, fnd_responsibility_tl frt, fnd_request_groups frg, fnd_request_group_units frgu,… Continue reading "Finding responsibility using concurrent program name"