May 2, 2014

SELECT FPO.PROFILE_OPTION_ID,
FPO.PROFILE_OPTION_NAME,
FPOT.USER_PROFILE_OPTION_NAME,
FPOV.LEVEL_ID,
DECODE(FPOV.LEVEL_ID,
'10001',
'Site',
'10002',
'Appllication',
'10003',
'Responsibility',
'10004',
'User',
FPOV.LEVEL_ID) LEVEL_TYPE,
FPOV.LEVEL_VALUE,
DECODE(FPOV.LEVEL_ID,
'10001',
'Site',
'10002',
(SELECT APPLICATION_NAME
  FROM APPS.FND_APPLICATION_TL
WHERE APPLICATION_ID =FPOV.LEVEL_VALUE),
'10003',
(SELECT RESPONSIBILITY_NAME
  FROM APPS.FND_RESPONSIBILITY_TL
WHERE RESPONSIBILITY_ID =FPOV.LEVEL_VALUE),
10004,
(SELECT DESCRIPTION
  FROM APPS.FND_USER
WHERE USER_ID = FPOV.LEVEL_VALUE),
FPOV.LEVEL_ID) LEVEL_VALUE,
FPOV.PROFILE_OPTION_VALUE,
FPOV.LAST_UPDATE_DATE,
FPO.SQL_VALIDATION,
TRUNC(FPOV.LAST_UPDATE_DATE),
  (SELECT DESCRIPTION
FROM APPS.FND_USER
  WHERE USER_ID = FPOV.LAST_UPDATED_BY)UPDATED_BY
FROM APPS.FND_PROFILE_OPTIONS FPO,
APPS.FND_PROFILE_OPTION_VALUES FPOV,
APPS.FND_PROFILE_OPTIONS_TL FPOT
WHERE FPOV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID
  AND FPOT.PROFILE_OPTION_NAME =FPO.PROFILE_OPTION_NAME
  AND FPOV.LEVEL_VALUE =
  (SELECT USER_ID FROM FND_USER WHERE USER_NAMEIN ('305030341')) --for user
  /*AND (FPOV.LEVEL_ID = 10003 AND
FPOV.LEVEL_VALUE IN
(SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_TL
WHERE RESPONSIBILITY_NAME LIKE '%%')) --for responsibility*/
  /*AND UPPER(FPOT.USER_PROFILE_OPTION_NAME) LIKE '%WMS%TCP%' -- for profile option*/

April 2, 2014

Cost Groups in Oracle WMS are assigned by the Cost Group Rules Engine.
In Oracle Inventory, Cost Groups are derived based on the primary cost Method of the organization and the location where the material is being moved. If the costing method is Standard-Costing, then the Cost Group associated with subinventory is assigned to the material. For the other costing methods, the Cost Group associated with the organization is used.
In Oracle Warehouse Management, once a Cost Group is associated with a material, it does not change when the material is moved within the organization.

In Oracle Inventory, the Cost Group associated with the material changes with the location where it is residing.
So in WMS, once the material moved with in the organization, then cost group update needs to be done if you want to change the cost group assigned to the material.

Lets understand this with below example

Example 1:

In your organization, you are dealing with FMCG products which has multiple variants.

You have edible and non edible products, creme, liquid and solid products and you are storing those across subinventories where multi variant products can be stored in same subinventory but you want to distinguish the costing reporting.

This canot be possible if you are using only Inventory, as the maximum level of cost group assignment will be at subinventory level.

If you are using WMS, this can be achieved by defining cost group assignment rules which can be assigned by considering many attributes like item type, supplier, customer and many more.

Example 2:

WMS Inventory Organization with the Average Costing Method

Transaction 1: Buy 100 units @ 10/unit from Supplier 1 in LOT A
Transaction 2: Buy 100 units @ 20/unit from Supplier 2 in LOT B
Transaction 3: Sell and Ship 100 units @ 30/unit to Customer 1 in LOT A
Transaction 4: Sell and Ship 100 units @ 30/unit to Customer 2 in LOT B

