Issue Summary: Unable to back order due to Shipping Exception Error. Issue Description: Unable to Ship the order due to Shipping Exception error and hence needs to do a…
Read MoreEmployee as Supplier creation page error-Alternative Solution proposed Follow this process for first time creation for employee as supplier Enter expense report for 1$ for Employee Run the program…
Read MoreDescription: How to delete the Allocation in Oracle RMS manually. Navigation -> RMS -> Applications -> Planning -> Allocation Search for the Allocation Id and click on the description. Change…
Read MoreAuto reversal in oracle means , We will create some rules and setups for some GL journal source which will automatically reverses the GL journals for that Source as per the Auto Reversal Setup. here below we will…
Read MoreDescription: How to perform the manual Item Ranging for individual items in Oracle RMS. Navigation -> Marchandising -> Merchandising System (RMS) -> Items -> Items -> Action -> Edit Item…
Read MoreIntroduction to workflow Tool from Oracle Works with Oracle Database PL/SQL Based Widely Used with Oracle Applications Can be Used Stand-Alone or with Oracle Apps Need of workflow Workflow can…
Read MoreWe can sort data in XML report a group by any element within the group. Sort data based on Empno: Syntax: <?sort:Field_Name?><?Field_Name?> It sorts the data in ascending order by Default. If Order…
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 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 More