Find out the URL of the Application in the database

If you want to find out the URL of the Application in the database in which table you can check ?

Option 1:
select * from icx_parameters

Option 2:

SELECT PROFILE_OPTION_VALUE
  FROM FND_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
                                                             FROM FND_PROFILE_OPTIONS
                                                           WHERE PROFILE_OPTION_NAME ='APPS_FRAMEWORK_AGENT')
                                                                AND LEVEL_VALUE=0

Thanks & Regards,
Anto Joe Natesh I

I'm getting a Yellow Warning Bar. How do I get rid of this?

1. Yellow Warning Banners
       a. What Does "Warning: Applet Window" Mean?
      Oracle Applications Release 11.5.1 (11i) requires that its code run in a trusted mode, and uses J-Initiator to run Java applets on a desktop client. If an applet is "trusted," however, Java will extend the privileges of the applet. The Yellow Warning Bar is a warning that your applet is not running in a trusted mode. To indicate that an applet is trusted, it must be digitally signed using a digital Certificate, so Oracle Applications requires that all Java archive files must be digitally signed.

      b. Who Does This Affect?

      This affects all users that try to access Oracle Applications Rel 11i using Jinitiator that have a different identitydb.obj on their client. Clients have an "identity database" that is maintained by J-Initiator called IDENTITYDB.obj.
      When a jar file is downloaded, the owner of the digital signature is compared against the entry in the identity databases. If they match, the code contained in the archive is allowed to run in a trusted mode. The users will need to fix their client PC in one of two ways:
        i.
           a. Uninstall Jinitiator and clear browser cache
           b. Log back into Applications to get the new plugin,(oajinit.exe) including the new identitydb.obj
           c. Install the Jinitiator on the Client PC and then Log into the Oracle Applications to download the new signed JAR files
       OR
        ii.
           a. Copy the IDENTITYDB.OBJ file to C:\Program Files\Oracle after saving the old one as IDENTITYDB.old.

Thanks & Regards,
Anto Joe Natesh I

Useful Queries

Friends, Here are some useful queries.

1. Database and Application Information?
http://retoscripts.blogspot.com/2009/09/database-and-application-information.html

2. Get onhand quantity at given date
http://retoscripts.blogspot.com/2009/09/onhand-quantity-at-given-date.html

3. Link Purchase Order and Requisition
http://retoscripts.blogspot.com/2009/09/link-purchase-order-and-requisition.html

4. Different Types of Table in Oracle Apps
http://retoscripts.blogspot.com/2009/09/different-types-of-table-in-oracle-apps.html

5. Which User is Locking the table?
http://retoscripts.blogspot.com/2009/09/which-user-is-locking-table.html

6. Query for Customer Receipt Details
http://retoscripts.blogspot.com/2009/09/query-for-customer-receipt-details.html

7. Query for Supplier Bank Details
http://retoscripts.blogspot.com/2009/09/query-for-supplier-bank-details.html

8. Query for Customer Address Details
http://retoscripts.blogspot.com/2009/09/query-for-customer-address-details.html

9. Query for Sales Order Details
http://retoscripts.blogspot.com/2009/09/query-for-sales-order-details.html

10. Query to get Request Group Details Responsibility wise
http://retoscripts.blogspot.com/2009/09/query-to-get-request-group-details.html

11. Query to find who and when update an Oracle Application user's profile
http://retoscripts.blogspot.com/2009/09/query-to-find-who-and-when-update.html

Thanks & Regards,
Anto Joe Natesh I

Query Tips and Tricks

Most of our technical consultants used to write query fastly to find out number of records in a table, and find out the number of records between.

here are some tips to find out from the front end itself.

Query Wild Card Characters using "%" and "_". Now we will see the difference between this.

% - one or more characters

_ - exactly one character

Examples:

'AS64%' returns AS64000 or AS64001

'AS6_4%' returns AS61400 or AS62400, but not AS64000 / AS64001

Query Operators

a) #between <> and <> 

b) #is null

c) #is not null

d) > 

e) >=

f) <

g) <=

h) =

i) !=

Examples: In sales order screen

a) #between 10 and 20 => (Query in Sales order number field) it will return the sales order number between 10 to 20

b) #is null => (Query in Customer Contact field) it will return the sales order which do not have customer contact information

