EBS Functional

Manual 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 More

Setup 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 More

Unable 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 More

Data 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 More

How 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 More

Oracle 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 More

Oracle SQL Query To Find Square Root For A Number

Syntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5

Read More

BILL 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

Assign the user ID to the responsibility

Purpose: Need to assign the responsibility which we created last sheet to the specific user ID   Navigation: System Administrator > Security > User > Define Step 1: Query the…

Read More

To Create New AutoAccounting in Oracle Apps R12

To Create New AutoAccounting in Oracle Apps R12: Define AutoAccounting to specify the general ledger accounts for transactions that you enter manually or import using Auto Invoice. AutoAccounting helps to…

Read More