Payables modules are used to create supplier related information in oracle. In this module we can create supplier invoice bank etc will be maintained. This script used to create Supplier…
Read MoreInventory module used to create items in oracle. This module will link with AP, PO, GL modules. In inventory we have lot concepts where we will create lots , so…
Read MoreTo Setup a new store in RMS follow the steps given below Step 1: First open the browser and type the given URL: http://shk-oratestapp02.hk.oracle.se:7783/RetailWorkspace/faces/faces/RetailWorkspace.jspx login screen will be displayed.…
Read MoreIt is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Product Family 3.Select an…
Read MoreWhen trying to submit one of GL report end with error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from ************_LOV ORA–29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException 29532. 00000…
Read MoreQuery: select name,argument_text from (SELECT prog.user_concurrent_program_name || DECODE (req.description, NULL, NULL, ‘:’ || req.description) name, req.request_id, req.parent_request_id, req.request_date, DECODE (req.request_type, ‘P’, actual_start_date, requested_start_date), req.actual_completion_date, FLOOR( ( (actual_completion_date – DECODE (req.request_type,…
Read MoreQuery: SELECT rs.user_request_set_name “Request Set”, rss.display_sequence seq, cp.user_concurrent_program_name “Concurrent Program”, e.executable_name, e.execution_file_name, lv.meaning file_type, fat.application_name “Application Name” FROM fnd_request_sets_vl rs, fnd_req_set_stages_form_v rss, fnd_request_set_programs rsp, fnd_concurrent_programs_vl cp, fnd_executables e, fnd_lookup_values lv,…
Read MoreSELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, fls.meaning note_type_meaning, jnt.notes notes FROM apps.hz_cust_accounts hca, apps.jtf_notes_b jnb, apps.jtf_notes_tl jnt, apps.fnd_lookups…
Read MoreSELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read More