To 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 Moreselect a.menu_id , menu_name , c.responsibility_name , g.user_name , g.description from fnd_menu_entries a , fnd_menus b , fnd_responsibility_vl c , fnd_form_functions d , fnd_form_vl e , fnd_user_resp_groups f , fnd_user…
Read MoreCREATE TABLE xxcus.XX_PO_HEADERS_STG ( INTERFACE_HEADER_ID NUMBER , BATCH_ID NUMBER, INTERFACE_SOURCE_CODE VARCHAR2(25), PROCESS_CODE VARCHAR2(25), ACTION VARCHAR2(25), GROUP_CODE VARCHAR2(25), ORG_ID NUMBER, DOCUMENT_TYPE_CODE VARCHAR2(25), DOCUMENT_SUBTYPE VARCHAR2(25), DOCUMENT_NUM VARCHAR2(20), PO_HEADER_ID NUMBER, RELEASE_NUM NUMBER, PO_RELEASE_ID…
Read MoreXML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions <?xdofx:expression?> for extended…
Read MoreSELECT FORMS.form_name, FORMSTL.user_form_name, RESTL.responsibility_name, FORMSTL.language FROM fnd_form FORMS, fnd_form_tl FORMSTL, fnd_form_functions FUNC, fnd_menu_entries MENU, fnd_responsibility RES, fnd_responsibility_tl RESTL WHERE FORMSTL.user_form_name LIKE ‘%Workbench%’ AND FORMS.form_id = FORMSTL.form_id AND FUNC.form_id = FORMS.form_id…
Read MoreChange request cannot be initiated for this requisition since none of the associated purchase orders are eligibile for change. Issue Description: Unable to raise the Change request on the requisition…
Read MoreConditional Format Statements in BI/XML Publisher : If if-then-else choose- when-otherwise The Conditional Formatting using if statement: If statement: Use if statement to define a simple condition; for example, if…
Read MoreData migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy systems are replaced or the…
Read More1. Overview This document will be helpful to print comma separated string with the new line report 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case To display comma separated…
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 More