Showing posts with label EBS. Show all posts
Showing posts with label EBS. Show all posts

Friday, May 24, 2019

How to Set Org Context in 11i and R12

In 11i:

Begin
    dbms_application_info.set_client_info('&ORG_ID');
End;


In R12:

BEGIN
   MO_GLOBAL.SET_POLICY_CONTEXT('S', <orgid>);
END; 

Find the Product Installed on your EBS Environment

SELECT a.application_id,
  a.application_short_name,
  a.application_name,
  b.oracle_id,
  b.last_update_date,
  b.product_version,
  b.patch_level
FROM Fnd_application_vl a,
            Fnd_PRODUCT_INSTALLATIONS b
WHERE a.application_id = b.application_id;

Wednesday, May 8, 2019

How to Set Up Purchasing in Oracle Apps R12 – Step-by-Step Guide


The following setup steps are basic setups. One person or a large team of people working concurrently may perform setups. In an implementation, common application setups are generally performed first, followed by shared setups for each product family (procure to pay, order to cash) and finally application specific setups. To implement the Purchasing module below are the required setups to follow.


Inventory Organization in Oracle Apps R12 – Structure, Setup & Best Practices

An Inventory Organization is a facility where we can store and transact items. Before we can use Oracle Inventory, we must define one or more Inventory Organizations. Inventory Organizations represent distinct entities in your enterprise and can be one of the following.
  • A Physical entity such as a Manufacturing facility, warehouse, or distribution centre.
  • A logical entity such as an item master organization, which we use to define items.
An Inventory Organization may have the following attributes.
  • An Inventory Organization can have its own location, ledger, costing method, workday calendar and items.
  • An Inventory Organization can share one or more of these characteristics with other organizations. 
 

Inventory Organization Structure 
An Inventory Organization, where we store and transact items can have one or more sub-inventories. Sub-Inventories are unique physical or logical separations of material inventory, such as raw material, finished goods and defective goods inventories. We must define at least one sub-inventory for every inventory organization. We can track item quantities by sub-inventory as well as we can restrict items to specific sub-inventories. Sub-Inventories in an Inventory Organization may be made up of one or more locators. We use locators to identify the physical areas where we store the inventory items. We can track the item by locators as well as we can restrict items to specific locators. Locator control is optional in Oracle Inventory. Before we start defining an Inventory Organization 1st we should define Location.

Define Location

Navigation: Inventory > Setup > Organizations > Locations 

Define Inventory Organization

Navigation: Inventory > Setup > Organizations > Organizations > New (B)