Entries by Oracle ERP Apps Guide

, ,

Shipped Quantity more than Ordered Quantity ???

If you find a case where Shipped Quantity more than Ordered Quantity, then you may control it using the shipment tolerance setup given below.Over or under shipment tolerance can be setup at at three levels. 1. Item Level (Highest precedence) 2. Customer Level 3. Profile Option (Lowest precedence): This can be setup at Site level.

, , , , , ,

Intercompany Invoicing Cycle

2.1. Intercompany Invoicing Cycle When a sales order is entered in an operating unit, and if the shipping warehouse is part of a separate operating unit (may also belong to another SOB), then the goods can be shipped from the said shipping organization and the selling organization generates a customer invoice. Also the system automatically records […]

, , , , ,

SQL Queries for checking Profile Option Values

The following queries are useful to get the profile option values of a profile option at site, application, responsibility and user level 1) Obtain Profile Option values for Profile Option name like ‘%Ledger%’ and  Responsibility name like ‘%General%Ledger%’ SELECT substr(pro1.user_profile_option_name,1,35) Profile, decode(pov.level_id, 10001,’Site’, 10002,’Application’, 10003,’Resp’, 10004,’User’) Option_Level, decode(pov.level_id, 10001,’Site’, 10002,appl.application_short_name, 10003,resp.responsibility_name, 10004,u.user_name) Level_Value, nvl(pov.profile_option_value,’Is Null’) […]