// API callback
related_results_labels({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842"},"updated":{"$t":"2023-12-14T04:33:31.384-08:00"},"category":[{"term":"oracle apps R12"},{"term":"AP"},{"term":"PO"},{"term":"oracle apps"},{"term":"AP Base Tables"},{"term":"Concurrent Program"},{"term":"Approver"},{"term":"Base Table"},{"term":"Finance"},{"term":"HRMS"},{"term":"API"},{"term":"Employee"},{"term":"Query"},{"term":"inventory"},{"term":"invoice"},{"term":"unix"},{"term":"AR"},{"term":"BOM"},{"term":"BPA"},{"term":"Concurrent programs"},{"term":"FNDLOAD"},{"term":"Materialized View"},{"term":"Modifiers"},{"term":"Order Managment"},{"term":"Price List"},{"term":"Qualifiers"},{"term":"R12"},{"term":"SLA"},{"term":"TDS"},{"term":"XDO"},{"term":"XML Publisher Reports"},{"term":"interview"},{"term":"item"},{"term":"ABC ASSIGNMENTS"},{"term":"AOL"},{"term":"Bank Account"},{"term":"Bank Branches information"},{"term":"Bill of Material"},{"term":"Blanket Purchase Order"},{"term":"CGST"},{"term":"CZ"},{"term":"Category"},{"term":"Closing PO using API"},{"term":"Collection"},{"term":"Configurator"},{"term":"Create User"},{"term":"Credit card"},{"term":"Database"},{"term":"Date Tracking"},{"term":"FNDLOAD Scripts"},{"term":"Fmb"},{"term":"Form"},{"term":"GL"},{"term":"GST"},{"term":"Get Password"},{"term":"HTTP"},{"term":"Hold"},{"term":"Initializing session"},{"term":"JAI"},{"term":"Linux"},{"term":"List of tables"},{"term":"MTL"},{"term":"Multi Org"},{"term":"Operating_units"},{"term":"Oracle clone URL"},{"term":"Order To Cash Cycle – O2C"},{"term":"Org_id"},{"term":"P2P"},{"term":"PR"},{"term":"Price List tables"},{"term":"Primary Price list"},{"term":"Product Rent"},{"term":"Purchase Requisition"},{"term":"Purchase order"},{"term":"Query to find Bank"},{"term":"Report"},{"term":"Routing"},{"term":"SCM"},{"term":"SGST"},{"term":"SOAP"},{"term":"SQL"},{"term":"SSH"},{"term":"Sales Order"},{"term":"Secondary Price list"},{"term":"Sequence"},{"term":"Shell Script"},{"term":"Supplier"},{"term":"TAX"},{"term":"TCA"},{"term":"Type"},{"term":"Uncheck ignore flag"},{"term":"User"},{"term":"View"},{"term":"WIP"},{"term":"WSDL"},{"term":"WebService"},{"term":"XML"},{"term":"XML publisher"},{"term":"bursting"},{"term":"ccid"},{"term":"concurrent program parameter"},{"term":"currval"},{"term":"customer"},{"term":"customer account"},{"term":"cvv number"},{"term":"deliveries"},{"term":"delivery"},{"term":"fnd"},{"term":"forms"},{"term":"location"},{"term":"nextval"},{"term":"oracle EBS"},{"term":"oracle R12"},{"term":"organization_id"},{"term":"output path"},{"term":"people"},{"term":"per"},{"term":"projects"},{"term":"putty"},{"term":"qp_list_headers"},{"term":"request_group_name"},{"term":"session in oracle apps"},{"term":"technical"},{"term":"template"},{"term":"value set"},{"term":"wsh"}],"title":{"type":"text","$t":"Oracle Apps -Learn and grow"},"subtitle":{"type":"html","$t":"\"Oracle Apps -Learn and grow\" ,here we are sharing queries,technical and functional knowledge of oracle Apps."},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/posts\/default"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/-\/Concurrent+Program?alt=json-in-script"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/search\/label\/Concurrent%20Program"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Anonymous"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/14708334674681358157"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"generator":{"version":"7.00","uri":"http://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"6"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"25"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-5715933569755384409"},"published":{"$t":"2023-08-16T12:55:00.000-07:00"},"updated":{"$t":"2023-08-16T12:55:14.153-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"},{"scheme":"http://www.blogger.com/atom/ns#","term":"fnd"}],"title":{"type":"text","$t":"Query to Find Scheduled Concurrent Programs List"},"content":{"type":"html","$t":"\u003Cp\u003E\u0026nbsp;\u003C\/p\u003E\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003ESELECT\u003C\/b\u003E fcr.request_id ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efcpt.user_concurrent_program_name\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E|| NVL2(fcr.description,\n' ('\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E|| fcr.description\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E|| ')', \u003Cb\u003ENULL\u003C\/b\u003E)\nconc_prog ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efu.user_name\nrequestor ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efu.description\nrequested_by ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efu.email_address ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efrt.responsibility_name\nrequested_by_resp ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ETRIM\u003C\/b\u003E(fl.meaning)\n\u003Cb\u003ESTATUS\u003C\/b\u003E ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efcr.phase_code ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efcr.status_code ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efcr.argument_text \"PARAMETERS\"\n,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003ETO_CHAR(fcr.request_date,\n'DD-MON-YYYY HH24:MI:SS') requested ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003ETO_CHAR(fcr.requested_start_date,\n'DD-MON-YYYY HH24:MI:SS') requested_start ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003ETO_CHAR((fcr.requested_start_date),\n'HH24:MI:SS') start_time ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003EDECODE(fcr.hold_flag,\n'Y', 'Yes', 'N', 'No') on_hold ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ECASE\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EWHEN\u003C\/b\u003E fcr.hold_flag\n= 'Y'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ETHEN\u003C\/b\u003E SUBSTR(\nfu.description , 0 , 40 )\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EEND\u003C\/b\u003E\nlast_update_by ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ECASE\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EWHEN\u003C\/b\u003E fcr.hold_flag\n= 'Y'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ETHEN\u003C\/b\u003E fcr.last_update_date\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EEND\u003C\/b\u003E\nlast_update_date ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Efcr.increment_dates ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ECASE\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EWHEN\u003C\/b\u003E fcrc.CLASS_INFO\n\u003Cb\u003EIS\u003C\/b\u003E \u003Cb\u003ENULL\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ETHEN\u003C\/b\u003E 'Yes:\n'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| TO_CHAR(fcr.requested_start_date,\n'DD-MON-YYYY HH24:MI:SS')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EELSE\u003C\/b\u003E 'n\/a'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EEND\u003C\/b\u003E run_once ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ECASE\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EWHEN\u003C\/b\u003E fcrc.class_type\n= 'P'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ETHEN\u003C\/b\u003E 'Repeat\nevery '\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| SUBSTR(fcrc.class_info,\n1, instr(fcrc.class_info, ':')\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E-\n1)\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\ninstr(fcrc.class_info, ':', 1, 1) + 1, 1), 'N', ' minutes', 'M', ' months', 'H',\n' hours', 'D', ' days')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\ninstr(fcrc.class_info, ':', 1, 2) + 1, 1), 'S', ' from the start of the prior\nrun', 'C', ' from the completion of the prior run')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EELSE\u003C\/b\u003E 'n\/a'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EEND\u003C\/b\u003E\nset_days_of_week ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ECASE\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EWHEN\u003C\/b\u003E fcrc.class_type\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= 'S'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EAND\u003C\/b\u003E instr(SUBSTR(fcrc.class_info,\n33),'1',1) \u0026gt; 0\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003ETHEN\u003C\/b\u003E 'Days\nof week: '\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n33, 1), '1', 'Sun, ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n34, 1), '1', 'Mon, ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n35, 1), '1', 'Tue, ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n36, 1), '1', 'Wed, ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n37, 1), '1', 'Thu, ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n38, 1), '1', 'Fri, ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E|| DECODE(SUBSTR(fcrc.class_info,\n39, 1), '1', 'Sat ')\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EELSE\u003C\/b\u003E 'n\/a'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cb\u003EEND\u003C\/b\u003E\ndays_of_week\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EFROM\u003C\/b\u003E apps.fnd_concurrent_requests fcr ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_user fu ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_concurrent_programs\nfcp ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_concurrent_programs_tl\nfcpt ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_printer_styles_tl\nfpst ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_conc_release_classes\nfcrc ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_responsibility_tl\nfrt ,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003Eapps.fnd_lookups fl\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EWHERE\u003C\/b\u003E fcp.application_id\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= fcpt.application_id\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.requested_by\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= fu.user_id\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.concurrent_program_id\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E= fcp.concurrent_program_id\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.program_application_id = fcp.application_id\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.concurrent_program_id\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E= fcpt.concurrent_program_id\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.responsibility_id\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= frt.responsibility_id\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.print_style\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= fpst.printer_style_name(+)\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.release_class_id\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= fcrc.release_class_id(+)\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.status_code\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\n\u003C\/span\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u003C\/span\u003E= fl.lookup_code\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fl.lookup_type\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= 'CP_STATUS_CODE'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcr.phase_code\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= 'P'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E frt.language\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= 'US'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fpst.language\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= 'US'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EAND\u003C\/b\u003E fcpt.language\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp; \u003C\/span\u003E= 'US'\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003EORDER\u003C\/b\u003E \u003Cb\u003EBY\u003C\/b\u003E Fu.Description,\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003EFcr.Requested_Start_Date\n\u003Cb\u003EASC\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Co:p\u003E\u0026nbsp;\u003C\/o:p\u003E\u003C\/p\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/5715933569755384409\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2023\/08\/sql-query-to-find-scheduled-concurrent.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/5715933569755384409"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/5715933569755384409"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2023\/08\/sql-query-to-find-scheduled-concurrent.html","title":"Query to Find Scheduled Concurrent Programs List"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-3420250693953351723"},"published":{"$t":"2022-03-29T16:00:00.000-07:00"},"updated":{"$t":"2022-03-29T16:00:00.149-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"}],"title":{"type":"text","$t":"Concurrent Program Information - Oracle Apps"},"content":{"type":"html","$t":"\u003Cdiv style=\"text-align: left;\"\u003E\u003Cspan style=\"font-family: verdana; font-size: medium;\"\u003E\u0026nbsp;SELECT\u003Cbr \/\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;fu.user_name\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; CP_RUNBY\u003Cbr \/\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp;, to_char(fcr.request_date,'DD-Mon-YYYY') CP_RUNDATE\u003Cbr \/\u003EFROM\u003Cbr \/\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;fnd_concurrent_requests fcr\u003Cbr \/\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp;, fnd_user\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fu\u003Cbr \/\u003EWHERE\u003Cbr \/\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;fcr.requested_by\u0026nbsp; \u0026nbsp;=fu.user_id\u003Cbr \/\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;AND fcr.request_id = fnd_global.conc_request_id\u003C\/span\u003E\u003C\/div\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/3420250693953351723\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2022\/03\/concurrent-program-information-oracle.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/3420250693953351723"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/3420250693953351723"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2022\/03\/concurrent-program-information-oracle.html","title":"Concurrent Program Information - Oracle Apps"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-4809099008867236202"},"published":{"$t":"2021-12-02T03:47:00.004-08:00"},"updated":{"$t":"2021-12-02T03:47:24.107-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"},{"scheme":"http://www.blogger.com/atom/ns#","term":"oracle apps R12"}],"title":{"type":"text","$t":"Query to get concurrent program run details in oracle apps"},"content":{"type":"html","$t":"\u003Cdiv style=\"height: 0px; text-align: left;\"\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003ESELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;round(((sysdate-a.actual_start_date)*24*60*60\/60),2) AS Process_time,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.request_id,a.parent_request_id,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.request_date,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.actual_start_date,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.actual_completion_date,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;(a.actual_start_date-a.request_date)*24*60*60 AS lag_time,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;d.user_name,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.phase_code,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.status_code,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.argument_text,\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp;a.priority\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003EFROM\u0026nbsp; \u0026nbsp;apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs b,apps.FND_CONCURRENT_PROGRAMS_TL c,apps.fnd_user d\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003EWHERE\u0026nbsp; a.concurrent_program_id=b.concurrent_program_id\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003EAND b.concurrent_program_id=c.concurrent_program_id\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003EAND a.requested_by=d.user_id\u0026nbsp;\u003Cbr \/\u003E\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003Eand d.user_id=:P_USER_ID\u003Cbr \/\u003E\u003C\/span\u003Ex\u003C\/div\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/4809099008867236202\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2021\/12\/query-to-get-concurrent-program-run.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4809099008867236202"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4809099008867236202"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2021\/12\/query-to-get-concurrent-program-run.html","title":"Query to get concurrent program run details in oracle apps"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-596830229618024506"},"published":{"$t":"2021-08-17T00:09:00.006-07:00"},"updated":{"$t":"2021-08-17T00:09:55.222-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"},{"scheme":"http://www.blogger.com/atom/ns#","term":"oracle apps R12"},{"scheme":"http://www.blogger.com/atom/ns#","term":"output path"}],"title":{"type":"text","$t":"Query to find the output file name and path"},"content":{"type":"html","$t":"\u003Cblockquote style=\"border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;\"\u003E\u003Cdiv style=\"text-align: left;\"\u003E\u003Cdiv\u003E\u003Cspan style=\"font-family: verdana;\"\u003ESELECT\u0026nbsp;\u003C\/span\u003E\u003Cspan style=\"font-family: verdana;\"\u003Eoutfile_name output_file_path\u003C\/span\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cspan style=\"font-family: verdana;\"\u003EFROM\u003C\/span\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp; \u0026nbsp; fnd_concurrent_requests\u003C\/span\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cspan style=\"font-family: verdana;\"\u003EWHERE\u003C\/span\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cspan style=\"font-family: verdana;\"\u003E\u0026nbsp; \u0026nbsp; request_id = :p_request_id\u003C\/span\u003E\u003C\/div\u003E\u003C\/div\u003E\u003C\/blockquote\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/596830229618024506\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2021\/08\/query-to-find-output-file-name-and-path.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/596830229618024506"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/596830229618024506"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2021\/08\/query-to-find-output-file-name-and-path.html","title":"Query to find the output file name and path"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-3142518720434954041"},"published":{"$t":"2018-11-04T23:17:00.003-08:00"},"updated":{"$t":"2018-11-04T23:21:48.092-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"},{"scheme":"http://www.blogger.com/atom/ns#","term":"FNDLOAD"},{"scheme":"http://www.blogger.com/atom/ns#","term":"unix"}],"title":{"type":"text","$t":"How to Use FNDLOAD?"},"content":{"type":"html","$t":"\u003Cdiv dir=\"ltr\" style=\"text-align: left;\" trbidi=\"on\"\u003E\n\u003Cbr \/\u003E\n\u003Ch2 style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EHow to Use FNDLOAD?\u003C\/span\u003E\u003C\/h2\u003E\n\u003Cdiv\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Cbr \/\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EIt is merely time consuming task to create same setup data on\neach instance separately. Hence to migrate setup data from 1 instance to other\n(Eg. From DEV to\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EPROD), ldt \u0026amp; lct files are used.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003ELDT (Data Loader Files)- This files are Used to upload \u0026amp; download\nsetup data on different instances.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003ELCT (Data Config Files)- This files are used to create LDT\nFiles. There are difference lct files for different sets of data.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EEg: Value Set- afffload.lct,Request Set- afcpreqg.lct, Concurrent\nProgram- afcpprog.lct etc.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E** Now lets take a simple example where you want to migrate 1\nconcurrent program from Development (DEV) instance to Production (PROD).\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EStep 1: Login to Unix Development server and change the\ndirectory using following Command where you can store your LDT files:\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003Ecd $CUST_TOP\/ patch\/115\/import\/US\/ (where CUST_TOP is your\ncustom top on server)\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EStep 2: Run the following command by supplying the parameters\ngiven in {} as per your need\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EFNDLOAD {userid\/password@connect_string} O Y DOWNLOAD $FND_TOP\/patch\/115\/import\/afcpprog.lct\n{file_name.ldt} PROGRAM\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EAPPLICATION_SHORT_NAME=\"{your_application_short_name}\"\nCONCURRENT_PROGRAM_NAME=\"{your_concurrent_name}\"\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EThe above command will generate ldt file in your custom top\ndirectory ($CUST_TOP\/ patch\/115\/import\/US\/ )\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EStep 3: Copy the LDT file from Development Server to your local\ndesktop\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EStep 4: Login to Unix Production Server and copy the LDT files\nfrom local desktop to Production Server on following path:\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E$CUST_TOP\/ patch\/115\/import\/US\/ {file_name.ldt}\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003EStep 5: Finally Run the following command by supplying all\nparameters in {} to upload concurrent program definition on production\napplication server.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E$ FNDLOAD {userid\/password@connect_string} 0 Y UPLOAD\n$FND_TOP\/patch\/115\/import\/afcpprog.lct $CUST_TOP\/patch\/115\/import\/US\/{file_name}.ldt\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003ENote:\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E1) All above FNDLOAD commands are single line commands.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E2) All above steps will remain exactly same for all kind of\nsetup data (Eg: Value Set, CP, Req.group, DFF…etc) except the name of LCT file\n(.lct). LCT file\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003Ewill be different for every different component because the\nsetup data is different.\u003C\/span\u003E\u003Cspan style=\"color: #222222; font-family: \u0026quot;arial\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Cbr \/\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003ERefer to below link for list of various FNDLOAD commands:\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\" style=\"background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;\"\u003E\n\u003C\/div\u003E\n\u003Cdiv class=\"MsoNormal\"\u003E\n\u003Cspan style=\"color: #222222; font-family: \u0026quot;verdana\u0026quot; , \u0026quot;sans-serif\u0026quot;; mso-bidi-font-family: Arial; mso-fareast-font-family: \u0026quot;Times New Roman\u0026quot;;\"\u003E\u003Ca href=\"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2016\/11\/oracle-fndload-scripts-download-and-upload.html\" target=\"_blank\"\u003EFNDLOAD commands\u003C\/a\u003E\u003C\/span\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/div\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/3142518720434954041\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2018\/11\/how-to-use-fndload-command.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/3142518720434954041"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/3142518720434954041"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2018\/11\/how-to-use-fndload-command.html","title":"How to Use FNDLOAD?"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-4482170992665367909"},"published":{"$t":"2016-09-21T05:54:00.000-07:00"},"updated":{"$t":"2016-09-21T06:01:46.474-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Query"},{"scheme":"http://www.blogger.com/atom/ns#","term":"request_group_name"}],"title":{"type":"text","$t":"Query to Find Responsibilities based on Concurrent Program"},"content":{"type":"html","$t":"\u003Cdiv dir=\"ltr\" style=\"text-align: left;\" trbidi=\"on\"\u003E\n\u003Cbr \/\u003E\n\u003Ch2 style=\"text-align: center;\"\u003E\nQuery to Find Responsibilities based on Concurrent Program Name\u003C\/h2\u003E\nSELECT \u0026nbsp; \u0026nbsp;Distinct frt.responsibility_name, frg.request_group_name,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; frgu.request_unit_type,frgu.request_unit_id,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fcpt.user_concurrent_program_name\u003Cbr \/\u003E\n\u0026nbsp; FROM \u0026nbsp; \u0026nbsp; fnd_Responsibility fr, fnd_responsibility_tl frt,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fnd_request_groups frg, fnd_request_group_units frgu,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fnd_concurrent_programs_tl fcpt\u003Cbr \/\u003E\n\u0026nbsp; WHERE \u0026nbsp;frt.responsibility_id = fr.responsibility_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; frg.request_group_id = fr.request_group_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; frgu.request_group_id = frg.request_group_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; fcpt.concurrent_program_id = frgu.request_unit_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; frt.LANGUAGE = USERENV('LANG')\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; fcpt.LANGUAGE = USERENV('LANG')\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; fcpt.user_concurrent_program_name = P_conc_prg_name\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp;\u003Cbr \/\u003E\n\u003Cdiv\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003C\/div\u003E\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/4482170992665367909\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2016\/09\/query-to-find-responsibilities-based-on-concurrent.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4482170992665367909"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4482170992665367909"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2016\/09\/query-to-find-responsibilities-based-on-concurrent.html","title":"Query to Find Responsibilities based on Concurrent Program"}],"author":[{"name":{"$t":"Anonymous"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/14708334674681358157"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}}]}});