Daniel Borgstrom talking about Oracle

Useful query which will fetch your inventory items from contract lines. Service Products: SELECT kl.line_number, ks.name, itm.segment1, itm.segment2 FROM okc_k_headers_v kh, okc_k_lines_v kl, okc_k_items ki, okc_line_styles_v ks, mtl_system_items_b itm WHERE kh.contract_number = ' contract number ' AND kh.contract_number_modifier IS NULL AND kh.id = kl.dnz_chr_id AND kh.id = ki.dnz_chr_id AND kl.id = ki.cle_id AND kl.lse_id = ks.id AND ki.jtot_object1_code IN ('OKX_SERVICE') AND kh.inv_organization_id = itm.organization_id AND ki.object1_id2 = itm.organization_id AND ki.object1_id1 = itm.inventory_item_id ORDER BY kl.line_number; Covered Products: SELECT kl.line_number, ks.NAME, i.segment1, i.segment2 FROM okc_k_headers_b kh, okc_k_lines_b kl, okc_k_items ki, okc_line_styles_v ks, csi_item_instances c, mtl_system_items_b i WHERE kh.contract_number = ' contr...

In a R12 upgrade project it can be a good idea to read some information from the database regarding the customizations. List Forms Personalization SELECT ft.user_function_name, fo.form_name, c.* FROM fnd_form_custom_rules c, fnd_form_functions f, fnd_form_functions_tl ft, fnd_form fo WHERE c.function_name = f.function_name AND f.function_id = ft.function_id AND f.form_id = fo.form_id ORDER BY 2 List Custom Forms SELECT ft.user_form_name, f.* FROM fnd_form f, fnd_form_tl ft WHERE f.form_id = ft.form_id AND form_name LIKE 'XX%' ORDER BY 4

If you have a concurrent request executable of type host (shell script on unix) and you want to set the status of the request to Warning or Error upon completion you need to use a small SQL-script to accomplish this. Warning DECLARE l_result BOOLEAN; l_session_id NUMBER; l_reqid NUMBER; BEGIN l_reqid := '&&1'; dbms_output.put_line('l_reqid '||l_reqid); fnd_global.INITIALIZE(l_session_id, null, null, null,null, -1, null, null, null,  null, l_reqid, null,null,null,null,null,null,-1); l_result := fnd_concurrent.set_completion_status('WARNING','Review log file for details.'); COMMIT; END; / exit 0; Error DECLARE l_result BOOLEAN; l_session_id NUMBER; l_reqid NUMBER; BEGIN l_reqid := '&&1'; dbms_output.put_line('l_reqid '||l_reqid); fnd_global.INITIALIZE(l_session_id, null, null, null,null, -1, null, null, null,  null, l_reqid, n...

In most cases the output files will be written to $COMMON_TOP/admin/out/ <ENV.NAME> . If you don't find anything there investgate the environment variables $APPLCSF (path), $APPLLOG (folder name) and $APPLOUT (folder name). I read somewhere that if $APPLCSF is not set the outputs will be written to $ <APPLICATION_SHORT_NAME> / <VALUE OF $APPLOUT> e.g $AR_TOP/admin/out.

Internet Exploring is crashing when starting EBS (jInitiator). You have installed jInitiator ver 1.3.1.21 without any problem but when you are trying to start the Forms environment IE is crashing. A workaround can be found here . I have used this solution succsessfully both with XP and Win7.

This select will give you all the values for a specific profile option. SELECT potl.language, potl.user_profile_option_name, potl.description, po.profile_option_id, DECODE(pov.level_id, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, 'User', 10005, 'Server', 10006, 'Org', 10007, DECODE(to_char(pov.level_value2), '-1', 'Responsibility', DECODE(to_char(pov.level_value), '-1', 'Server', 'Server+Resp')), 'UnDef') level_set, DECODE(to_char(pov.level_id), '10001', '', '10002', app.application_short_name, ...

One of my clients who run the Finance modules (AR, ARP, GL etc), Service Contracts and Field Service in E-Business Suite R12 had some issues with customers who were inactive. The issue arised when they were creating Service Requests (through API cs_servicerequest_pub.Create_ServiceRequest) and got an error reported by the API that the request could  not be created due to the customer was invalid. The reason that a customer is invalid can vary but one reason is that some level of the customer is inactive. In AR and the TCA model the customer (party) status can be set in the following tables: hz_parties (TCA) hz_party_sites (TCA) hz_party_site_uses (TCA) hz_cust_accounts (TCA-AR) hz_cust_acct_sites_all (TCA-AR) hz_cust_site_uses_all (TCA-AR) In my clients case status was Active in all tables except  hz_party_site_uses . Below I will explain how it's possible to change the statuses. Set status in Account Receivables If you inactivate an Account Site Address/Acc...