Monday, 27 June 2016

Query to Find Profile option Values

If We need to Find a profile Option Value Through Database, when the user does not have system administrator Responsibility, this Query Will Help to Retrive the Values against each Profile Option at Various Levels.

I Have Included the Where Clause With Profile Option of Order Management. 

User May Change it as per their Requirement and/or Use Other Where Clause.

SELECT e.profile_option_name Profile,
  f.user_profile_option_name User_Profile_Name,
  c.application_short_name,
 DECODE(a.level_id,10001,'Site',10002,'Application',10003,'Resp',10004,'User') LevelSet_At,
  DECODE(a.level_id,10001,'Site',10002,c.application_short_name, 10003,b.responsibility_name,10004,d.user_name) LValue,
  NVL(a.profile_option_value,'Is Null') Value
FROM fnd_profile_option_values a,
  fnd_responsibility_tl b,
  fnd_application c,
  fnd_user d,
  fnd_profile_options e,
  fnd_profile_options_vl f
WHERE f.user_profile_option_name LIKE 'OM%'
AND e.profile_option_id = a.profile_option_id
AND e.profile_option_id = f.profile_option_id
AND a.level_value       = b.responsibility_id (+)
AND a.level_value       = c.application_id (+)
AND a.level_value       = d.user_id (+)
ORDER BY 1,2;



Order Management Interfaces

Order Import is the Order Management Open Interface used to Import Sales order and Returns from Legacy or Other System into Oracle Apps.

Orders Imported can be of Entered, Booked, Closed or Cancelled Status.

Order Import Includes the Interface to Create Internal Orders from Purchasing Module, Via Internal Requisition.

Features in Order Import Program

1. Defaulting 
2. Processing Constraints Validation
3. Order Hold (Apply or Release)
4. Scheduling
5. Insert. Update or Delete Orders/Lines
6. Create Sales Order With Valid Lines, Reservations, Price Adjustments and Sales Credits.
7. Multi Org Access Control Via Concurrent Parameter.

Interface Tables

 OE_CUSTOMER_INFO_IFACE_ALL
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
OE_RESERVTNS_IFACE_ALL
OE_ACTIONS_IFACE_ALL
ONT.OE_PAYMENTS_IFACE_ALL

Application Process Interface -API

 Process Order is the application process interface called by order import to validate, insert, update, Schedule and delete sales order and lines.

Order Import process one order with all lines at a time with process order API and completes the process of Validating, Inserting, Updating, Scheduling and/or Deleting the Sales order and Lines.






Thursday, 23 June 2016

Setting Up Inventory Organization for LCM



Set up Inventory organization options.
Navigation: Inventory ---> Setup --->Organization --->Parameters

LCM Enabled Flag Should be set to yes.

Limitations

1.       If LCM has to be enabled for a Process Manufacturing organization, Process manufacturing enabled flag should set Y Prior to Setting LCM Flag to Y. This is done to ensure proper integration of OPM and LCM Organization.
2.       Manufacturing partner, EAM or WCS organization cannot have LCM Enabled.


Go to Other Accounts Tab in Inventory parameters and complete the Details.


Wednesday, 22 June 2016

Setting Up Oracle Landed Cost Management



Setting up LCM:

Landed Cost Management (LCM) is considered as separate application Within Oracle E Biz. Hence a Part of Setup is done in Oracle Base Modules and a Part of Setup is done at LCM application.

Key Setups in Oracle E Biz 

1.       Set up Inventory organization options.
2.       Set up Receiving options
3.       Set up cost factors
4.       Set up Oracle Advanced Pricing profile options.

Key Setups in LCM application are

5.       Set up Landed Cost Management Options.
6.       Set up shipment line types.
7.       Set up shipment types
8.       Set up Landed Cost Management profile options.