Oracle Jobs For Freshers

How to get oracle job as Fresher?
Well the answer for this  is there are ways to enter in the ocean of Oracle.
You can enter as a Oracle DBA, Oracle Apps DBA, Oracle D2k Developer, Oracle Apps Developer,Oracle Apps Functional, a lot of ways to enter in this big Ocean.
It just depends on your own way to choose then dive in to it.
Lets start with where the most opportunity lies as an oracle developer it could be either Oracle D2k Developer or Oracle Apps Technical.
As a  Oracle D2k Developer the basic things one require to know is SQL, PL-SQL, D2k Forms and Reports (6i,10g).
As a  Oracle Apps Technical you must know all of above technologies with Oracle apps modules such as financial  (AP,AR,GL,PO).
To be continue ...

How to create value set with distinct values

The problem  is  while creating a "Table Value Set" the value set  showing duplicate data.

Here is the solution for the problem.
 While creating the value set we can write a sql query in the table name.

Example: We are creating a Receipt number value set from table rcv_shipment_headers

Step 1. create the value set with all mandatory fields.

Now click on edit information:

Then write the sql query : (select distinct receipt_num from  rcv_shipment_headers)a in table name field.
Table columns Value : a.receipt_num

 

Click Test and done.

Value Set in oracle Apps

What is value set in oracle application ?

Value set is a set or collection of different values.It also validates the value of item entered in attached flexfield segments.
Value set can be used in keyflexfileds, Descriptive flexfields and Concurrent program parameters ( Oracle Reports).

How to create Value Set in oracle Apps r12?
Navigate to system administrator or Application developer Responsibility ->Application -> validation ->Set.

  Set ->

Types of Value Sets:

1.Dependent
2.Independent
3.Table
4.None
5.Pair
6.Special
7.Translatable dependent
8. Translatable Independent

Now lets create a table value set for invoice number by using table 'RA_CUSTOMER_TRX_ALL'
Value Set name : XX_invoice_number
List Type : List of Values
Format type : Char
Maximum size : 20
Validation type : Table

Click on Edit Information:

Choose the table name from the Table Name LOV : RA_CUSTOMER_TRX_ALL
Table Application : Receivables
Value : Choose the column name of table : TRX_NUMBER
SIZE : 20

Click on Test to confirm .

Table Value set has been created.