c) #is null => (Query in Customer Contact field) it will return the sales order which have customer contact information

d) >20 => (Query in Sales order number field) it will return the sales order number greater than 20

e) >=20 => (Query in Sales order number field) it will return the sales order number 20 and greater than 20

f) <20 => (Query in Sales order number field) it will return the sales order number less than 20

g) >=20 => (Query in Sales order number field) it will return the sales order number 20 and less than 20

h) =20 => (Query in Sales order number field) it will return the sales order number 20

i) !=20 => (Query in Sales order number field) it will return the sales order number except 20

Count Record: 

After you execute the query. Now you want to find out the number of records in the last query.

Example:

First press F11 in sales order screen then enter this in sales order number field #between 10 and 20. execute using CONTROL + F11, It will return the sales order number between 10 to 20. Now press F12, this will return number of records parsed now.

Last Query:

You gave some input and query the records in the form. Now you want to find out, which query executed to get this details.

   Help : Diagnostics : Examine

   Block = SYSTEM

   Field = last_query

(requires apps password if the Profile Option Utilities:Diagnostics is set to Yes)

Other ways to determine the underlying table structure:

1) Help : Record History

2) Trace the form (requires apps password and DBA to retrieve trace file)

Uploading Images using sql loader

Dears,


Here i am going to explain about how to import images using sqlloader. 
Let me take the HRMS employee images load into per_images.


SQL> desc per_images

Name                            Null?    Type
——————————- ——– —-
IMAGE_ID                        NOT NULL NUMBER(15)
IMAGE                           NOT NULL BLOB
PARENT_ID                       NOT NULL NUMBER(15)
TABLE_NAME                      NOT NULL VARCHAR2(30)
--===============================================

Assume, we are importing image for the employee number 20063. image name is 20063.jpg

IMAGE_ID   – Next value in sequence(per_images_s.nextval)
IMAGE      – Binary Image(20063.jpg)
PARENT_ID  – PERSON_ID (select person_id from PER_ALL_PEOPLE_F where employee_number = 20063 and sysdate between effective_start_date and effective_end_date)
TABLE_NAME – PER_PEOPLE_F (default)

First let us make the data file for this employee 20063. 
-------------------------------------------

SELECT  PER_IMAGES_S.nextval
       || ','
       || person_id
       || ','

       || 'd:\images\'

       || employee_number
       || '.jpg'
  FROM per_all_people_f
 WHERE  EFFECTIVE_END_DATE >= sysdate-1
 AND employee_number IN ('20063')


Now the data file look likes:-
6482,101,PER_ALL_PEOPLE_F,d:\images\20063.jpg


Creating Control file for our data file:-
load data

 infile *
 replace
 into table per_images
 fields terminated by ","
 ( IMAGE_ID,PARENT_ID,TABLE_NAME,IMAGE LOBFILE (TABLE_NAME) TERMINATED BY EOF  )
begindata
3061,101,d:\images\20063.jpg

Here, I have used the TABLE_NAME column for storing my image file path. After successful completion of the sql loader execution update the column value into PER_PEOPLE_F.


client machine they have already installed sqlloader. So i refer the local machine path. Suppose if you are accessing the server through putty or some other tool to access server. Use server folder location instead.


If you have any clarifications please let me know.


Cool,
AntO.

Calculating Weekdays between two dates

Calculating total number of Week Days between two given dates is most common requirement. 


This link shows one methods to achieve this.
http://retoscripts.blogspot.com/2009/09/calculating-weekdays-between-two-dates.html


Cool,
AntO.

Difference Between Application and Responsibility

Applciation is nothing Colletion of Forms,Reports and Program which are related for
specific business functionality.

Responsibility is nothing but Colletion of Forms,Reports and Program which are related for
specific Position in the Organization.

For Ex : We have to create One Responsibility For the Finance Asst. Which is accesable by all
the Finance Assts.
It Contains the Forms and Reports which are required for the Finance Asst.

We have to Create new Responsibility for the Manager,Which is accesable by all the Managers.
It Contains the Forms and Reports which are required for the manager.

Where as Application includes all the Forms,Reports and Programs.If we assign the application to the user he will access all the forms and Reports.
Instead of that we will create the responsibility and we will assign to the User.

Cool,
AntO.