190) How do you register a table and columns in Oracle Apps>
To register the table and columns in AOL the navigation is: Open Appliaction Developer---> Appliaction--->Database--->table.(In table mention the table name(which you want to register), user table name,columns,user column name). The table & columns which you are going to register should be present in your module specific schema
195) What can we find TEMPLATE.FMB file
$AU_TOP/forms/US
Template.fmb file can be found in AU_TOP resource directory. This file contains all the Common characterstics all the forms. And also Contains Diffrent libraries. like CUSTOM.pll,APPCORE,APPCOREE2,FNDSQF, JE,JL,JA,VERT,GLOBE etc.. And Template.fmb cotains Diffrent propery classes for all the objects. This Template.fmb can be used for developing the new form 55
196) What are the libraries attached to TEMPLATE form
The Template form required 19 .pll in 11i version. Those pll names are :
APPCORE.pll APPCORE2.pll FNDSQF.pll APPDAYPK.pll GLOBE.pll JE.pll JL.pll JA.pll VERT.pll GHR.pll PQH_GEN.pll PSAC.pll PSB.pll PSA.pll IGILUTIL.pll
IGILUTIL2.pll CUSTOM.pll GMS.pll FV.pll OPM.pll
197)What is Concurrent Programming
Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with on line operations to fully utilize your hardware capacity.
Use Concurrent Programming for
Long Running – Data intensive tasks such as Posting a Journal or generating a report.
198)What is the Role of Concurrent Managers
A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer.
199)What is AOL
Oracle Applications are constructed and maintained using the Application Object Library (AOL).
The Three main areas of AOL are
o Applications Security
o Operating Profile
o Concurrent Processing
1. What is the Flex field What are the types of Flex field
o Flex Field is “Flexible Field”
o A Flexfield is made up of Segments.
o Each segment has a name that can be assigned and has set of valid values.
o There are two types of Flex field Key Flex Field and Descriptive Flex Fields.
1. What are the tables related to flex field
o FND_FLEX_VALUES
o FND_FLEX_VALUE_SETS
o FND_FLEX_VALUES_TL
1. What is AD_DD package
AD_DD Package is used to register the Table, Columns, and Primary Key in Oracle Applications.
PROCEDURE REGISTER_TABLE
Arguments:
o P_APPL_SHORT_NAME
o P_TAB_NAME
o P_TAB_TYPE
o P_NEXT_EXTENT
o P_PCT_FREE
o P_PCT_USED
PROCEDURE REGISTER_COLUMN
Arguments
P_APPL_SHORT_NAME
P_TAB_NAME
P_COL_NAME
P_COL_SEQ
P_COL_TYPE
P_COL_WIDTH
P_NULLABLE
P_TRANSLATE
P_PRECISION
P_SCALE
1. What are the Special and Pair Flex Field
Special – Value Sets uses FlexField itself
Pair – Two Flex Fields together specifies a range of valid values.
1. What are the Translatable Dependent and Independent Flex Fields
Translatable Independent – Input must exist on previously defined set List of
Values. Translated value can be used. 57
Translatable Dependent means Input is checked against a subset of values
Based on a prior value. Translated value can be used.
1. What is FND_REQUEST.SUBMIT_REQUEST
Submits a Concurrent Request for Processing by a Concurrent Manager.
Arguments – Application,program,description,start_time,sub_request,arg1..
1. What is Client Info
By calling this Program in SQL PLUS or reports with correct parameters user can achieve concurrent program environment for testing.
FND_CLIENT_INFO.setup_client_info(application_id Number,
Responsibility_id Number,
User_id Number,
Security_Group_id Number);
1. Give the Directory structure in apps
$APPL_TOP - Product Directory- Version-
1. What are the steps in Registering Concurrent Program
o Go to Programs and Define Executables.
o Go to Programs and Define Concurrent Program
o Go to Responsibility and attach the Request group you want.
1. What are the different types of executable available in Concurrent Programming
o Host
o Oracle Reports
o PL/SQL Stored Procedures
o SQL LOADER
o SQL PLUS
o Spawned
o JSP
1. What are Request Sets
2. Request set is a collection of Reports/Programs that you group together and can be submitted to run is a single interaction.
1. What is Standard Request Submission (SRS Feature)
SRS provides you with a set of windows for running reports and Programs and a set of windows for creating groups of reports and programs to run together.
Features 58
o Specify whether reports or programs in a request set run sequentially or simultaneously
o Specify whether to continue with a request set if a report or program in a sequential set fails
o View a log file
o Specify alternative requests based on completion status of previously run requests in a request set.
1. What are the different API?s for Concurrent Programming
o FND_CONCURRENT
o FND_FILE
o FND_PROGRAM
o FND_SET
o FND_REQUEST
o FND_REQUEST_INFO
o FND_SUBMIT
1. What are the FlexField Qualifiers
A Flex field qualifier identifies a particular segment of a key flex field.
1. What are the Segment Qualifiers
A Segment Qualifier identifies a particular type of value in a single segment of a key flex field.
1. What is a Dynamic Insertion
Dynamic Insertion is the insertion of new valid combination into a Key Flexfields Combinations Table from a form other than the combinations form.
All Validation rules still will apply during insertion.
1. What are the different Level of Profiles
User Profiles are used
o To set options that affect your applications behavior o your preference.
o A Collection of changeable options that affect the way your applications run
o Modify Product Specific variables
o Gives Control over certain Oracle Applications features.
Profile Levels
Site Level
Application Level
Responsibility Level
User Level
Note: Site Level is the lowest level.
1. Explain Multi-Organization Structure
Set of book
A financial reporting entity that uses a particular chart of accounts, functional currency and accounting calendar.
Business Group This is highest level in the Organization Structure. The Business group secures HR Information. Multiple set of books can share same business group. Legal Entity A legal company for which you prepare fiscal or tax reports. Balancing Entity
Represents an accounting entity for which you prepare financial statements.
This is the segment in Accounting Flexfield.
Operating Unit
An Organization that Uses Oracle Cash Management, Order Management and shipping Execution, Oracle Payables, Oracle Purchasing, Oracle receivables.
It may be a Sales office division or a department. An Operating Unit is associated with legal entity.
Inventory Organization An Organization for which you track Inventory transactions and balances and/or an Organization that manufactures or distributes products. HR Organization
HR Organization represents the basic work structure of any enterprise. They usually represent Functional Management or reporting groups that exists within a business group.
1. How can u see Multi-Organization is enabled or not from SQL Prompt SELECT MULTI_ORG_FLAG FROM fnd_product_groups;
1. What are the two mandatory parameters required for PL/SQL stored Procedure Concurrent Program Errbuf and retcode two OUT Parameters are required while defining PL/SQL stored Procedure Concurrent Program.
Errbuf Returns any error messageand retcode returns completion status.
Retcode returns 0 for success, 1 for warnings and 2 for error.
1. Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i). Ans:- There are 8 types of Values Sets.
i. None (Non Validate at all) (Validation is Minimal)
j. Independent (Input must exist on previous defined list of values)
k. Dependent (Input is checked against a subset of values based on prior Value) 60 l. Table (Input is checked against a subset of values in an application table)
m. Special (advanced) (Value set uses a flexfield itself)
n. Pair (advanced) (Two Flexfields together specify a range of valid values)
o. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)
p. Translatable Dependent. (Input is checked against a subset of values based on a prior value; translated value can be used)
(Note:- When you first define your flexfields, you choose how many segments
You want to use and what order you want them to appear. You also
Choose how you want to validate each of your segments. The decisions
You make affect how you define your value sets and your values.)
1. How to run a concurrent program. What all concurrent programs u have created. Ans:- (Definition :- A concurrent program is an instance of an execution file, along with parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.)
Oracle Tool Concurrent Program A concurrent program written in
Oracle Reports, PL/SQL package procedures,
SQL Loader, SQL Plus, Host Scripting.
How to Run : Write a execution file and place in correct directory.
Establish executables in Oracle apps specify execution file and method.
Define Concurrent Program (Program, Parameters and Incompatibilities)
Call your Program (- Thu application form, from other concurrent program.
- OR through standard request submission, you must check the „USE in SRS check box? and register your program parameters when you define your concurrent program. Add your program into the request security group for your custom application.)
I have created reports through concurrent program, load(sql loader/pl-sql pkg-proc) the file through concurrent program.
To register the table and columns in AOL the navigation is: Open Appliaction Developer---> Appliaction--->Database--->table.(In table mention the table name(which you want to register), user table name,columns,user column name). The table & columns which you are going to register should be present in your module specific schema
195) What can we find TEMPLATE.FMB file
$AU_TOP/forms/US
Template.fmb file can be found in AU_TOP resource directory. This file contains all the Common characterstics all the forms. And also Contains Diffrent libraries. like CUSTOM.pll,APPCORE,APPCOREE2,FNDSQF, JE,JL,JA,VERT,GLOBE etc.. And Template.fmb cotains Diffrent propery classes for all the objects. This Template.fmb can be used for developing the new form 55
196) What are the libraries attached to TEMPLATE form
The Template form required 19 .pll in 11i version. Those pll names are :
APPCORE.pll APPCORE2.pll FNDSQF.pll APPDAYPK.pll GLOBE.pll JE.pll JL.pll JA.pll VERT.pll GHR.pll PQH_GEN.pll PSAC.pll PSB.pll PSA.pll IGILUTIL.pll
IGILUTIL2.pll CUSTOM.pll GMS.pll FV.pll OPM.pll
197)What is Concurrent Programming
Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with on line operations to fully utilize your hardware capacity.
Use Concurrent Programming for
Long Running – Data intensive tasks such as Posting a Journal or generating a report.
198)What is the Role of Concurrent Managers
A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer.
199)What is AOL
Oracle Applications are constructed and maintained using the Application Object Library (AOL).
The Three main areas of AOL are
o Applications Security
o Operating Profile
o Concurrent Processing
1. What is the Flex field What are the types of Flex field
o Flex Field is “Flexible Field”
o A Flexfield is made up of Segments.
o Each segment has a name that can be assigned and has set of valid values.
o There are two types of Flex field Key Flex Field and Descriptive Flex Fields.
1. What are the tables related to flex field
o FND_FLEX_VALUES
o FND_FLEX_VALUE_SETS
o FND_FLEX_VALUES_TL
1. What is AD_DD package
AD_DD Package is used to register the Table, Columns, and Primary Key in Oracle Applications.
PROCEDURE REGISTER_TABLE
Arguments:
o P_APPL_SHORT_NAME
o P_TAB_NAME
o P_TAB_TYPE
o P_NEXT_EXTENT
o P_PCT_FREE
o P_PCT_USED
PROCEDURE REGISTER_COLUMN
Arguments
P_APPL_SHORT_NAME
P_TAB_NAME
P_COL_NAME
P_COL_SEQ
P_COL_TYPE
P_COL_WIDTH
P_NULLABLE
P_TRANSLATE
P_PRECISION
P_SCALE
1. What are the Special and Pair Flex Field
Special – Value Sets uses FlexField itself
Pair – Two Flex Fields together specifies a range of valid values.
1. What are the Translatable Dependent and Independent Flex Fields
Translatable Independent – Input must exist on previously defined set List of
Values. Translated value can be used. 57
Translatable Dependent means Input is checked against a subset of values
Based on a prior value. Translated value can be used.
1. What is FND_REQUEST.SUBMIT_REQUEST
Submits a Concurrent Request for Processing by a Concurrent Manager.
Arguments – Application,program,description,start_time,sub_request,arg1..
1. What is Client Info
By calling this Program in SQL PLUS or reports with correct parameters user can achieve concurrent program environment for testing.
FND_CLIENT_INFO.setup_client_info(application_id Number,
Responsibility_id Number,
User_id Number,
Security_Group_id Number);
1. Give the Directory structure in apps
$APPL_TOP - Product Directory- Version-
1. What are the steps in Registering Concurrent Program
o Go to Programs and Define Executables.
o Go to Programs and Define Concurrent Program
o Go to Responsibility and attach the Request group you want.
1. What are the different types of executable available in Concurrent Programming
o Host
o Oracle Reports
o PL/SQL Stored Procedures
o SQL LOADER
o SQL PLUS
o Spawned
o JSP
1. What are Request Sets
2. Request set is a collection of Reports/Programs that you group together and can be submitted to run is a single interaction.
1. What is Standard Request Submission (SRS Feature)
SRS provides you with a set of windows for running reports and Programs and a set of windows for creating groups of reports and programs to run together.
Features 58
o Specify whether reports or programs in a request set run sequentially or simultaneously
o Specify whether to continue with a request set if a report or program in a sequential set fails
o View a log file
o Specify alternative requests based on completion status of previously run requests in a request set.
1. What are the different API?s for Concurrent Programming
o FND_CONCURRENT
o FND_FILE
o FND_PROGRAM
o FND_SET
o FND_REQUEST
o FND_REQUEST_INFO
o FND_SUBMIT
1. What are the FlexField Qualifiers
A Flex field qualifier identifies a particular segment of a key flex field.
1. What are the Segment Qualifiers
A Segment Qualifier identifies a particular type of value in a single segment of a key flex field.
1. What is a Dynamic Insertion
Dynamic Insertion is the insertion of new valid combination into a Key Flexfields Combinations Table from a form other than the combinations form.
All Validation rules still will apply during insertion.
1. What are the different Level of Profiles
User Profiles are used
o To set options that affect your applications behavior o your preference.
o A Collection of changeable options that affect the way your applications run
o Modify Product Specific variables
o Gives Control over certain Oracle Applications features.
Profile Levels
Site Level
Application Level
Responsibility Level
User Level
Note: Site Level is the lowest level.
1. Explain Multi-Organization Structure
Set of book
A financial reporting entity that uses a particular chart of accounts, functional currency and accounting calendar.
Business Group This is highest level in the Organization Structure. The Business group secures HR Information. Multiple set of books can share same business group. Legal Entity A legal company for which you prepare fiscal or tax reports. Balancing Entity
Represents an accounting entity for which you prepare financial statements.
This is the segment in Accounting Flexfield.
Operating Unit
An Organization that Uses Oracle Cash Management, Order Management and shipping Execution, Oracle Payables, Oracle Purchasing, Oracle receivables.
It may be a Sales office division or a department. An Operating Unit is associated with legal entity.
Inventory Organization An Organization for which you track Inventory transactions and balances and/or an Organization that manufactures or distributes products. HR Organization
HR Organization represents the basic work structure of any enterprise. They usually represent Functional Management or reporting groups that exists within a business group.
1. How can u see Multi-Organization is enabled or not from SQL Prompt SELECT MULTI_ORG_FLAG FROM fnd_product_groups;
1. What are the two mandatory parameters required for PL/SQL stored Procedure Concurrent Program Errbuf and retcode two OUT Parameters are required while defining PL/SQL stored Procedure Concurrent Program.
Errbuf Returns any error messageand retcode returns completion status.
Retcode returns 0 for success, 1 for warnings and 2 for error.
1. Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i). Ans:- There are 8 types of Values Sets.
i. None (Non Validate at all) (Validation is Minimal)
j. Independent (Input must exist on previous defined list of values)
k. Dependent (Input is checked against a subset of values based on prior Value) 60 l. Table (Input is checked against a subset of values in an application table)
m. Special (advanced) (Value set uses a flexfield itself)
n. Pair (advanced) (Two Flexfields together specify a range of valid values)
o. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)
p. Translatable Dependent. (Input is checked against a subset of values based on a prior value; translated value can be used)
(Note:- When you first define your flexfields, you choose how many segments
You want to use and what order you want them to appear. You also
Choose how you want to validate each of your segments. The decisions
You make affect how you define your value sets and your values.)
1. How to run a concurrent program. What all concurrent programs u have created. Ans:- (Definition :- A concurrent program is an instance of an execution file, along with parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.)
Oracle Tool Concurrent Program A concurrent program written in
Oracle Reports, PL/SQL package procedures,
SQL Loader, SQL Plus, Host Scripting.
How to Run : Write a execution file and place in correct directory.
Establish executables in Oracle apps specify execution file and method.
Define Concurrent Program (Program, Parameters and Incompatibilities)
Call your Program (- Thu application form, from other concurrent program.
- OR through standard request submission, you must check the „USE in SRS check box? and register your program parameters when you define your concurrent program. Add your program into the request security group for your custom application.)
I have created reports through concurrent program, load(sql loader/pl-sql pkg-proc) the file through concurrent program.
No comments:
Post a Comment