Deleting the Allocation in Oracle RMS
Description: 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 Journal Setup
Auto 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 MoreManual Item Ranging in Oracle RMS
Description: How to perform the manual Item Ranging for individual items in Oracle RMS. Navigation -> Marchandising -> Merchandising System (RMS) -> Items -> Items -> Action -> Edit Item…
Read MoreSetup a new store in Oracle RMS
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 MoreUnable to raise the change request on the requisition in iprocurement
Change 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 MoreData Migration and Conversion Strategy
Data 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 MoreHow to Change the Default Request Group in E-Business Suite Support Analyzer Bundle Menu
It 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 MoreOracle R12 AR Lockbox Query
SELECT 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 MoreOracle SQL Query To Find Square Root For A Number
Syntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Read MoreBILL CODE MAPPING IN ORACLE APPS R12
Step 1: Navigation: US AR SetupUser à Iron Source Bill Code MappingàEnter the Source->Operating Unit->Bill Code-> Modifiy the Code Combination-> Save
Read More