Customizing Quick Sales Order Form

We can customize this form for making more fields visible and making only the required fields visible.

Even we can use a query to pull the data and show in this form too.

Navigation:  Order Management à Orders, Returns à Quick Sales Order

From the Folder Tools option, select new folder and do the customization here

Now this will be saved as a private folder for you. But if you select as Public then this will be visible to others, they can use this for their form too.

If Open as Default is checked, then this Folder will open whenever you will open this Form.

Similarly you can do the same for Line Level too.

Making Folder Default for a responsibility

Navigate to the System Administrator Responsibility

Application à Administer Folder

Find and add the created folders for the responsibility

Save this.

Now when you will open the Quick Sales Order form in this Responsibility, this will open this folder by default

Read More

Concurrent Programs

1. How do you register a report? Explain passing of parameters between a concurrent program Definition and report?

        After developing the report (.rdf), FTP it to the UNIX server.

        Define executable.

        Define concurrent program and attach the executable.

        Attach the concurrent program to a request group.

2       2.    What is the approach to create a new form to be used in Oracle Apps?

The TEMPLATE form is the required starting point of all development of new forms. Start Developing each new form by copying the TEMPLATE.fmb file, located in $AU_TOP/forms/US(or your language and platform equivalent), to local directory and rename it as appropriate.

3. Explain Value Set? Difference between a Table Validated and Independent Value Set?

A set of values against which Oracle Application Object Library validates values your end users enter when running your program. You define your value set by specifying validation rules, format constraints and other properties. For example, you could define a value set to contain values that are character strings, validated from a table in your application. You can specify that oracle application Object Library use the same value set to validate different report parameters. You can also use value sets that you use in your flex fields to validate your report parameters.

4. How do you create a table validated value set dependent on another value set?

Use :$FLEX$.<Value set name> in the where condition.

5. What is difference between a concurrent request and a concurrent request set?

Concurrent request set is the combination of multiple requests which will run in a sequence.

6. What are the two mandatory parameters required for running a PL/SQL Procedure based concurrent program? 

         Errbuf, Retcode

7.    How can you ensure that only one instance of a concurrent program runs?

         Check the ‘Run Alone’ check box in Concurrent program registration window.

8.    Within a PL/SQL procedure which API is to be used to extract a profile value?

         FND_PROFILE.GET

9.    How do you set the operating unit context in a report?

          Begin

          Dbms_application_info.set_client_info(<Organization_Id>);

          End;

10. Can you submit a concurrent request from the operating system directly?

Write a Shellscript.

Login to database

Run the function FND_REQUEST.Submit()

11. Explain how to generate a trace file for a pl/sql concurrent program for tuning?

          Check the ’Enable Trace’ check box in concurrent program registration window.

12. How do you “write” to the concurrent request Log and Output file?

          FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, <Text>);

Read More

SYSADMIN and Application Developer

1.    What is the relation between Responsibility, Menu and Request Group?

Responsibility: - A responsibility is a set of authority in Oracle Apps that lets users access only that functionality of the application appropriate to their roles.

Menu: - A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it.

Request Group: - it is a collection of reports or concurrent programs. A system Administrator defines report groups in order to control user access to reports and concurrent programs. Only a system administrator can create a request group.

 

2. What is a function, how to create one?

A function is apart of an application’s functionality that is registered under a unique name for the purpose of assigning to it to, or excluding it from, a menu (and by extension, responsibility). There are several types of functions: - Form Functions, SubFunctions, and

Non-form functions. We often refer to a form function simply as a form.

3. What is meant by APPL_TOP?

Environment variable

An operating System variable that describes an aspect of the environment in which your application runs. For example, you can define an environment variable to specify a directory path.

$APPL_TOP: An environment variable that denotes the installation directory for Oracle Application Object Library and your other Oracle applications. $APPL_TOP is usually one directory level above each of the product directories (which are often referred to as $PROD_TOP or $PRODUCT_TOP or $<prod>_TOP).

4. Explain briefly where are the Custom.pll, Forms, Reports, Sql Loader Control files, Shell

     Script source code and executables files kept?

     Custom.pll - $AU_TOP/resource

     Forms       - $PROD_TOP/Forms/US

     Reports     - $PROD_TOP/Reports/US

     SQL Control Files - $PROD_TOP/Bin

     Shell Scripts - $PROD_TOP/Bin

5. When is Custom.pll used?

Custom.pll is used while making new or customizing standard oracle forms in apps. It contains all the forms libraries for apps.

6. What are profile options; at what levels can these be set?

     A user profile is a set of changeable options that affects the way the applications run. Oracle

     Applications object Library establishes a value for each option in a user’s profile when the

     User logs on or changes responsibility.

     System Profile: - Profile option can be set for the user community.

     User Profile: - Provide Oracle Apps with standard information which describes a user,

     Application, Responsibility and site. At each profile level user profile options can be set.

    

7. How can you know the form (fmb) name when you open a form in Apps?

Helpà About Oracle Apps

    

8. Where do you create a table and sequence in Apps? Is it APPS schema?

       In custom schema and then grant privileges on it to APPS schema.

9. Where are Views and Procedures created?

Views: - Views are to be created only in APPS.

Procedures: - In custom schema and the grant it to APPS schema.

    

10. How can you tell who last updated a particular row in a form?

Help à Record History

     

     11. You have logged onto a Responsibility, how do you know what operating unit are you on?

 Help à Diagonistics à Examine à Blocks à $Profiles$ à Field à Org_id

12.  Can new profiles be created? If so how?

 Yes. Application Developer.

Read More