In this organization, LOT A’s 100 units would be received into inventory and averaged together (10/unit) and LOT B’s 100 units would be received into inventory and averaged together (20/unit) . Then when the items are shipped to the customer, LOT A would have an average cost of 10 and a higher margin than LOT B. The units from both projects could be indistinguishable and in the same physical location in the warehouse. But, in the system, they are tracked separately using the cost group.

March 9, 2014

If you want to change or customize the fields in the Mobile screen of MSCA for a specific transaction, then you need to follow below steps.

Check for the Form Function

Find out the function name

Check how the parameters are defined

Find the parameter what you are looking for

Check the value assigned for that parameter

As per the requirement change that

Now in the transaction screen of MSCA, the required changes should display.

Check for the MWA Personalization

Find out the page name which is showing for this transaction

Go to the WMA Personalization function

Open the required page

Check for the field name

Edit and do the change as needed either in responsibility level or in Organization level

Save the changes.

Bounce the MSCA server.

Then see the changes

December 14, 2013

Oracle MWA Personalization

This personalization can be done in 3 levels

Function
Organization
Responsibility

Personalization Setup

Below profile options need to be setup

MWA: Enable Personalization: This will decide whether you want to enable the personalization or not
MWA: Cache Personalized Metadata: This profile option controls whether or not you need to bounce the MWA server.

Supported Mobile Pages

Pick Load
Pick Drop
Manual Load
Item Load
Move Any LPN
Putaway Drop
Update LPN
Mobile PO receipt
Mobile PO receipt information
LPN Ship
Mobile Ship confirm

Personalizing Mobile Pages

Step:1 Navigate to the Warehouse Manager Responsibility and choose MWA Personalization framework option under the Setup sub-menu

Step:2 Select a page and click on personalize, this will show all the fields in that page and their function level values with an edit option in the light of every field

Step:3 After clicking the edit button, make the required changes and click apply

Step:4 Navigate to the mobile page and review your personalization done for the page. Note: If the profile option “MWA: Cache Personalized Metadata” is set to “Yes” then, the personalization made will come into effect only after bouncing the mobile server

The Personalized Update LPN Page displays the page name as “* Update LPN (W1)” The “ * ” indicates that the page involved has been personalized.

The above picture shows the before and after view of the “Update LPN” page with the following personalization:

LPN field’s prompt changed to “Custom LPN”.
Default value is set to weight field and is made read-only.
LPN Attributes LPN DFF is enabled/rendered for the LPN field.
Content Vol. field is made hidden
Container field is made mandatory/required
Update LPN button’s prompt is changed to Custom Update

Activate/Deactivate Personalization

Personalization created for a page can be Activated/Deactivate from the activate/deactivate personalization page

These Personalizations can be done in Organization and Responsibilitry level too.

Step1: For doing personalization in Organization level, you have to select the page name and then give the organization name and click personalize

Step2: This will show value at organization level too

Step3: Click Edit button, do the changes and click Aply

Step4: Click Activate/Deactivate Personalization and make changes

Enabling Descriptive Flexfields for Mobile Pages

You can use mobile personalization to display descriptive flexfields on mobile pages. The LPN descriptive flexfield is WMS: License Plate Numbers. You can choose to enable users to update the descriptive flexfield, or display it as a read-only field on the mobile page. How the field appears, depends on the choices you select in the Personalization Field Properties page. To personalize descriptive flexfields on mobile pages, follow the procedure for personalizing mobile pages. The personalization options for descriptive flexfields are:

Display Inline: If you set the field to yes, then the descriptive flexfields are displayed on the same page. If you set the field to no, then the user enter the descriptive flexfield values on a separate page.
Default Context: If you set the field to yes, then the user can enter a default context for the descriptive flexfield

Source: docs.oracle.com

Learn Oracle