Query to check Profile Option Value

SELECT

    substr(pro1.user_profile_option_name,1,35) Profile,

    decode(pov.level_id,

    10001,'Site',

    10002,'Application',

    10003,'Resp',

    10004,'User',null) Option_Level,

    decode(pov.level_id,

    10001,'Site',

    10002,appl.application_short_name,

    10003,resp.responsibility_name,

    10004,u.user_name,null) Level_Value,

    nvl(pov.profile_option_value,0) Profile_option_Value

FROM 

    fnd_profile_option_values pov,

    fnd_responsibility_tl resp,

    fnd_application appl,

    fnd_user u,

    fnd_profile_options pro,

    fnd_profile_options_tl pro1

WHERE 1=1

    and pro1.user_profile_option_name like ('Viewer%')

    and  pro.profile_option_name = pro1.profile_option_name

    and  pro.profile_option_id = pov.profile_option_id

    --and  resp.responsibility_name like '%PO_Super_User%'

    and  pov.level_value = resp.responsibility_id (+)

    and  pov.level_value = appl.application_id (+)

    and  pov.level_value = u.user_id (+)

order by 1,2

Salam Black_id's Zone :)

Oracle E-Business Suite

Oracle Corporation's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines often known by short acronyms.
Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer,Jinitiator and Sun's Java).

Products included in the suite include:

• Accounts payable (AP)
• Accounts Receivables (AR)
• General Ledger
• Order Management (OM)
• Oracle CRM
• Oracle Financials
• Oracle HRMS
• Oracle Mobile Supply Chain Applications
• Oracle Order Management
• Oracle Procurement
• Oracle Property Manager
• Oracle Project Portfolio Management
• Oracle Quotes
• Oracle Transportation Management
• Oracle Warehouse Management Systems
• Oracle Inventory Management (INV)
• Oracle Enterprise Asset Management
• Shipping Execution (WSH)

Each product comprises several modules, each separately licensed.

Oracle Corporation's Supply Chain Managements (SCM) domain within the Oracle E-Business Suite contains business suites for:

• Advanced procurement
• Value-chain execution
• Product lifecycle management
• Asset lifecycle management
• Manufacturing, value-chain planning
• Order fulfillment

Reference : Wikipedia 

Salam Black_id's Zone :)

How To Turn Off Low-Level Diagnostic Logging

Problems :

Oracle APPS getting slowly? There's a sentence shows "Low-level Diagnostic Logging is turned on. This may temporarily reduce performance"? How can this be disabled / turned off?

Solution :

Disable diagnostic logging with the following steps:

1. Login as a user with System Administrator responsibility and then navigate to:  Profile > System.
Set the following profile option at the User level:

FND: Debug Log Enabled = No

2. Logout of the application. You may also want to clear the browser's cache.

3. Login again and confirm that the message no longer appears.

Cheers ^_^

reference : Oracle Support (Doc ID 1326490.1)

Salam Black_id's Zone :)

How To Show Blob Image Data from Oracle Database in RTF File Using BI Publisher

Hello guys,

now i just wanna share my little tips to show Blob Image data in RTF File using BI Publisher.

The steps are :

1. Create a function to decode BLOB Image data into CLOB data

CREATE OR REPLACE FUNCTION APPS.getbase64( p_source BLOB )

RETURN CLOB

IS

v_result CLOB;

BEGIN

DBMS_LOB.createtemporary(lob_loc => v_result, CACHE => FALSE, dur => 0);

Wf_Mail_Util.EncodeBLOB ( p_source, v_result);

RETURN ( v_result );

END getbase64;

2. Use the function created before in report query with the Blob Image data as parameter that can be retrieve from FND_LOBS table, 'FIELD_DATA' column

example :

Select getbase64(fl.file_data) as “IMAGE_CLOB”

From fnd_lobs fl

Where . . . . . .

3. Show it in RTF file using this below script 

<fo:instream-foreign-object content-type=”image/jpg”><xsl:value-of select=”.//IMAGE_CLOB”/></fo:instream-foreign-object>

Perhaps, it can be useful for you guys.

Thanks

references : http://ediyanto83.wordpress.com/2009/05/21/blob-images-in-xml-publisher/

Salam Black_id's Zone :)