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

FLEX FIELD

What is the difference between key flexfield and Descriptive flexfield?

Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number, a cost centre etc
Desc Flex is used to just capture extra information.
Key Flexfields have qualifiers whereas Desc Flexfields do not.
Desc Flexfields can have context sensitive segments while Key flexfields cannot.

And one more differenct that KFF displays like text item but DFF displays like [ ] .

Which procedure should be called to enable a DFF in a form?

FND_DESCR_FLEX.DEFINE

(BLOCK                                 => 'BLOCK_NAME'
                ,FIELD                                    => 'FORM_FIELD_NAME'
               ,APPL_SHORT_NAME      => 'APP_NAME'
               ,DESC_FLEX_NAME         => 'DFF_NAME'
               );

In Brief,

We need to follow the following steps in your form:
a) Create a displayed field to hold your concatenated segment values (the [ ] field).
b) Create fields (normally hidden) for each of the flexfield columns in your table (the

      one used for your flex).
c) In the form-level WHEN-NEW-FORM-INSTANCE,

call FND_DESCR_FLEX.DEFINE,

setting BLOCK parameter to the name of the block containing your [ ] field,

the FIELD parameter to the name of your [ ] field,

the APPL_SHORT_NAME parameter to the short name of your application and the DESC_FLEX_NAME parameter to the name of your descriptive flex.

In the form-level WHEN-NEW-ITEM-INSTANCE,

WHEN-VALIDATE-ITEM,

PRE-INSERT,

PRE-UPDATE,

POST-QUERY and

PRE-QUERY triggers place a call to FND_FLEX.EVENT as follows:

         FND_FLEX.EVENT ( 'TRIGGER_NAME');
where TRIGGER_NAME is the name of the trigger,

e.g. in the PRE-QUERY trigger .... FND_FLEX.EVENT('PRE-QUERY');

Which procedure should be used to make the DFF read only at run time?

FND_DESCR_FLEX.UPDATE_DEFINITION()

What is the difference between flexfield qualifier and segment qualifier?

Flexfiled qualifier identifies segement in a flexfield and segment qualifier identifies value in a segment.

There are four types of flexfiled qualifier

1)     Balancing segment qualifier

2)     cost center

3)     natural account and

4)     intercompnay

segemtn qualifier :-

1)     allow budgeting

2)     allow posting

3)     account type

4)     contral account and

5)     reconciliation flag

What are the components of DFF (like structure, segment)?
Howmany Key flexfiels are there in Inventory?
What is Value Set?
Value Sets define and store the valid items of data, which may be entered into a field. Key Flexfields, Descriptive Flexfields and many standard fields use Value Sets. Oracle already comes with hundreds of Value Sets. We define additional Value Sets to support our own user-defined Key and Descriptive Flexfields (although we may use any existing standard Value Sets if they suit our purpose). In defining a new Value Set, we are defining the physical format of valid data, which can reside in that Value Set. Data in a Value Set can be of several types: 

•  Independently loaded into a Value Set (through a standard form). 
•  Resident in a table (to which we direct the Value Set definition). 
•  There could be No Validation (any data can go into the field, but still subject to the formatting rules.) 
•  Dependent on the value of data in a preceding Independent segment (loaded through a standard form). 

Ex: For Supplies & Accessories CC in ATP, we define GEMS_GPO_ASSIGN_SET value set for the assignment set associated with that OU.

Read More

