f Get Oracle Apps Traning Here: December 2006
Main Menu
Techie or Funcy ?
Prerequisites
Training Index   

Interview Qns
Apps Interview Qns
HRMS Interview Qns

COPYRIGHT
This work is licensed under a Creative Commons -NonCommercial 2.5 License.



About Me

Name:
Location: United Kingdom

The desire to be extraordinary is a very ordinary desire. To relax and to be ordinary is really extraordinary

  • Subscribe for Emails

    • Previous Posts

    Archives

    Wednesday, December 06, 2006

    Value Sets In Oracle Apps

    Many thanks to Rakesh Sreenivasa for contributing yet another article for Get Apps Training


    Value Sets

    Value Set is a collection of values. It validates the values entered by the user for a flex-field, report parameters or a concurrent.

    The navigation path: Application :- Validation :- Sets

    Value Set is associated with the following validations which holds the key to the value sets.

    Types of Validations:

    1. None :- Validation is minimal.


    1. Independent :- The data input is based on previously defined list of values.


    1. Dependent :- The data input is checked against a defined set of values.



    1. Table :- The data input is checked against values in a table.



    1. Special :- The data input is checked against a flex-field.



    1. Pair :- The data input is checked against two flex-field specified range of values.



    1. Translatable independent :- The data input is checked against previously defined list of values.


    1. Translatable dependent :- The data input is checked against defined set of values.

    Significance of $FLEX$

    $FLEX$: enables to match the prior segment with either value set name or segment name.

    Let v2 be the value set definition of 2nd parameter and v1 be the value set definition for the first parameter then

    In the value set definition of v2 = value $FLEX$.v1

    Note:

    Changes You Should Never Make

    You should never make these types of changes (old value set to new value set) because you will corrupt your existing key flex-field combinations data:

    . Independent to Dependent

    . Dependent to Independent

    . None to Dependent

    . Dependent to Table

    . Table to Dependent

    . Translatable Independent to Translatable Dependent

    . Translatable Dependent to Translatable Independent

    . None to Translatable Dependent

    . Translatable Dependent to Table

    . Table to Translatable Dependent

    posted by Anil Passi at 11:10 PM 51 comments

    Tuesday, December 05, 2006

    Oracle Payroll Elements with Element Links

    Please find an article that explains with examples why Elements are used in Oracle Payroll, and what they actually mean.


    LINK FOR ORACLE PAYROLL ELEMENT & ELEMENT LINKS

    posted by Anil Passi at 6:02 PM 0 comments

    Monday, December 04, 2006

    Enable Audit Trail in APPS - Oracle

    This article explains how to create Audit Groups using System Administrator, to generate audit trail on any Oracle Apps Table


    LINK FOR ORACLE APPS AUDIT TRAIL ARTICLE

    posted by Anil Passi at 3:56 PM 0 comments

    Profile Options Hierarchy in Oracle

    A new article has been added to explain Hierarchy Profile Options in Oracle Apps.
    This feature was delivered in version 11.5.9

    It covers the relationship between Site Level Profile, Application Level Profile, Responsibility Level Profile, User Level Profile Options, Server Level Profile Options, User Level Profile Options and Organization Level Profile Options

    LINK FOR HIERARCHY PROFILE OPTIONS IN ORACLE

    posted by Anil Passi at 3:53 PM 1 comments

    Oracle Java Concurrent Programs

    I have written an article on Oracle Java Concurrent Programs.

    This article contains:-
    1. Sample code for developing Interface with non-Oracle database using Java Concurrent Program
    2. How do report messages in Output or the Log file of Java Concurrent Program
    3. How to make Java Concurrent Program end with warning.
    4. How to set CLASSPATH Of Java Concurrent Program in Oracle

    LINK FOR ORACLE JAVA CONCURRENT PROGRAM


    Many Thanks,
    Anil Passi

    posted by Anil Passi at 3:48 PM 0 comments