Oracle Applications

Oracle for Beginners

Posts Tagged ‘11.5’

Fetching Flexfield Description

Posted by shameemakhtar on October 19, 2009


CREATE OR REPLACE FUNCTION APPS.GET_FLEX_VS_DESC (P_VALUE_SET_NAME VARCHAR2, P_FLEX_VALUE VARCHAR2, P_PARENT_FLEX_VALUE VARCHAR2)
RETURN VARCHAR2 IS
DESCRIP VARCHAR2(50);
BEGIN
IF P_PARENT_FLEX_VALUE IS NULL
THEN
/*** In case the value set is independent ***/
SELECT DISTINCT DESCRIPTION
INTO DESCRIP
FROM FND_FLEX_VALUES_VL
WHERE FLEX_VALUE_SET_ID =
(
SELECT FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME
AND FLEX_VALUE = P_FLEX_VALUE
--AND PARENT_FLEX_VALUE_LOW = P_PARENT_FLEX_VALUE
);
ELSE
/*** If the value set is dependent on another value set ***/
SELECT DISTINCT DESCRIPTION
INTO DESCRIP
FROM FND_FLEX_VALUES_VL
WHERE FLEX_VALUE_SET_ID =
(
SELECT FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME
AND FLEX_VALUE = P_FLEX_VALUE
AND PARENT_FLEX_VALUE_LOW = P_PARENT_FLEX_VALUE
);
END IF;
RETURN NVL(DESCRIP, 'ERROR');
END;
/

Shameem Bauccha

19 October 2009

Advertisements

Posted in Oracle Apps, Scripts, System Administration, System Administrator, Technical | Tagged: , , , | Leave a Comment »

Inventory Organization – Receiving Options

Posted by shameemakhtar on June 24, 2009


Platform: R12, 11.5

Refer to document ‘Create Inventory Organization‘.

Receiving Options

Receiving Options

You also need to configure your Receiving Options and input your Accounting for Receiving.

Note, now you have configured your inventory organization. You need to do the same thing for all your inventory orgs (that is you need to configure the Additional Organization Information for all your inventory orgs).

Shameem Bauccha

24 June 2009

Posted in Inventory, Oracle Apps, Supply Chain Management | Tagged: , , , , | 3 Comments »

Inventory Organization – Organization Parameters

Posted by shameemakhtar on June 24, 2009


Platform: R12, 11.5

Refer to document ‘Create Inventory Organization‘.

Define Organization Parameters

1. Inventory Parameters

Inventory Parameters

Inventory Parameters

Before defining any Inventory Organization, we need to have a Master Inventory Organization which acts as a central repository for items. After we have defined the Master Inventory Organization, we need to define its organization parameters. Generally we give the code ‘IMM’ to denote the Inventory Item Master Organization.

We need to attach the Master Organization in the Organization parameters. Attach the Inventory Calendar.

Refer to document ‘Define Inventory Calendar‘.

Configure the Inventory Parameters including locator control.

2. Costing Information

Costing Information

Costing Information

The Operating Unit is automatically picked up as the Costing Organization.

Choose the appropriate ‘Costing Method’ (FIFO, Standard, Average). Specify whether to Transfer to GL.

Input the valuation Accounts.

3. Revision, Lot, Serial and LPN

Revision, Lot, Serial and LPN

Revision, Lot, Serial and LPN

If you are using Lot, Serial and/or LPN control, configure this window, otherwise accept the default values.

4. ATP, Pick, Item-Sourcing

ATP, Pick, Item-Sourcing

ATP, Pick, Item-Sourcing

If you are using iProcurement, configure the ATP defaults, Picking defaults and Item-Sourcing rules.

5. Inter-Org Information

Inter-Org Information

Inter-Org Information

Configure this section for Inter-org transfers.

6. Other Accounts

Other Accounts

Other Accounts

Specify the following Accounts:

  • Receiving Accounts
  • Profit and Loss Accounts
  • Other Accounts

When you are done, save and click on ‘OK’. You will get the following warning:

Note-Costing Method

Note-Costing Method

Bauccha Shameem

24 June 2009

Posted in Inventory, Oracle Apps, Supply Chain Management | Tagged: , , , , , , , , , , , , , , , | 2 Comments »

Inventory Organization – Customer/Supplier Association

Posted by shameemakhtar on June 24, 2009


Platform: R12, 11.5

Refer to document ‘Create Inventory Organization‘.

Customer/Supplier Association

Cutomer/Supplier Association

Customer/Supplier Association

This is important to define if you will allow internal requisition and sales between your inventories.

Detailed explanation to follow during preparation of Inventory Tutorial.

Shameem Bauccha

24 June 2009

Posted in Inventory, Oracle Apps, Supply Chain Management | Tagged: , , , , , | 1 Comment »

Inventory Organization – Accounting Information