1. Enter Order in OM (Customer, Order type, Pricelist, shipping details, etc)
2. Enter the Items details and sourcing details in Order Line
3. Check for the availability and Book the Order
4. Schedule and Reserve the Order
5. Pick Release the Order (Reports here: Pick Selection List Generation, Pick Slip Report, Shipping Exception Report)
6. Ship confirm the order in Shipping transaction form (Reports here: Bill Of Ladding, Packing Slip Report, Commercial Invoice, Vehicle Load Sheet Details, Interface Trip Stop)
7. Line Status become Interfaced in Shipping Transaction form
8. Sales Order Line status will be Shipped
9. Run Workflow Background Concurrent request to close the workflow which in turn will close the order line.
10. This will trigger Autoinvoice Master program (inturn it will run Autoinvoice Import Program)
11. Then will trigger Prepayment Matching Program
12. Invoice (Transaction#) can be found in Account Receivables
13. After getting the Cash from customer, Create the Receipt.
14. After creation of the receipt, match the receipt with the invoice transaction
15. Once the receipt is matched, then the data can be transferred to General Ledger by running General ledger Transfer Program.
16. Then Journal can be Imported in GL by Import Journals
17. Then Journals can be posted to GL by Post Journals.

Read More

Order Import Interface (Sales Order Conversion)

Interface Tables

OE_HEADERS_IFACE_ALL

OE_LINES_IFACE_ALL

OE_ACTIONS_IFACE_ALL

OE_ORDERS_CUST_IFACE_ALL

OE_PRICE_ADJS_IFACE_ALL

OE_PRICE_ATTS_IFACE_ALL

Base Tables

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

QP_PRICING_ATTRIBUTES

Concurrent Program:

Order Import

API

OE_ORDER_PUB.GET_ORDER and OE_ORDER_PUB.PROCESS_ORDER

Item Import

Interface Tables

MTL_SYSTEM_ITEMS_INTERFACE

MTL_ITEM_REVISIONS_INTERFACE

MTL_ITEM_CATEGORIES_INTERFACE

MTL_INTERFACE_ERRORS

Concurrent program:

Item Import

Base Tables:

MTL_SYSTEM_ITEMS_B

MTL_ITEM_REVISIONS_B

MTL_CATEGORIES_B

MTL_CATEGORY_SETS_B

MTL_ITEM_STATUS

MTL_ITEM_TEMPLATES

Inventory Onhand Quantity

Interface Tables

MTL_TRANSACTION_INTERFACE

MTL_TRANSACTION_LOTS_INTERFACE

MTL_SERIAL_NUMBERS_INTERFACE

Concurrent Program:

Can be submitted in Transaction Manager through Interface Manager

API

INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS

Base Tables:

MTL_ONHAND_QUANTITIES

MTL_LOT_NUMBERS

MTL_SERIAL_NUMBERS

Customer Conversions

Interface Tables

RA_CUSTOMERS_INTERFACE_ALL

RA_CUSTOMER_PROFILE_INT_ALL

RA_CONTACT_PHONES_INT_ALL

RA_CUSTOMER_BANK_INT_ALL

RA_CUST_PAY_METHOD_INT_ALL

Base Tables

RA_CUSTOMERS

RA_ADDRESSES_ALL

RA_CUSTOMER_RELATIONSHIPS_ALL

RA_SITE_USES_ALL

Concurrent Program

Customer Interface

API

Trading Community Architecture uses the APIs to create the customers too

APIs are

Set the organization id

Exec dbms_application_info.set_client_info(<org_id>);

Create a party and an account

HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT

HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE

HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE

HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

Create a physical location

HZ_LOCATION_V2PUB.CREATE_LOCATION()

HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

Create a party site

HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE()

HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

Create an account site

HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE()

HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE

Create an account site use

HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE()

HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE

HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

Base Tables

HZ_PARTIES

HZ_PARTY_SITES

HZ_LOCATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES_ALL

HZ_CUST_ACCT_SITES_ALL

HZ_PARTY_SITE_USES

Auto Invoice Interface

Interface Tables

RA_INTERFACE_LINES_ALL

RA_INTERFACE_SALESCREDITS

RA_INTERFACE_DISTRIBUTIONS

RA_INTERFACE_ERRORS

Base Tables

RA_BATCHES

RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_LINES_ALL

AR_PAYMENT_SCHEDULES_ALL

RA_CUSTOMER_TRX_LINE_SALESREPS

RA_CUST_TRX_GL_DIST_ALL

RA_CUSTOMER_TRX_TYPES_ALL

Concurrent Program

Auto invoice master program

Requisition Import

Interface Tables

PO_REQUISITIONS_INTERFACE_ALL

PO_REQ_DIST_INTERFACE_ALL

Base Tables:

PO_REQUISITIONS_HEADERS_ALL
PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

Concurrent Program:

Requisition Import

Purchase Order Conversions

Interface Tables:

PO_HEADERS_INTERFACE

PO_LINES_INTERFACE

PO_DISTRIBUTIONS_INTERACE

PO_INTERCAE_ERRORS

Concurrent Interface Program:

Import Standard Purchase Orders

Base Tables:

PO_HEADERS_ALL

PO_LINES_ALL
PO_DISTRIBUTIONS_ALL
PO_LINE_LOCATIONS_ALL

Read More