Entries by Oracle ERP Apps Guide

, , , , , ,

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’) […]