Posted by shameemakhtar on June 24, 2009


Platform: R12, 11.5

Refer to document ‘Create Inventory Organization‘.

Accounting Information

Accounting Information

Accounting Information

Attach your primary leder.

Based on your Primary Ledger, your Legal Entity i automatically picked up.

Optionally if you have defined an Operating or have multiple units on the same insrtallation, attach the Operating Unit.

Save and Click on ‘OK’.

Shameem Bauccha

24 June 2009

Posted in Inventory, Oracle Apps, Supply Chain Management | Tagged: , , , , , | 1 Comment »

Create Inventory Organization

Posted by shameemakhtar on June 24, 2009


Platform: R12, 11.5

Define Organization and classify organization as ‘Inventory Organization’

Refer to the following documents:

Setting up Organizations

Create Organization

Additional Organization Information

You can access the Additional Organization Information by selecting the classification and clicking on the ‘Others’ button.

Select appropriate Extra Information to configure.

Additional Organization Information

Additional Organization Information

In the case of Inventory Organization, 4 Extra Info are defined:

Shameem Bauccha

24 June 2009

Posted in Inventory, Oracle Apps, Supply Chain Management | Tagged: , , , , , , | 5 Comments »

Create Organizations

Posted by shameemakhtar on June 24, 2009


Platform: R12, 11.5

Understanding the ‘Organization’ window

The Organization window

The Organization window

The ’Organization’ window consists of the following sections:

1. Name: The name of the Organization
2. Type: This is a lookup that you user can define (ORG_TYPE)

(Document on Lookups to follow)

3. Date: Effective Date. This can also be changed manually while creating the organization.
4. Location: Location Details and Address
5. Descriptive Flexfield: You can configure the ‘Location Address’ Descriptive Flexfield if required.

Refer to document ‘Identify Descriptive Flexfield’ to know which DFF to setup.

6. Organization Classifications: This will determine what type of organization this is and how the entity will behave in the application depending on the role it plays. An organization may have several classifications attached to it.

For example, an organization may have people registered for it and may at the same time be maintaining stock and act as a training center. In that case, the organization will have to be classified as:

  1. HR Organization so that employees may be assigned there
  2. Inventory Organization so that items may be assigned to it
  3. Training Organization so that the organization may be available as a training center.

(More to follow on each Organization type – refer to respective applications).

7. Others: Depending on the classification, Additional Information may have to be entered.

Setup Organization

1. Create Location

Inventory –> Setup –> Organizations –> Locations

Location

Location

Location is a shared between HRMS, Inventory and Purchasing. Some of the fields not used by HRMS are disabled when Inventory and Purchasing is not installed.

Setting the scope as ‘Global’ means the location is shared across all Business Groups. Setting the location as ‘Local’ will make the location available only for the Business Group in question.

Select the scope and give the location a name.

Address Details

Address Details

Address Details

Choose the appropriate address style and enter the address of the location. If you have defined your own address style then you can choose it here.

Refer to the following document:

Create Custom Address Style (Document to follow)

Shipping Details

Shipping Details

Shipping Details

This tab is important if you are using Inventory and Purchasing. Otherwise accept the default values.

Other Details

Other Details

Other Details

2. Create Organization

Inventory –> Setup –> Organizations –> Organizations


Organization

Organization


Alter effective date to a default date in the past or the organization creation date. Give a name to the Organization. Attach the location previously created. The location address gets automatically populated

Save the Organization.

3. Organization Classification

Look up the Organization classification. Ensure the ‘enabled’ checkbox is checked. Save. Click on other to enter the Extra Information (Additional Organization Details) as appropriate.

Shameem Bauccha

24 June 2009

Posted in Oracle Apps, Shared Entities | Tagged: , , , , , , , , , , , | 8 Comments »

How to identify Descriptive Flexfield on window

Posted by shameemakhtar on June 24, 2009


Platform: 11.5, R12

Go to the window in question.

Click on any field in the block where the DFF is found.

Then go to the menu and navigate s follow:

Help –> Diagnostics –> Examine

Examine

Examine

You are prompted for a password to enable diagnostics

Enable diagnostics

Enable diagnostics

Key in the database password and click on ‘OK’.

Examine Field and Variable Values

Examine Field and Variable Values

Take note of the block.

Click on ‘Block’ and choose $DESCRIPTIVE_FLEXFIELD$

Choose a block

Choose a block

Click on Field and choose the appropriate field (based on the block)

DFF Value

DFF Value

In the ‘Value’ Field you will get the Descriptive Flexfield that you have to configure and the application that the DFF is registered in.

In the above example we have to define the ‘Location Address’ Descriptive Flexfield in the ‘Human Resources’ Application.

Shameem Bauccha

24 June 2009

Posted in General Tips, Oracle Apps | Tagged: , , , , , , | Leave a Comment »