152). Auto Lockbox is a three-step process, what are those
A. a) Import
b) Validation
c) PostQuickCash
153). What is the order in which Autolock box searches for the types of the matching number
A. 1. Transaction Number
2. Sales Order Number
3. Purchase Order Number
4. Consolidated Billing Invoice Number
5. Other, user-defined number.
154. What is application short name for General Ledger you specify in FND FLEXSQL user exit
A. SQLGL
155) . What are validations to be done in Journal Import interface.
A. Batch level: Set of Books, Period Name, and Batch Name
Journal Level: Set of books, Period name, Source name, Journal entry name, Currency code, Category name, Actual flag, Encumbrance type ID, User conversion type, Accounting date, Budget version ID
156) What subclass in forms6i 48
A Specifies module, storage & name information about the source object and source module for a referenced objects.
157) What is the clause in SQL Loader to program to override data into table
A. REPLACE
158). How do you set profile in oracle applications In Application Developer responsibility
A Open „Profile? Function
159). What is the syntax for loading data through SQL Loader from multiple files simultaneously
A. Sqlldr scott/tiger@orcl control = ctlfile
parfile -- parameter file: name of file that contains parameter specifications
parallel -- do parallel load (Default FALSE)
160) What is the table name for items in Oracle Inventory
A MTL_SYSTEM_ITEMS, MTL_CATEGORIES
161). Tell me names of important production tables & their purpose AP, AR, GL, PO
A AP: AP_INVOICES_ALL, AP_INVOICE_LINES_ALL
To store invoices
AR: RA_SHIPMENT_HEADERS/ _LINES, RA_CUSTOMERS, RA_CONTACTS
PO: PO_VENDORS, PO_VENDOR_SITES - For storing vendor data.
162). Name the interface tables used for the LockBox Interface
A Interface table : AR_PAYMENTS_INTERFACE_ALL
Lockbox transfers the receipts that pass validation to the Receivables interim tables AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL
When you run Post QuickCash, the receipt data is transferred from the QuickCash tables to the following Receipt tables:
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_APPLICATIONS_ALL
AR_CASH_RECEIPT_HISTORY_ALL
163) Name the interface tables used for the Auto Invoice Interface.
A Auto Invoice transfers transaction data from the interface tables
RA_INTERFACE_LINES_ALL,
RA_INTERFACE_SALESCREDITS_ALL, and
RA_INTERFACE_DISTRIBUTIONS_ALL
into the following Receivables tables:
• RA_BATCHES_ALL
• RA_CUSTOMER_TRX _ALL
• RA_CUSTOMER_TRX_LINES _ALL
• RA_CUST_TRX_LINE_GL_DIST_ALL
• RA_CUST_TRX_LINE_SALESREPS_ALL
• AR_PAYMENT_SCHEDULES_ALL
• AR_RECEIVABLE_APPLICATIONS_ALL 49
• AR_ADJUSTMENTS_ALL
164). 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.
a. None (Non Validate at all) (Validation is Minimal)
b. Independent (Input must exist on previous defined list of values)
c. Dependent (Input is checked against a subset of values based on prior Value)
d. Table (Input is checked against a subset of values in an application table)
e. Special (advanced) (Value set uses a flexfield itself)
f. Pair (advanced) (Two Flexfields together specify a range of valid values)
g. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)
h. 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.)
165) 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.
166) What is parameter in apps and from where u can create it.
Ans:- Parameters only using in report, you can create in defining the report in
apps (you can create the parameter there only).
167)What all are the tables used in the modules u have worked on.
In GL – I have worked on GL_JE_HEADERS(JOURNALS HEADER),GL_JE_LINES(JOURNAL LINES), GL_JE_BACHES(JOURNAL BATCHES), GL_SET_OF_BOOK(SET_OF_BOOK_ID),
In PO- I have worked on PO_HEADER_ALL…..
168)What is Profile Explain different levels of Profile.
Ans:- A user profile is a set of changeable options that affects the way your
applications run. Oracle Application Object Library establishes a value
for each option in a user?s profile when the user logs on or changes 50
responsibility. Your user can change the value of profile options at any
time a) To create Profile Option. ( Profile Option can created by developer in application developer area) b)set the value (Values of the profile option , who will have what value at various levels is set by SYSADMIN). Oracle Application Object Library provides many options that. (Edit profile feature for every user is available to set any value to allow the user).your users can set to alter the user interface of your applications to satisfy their individual preferences.
Profile Option – set at run time like – User Related, responsibility, Sequence, Printer, Security.
Values in 4 Levels(HIEARCHY WISE) :-
A. USER
B. RESPONSIBILITY
C. APPLICATION
D. SITE
Application Developer create the profile.
System Administrator make profile option.
(NOTE:- If any change in value, it will active when you re-login or switch
to the responsibility.)
( Usage in the multi-tier, the profile is biggest impact)
169)How to restrict the data for a responsibility as per the ORG-ID
Ans:-Through Multi – Org(MO) u can restrict the data for a responsibility as per the ORG-ID. Only in GL- Set of book Id you set the value to restrict the data for a responsibility.
170) What is Flexfield What is flexfield qualifier and what is segment qualifier
Ans:- A flexfield is made up a segments (Which are actually table columns). Each segment has a name that can be assigned, and set of valid value.
Purpose and Application:-
Flexibility to implement code structure.
Flexibility to capture additional information.
Two Types of Flexfields in oracle apps.
1. Key Flexfields (KFF)
2. Descriptive Flexfields (DFF)
A key flexfield segment has a name you assign, and set of valid values you specify. Each value has a meaning which can be specified.
Flexfield Qualifier:-A flexfield qualifier identifies a particular segment of a key flexfield..
Usually an application needs some method of identifying a particular
segment for some application purpose such as security or computations. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to
use for segment identification.
Segment Qualifier :- A segment qualifier identifies a particular type of value in a single
segment of a key flexfield.
In the Oracle Applications, only the. Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ”identification tag” for a value. In the Accounting Flexfield, segment qualifiers can identify the account type
A. a) Import
b) Validation
c) PostQuickCash
153). What is the order in which Autolock box searches for the types of the matching number
A. 1. Transaction Number
2. Sales Order Number
3. Purchase Order Number
4. Consolidated Billing Invoice Number
5. Other, user-defined number.
154. What is application short name for General Ledger you specify in FND FLEXSQL user exit
A. SQLGL
155) . What are validations to be done in Journal Import interface.
A. Batch level: Set of Books, Period Name, and Batch Name
Journal Level: Set of books, Period name, Source name, Journal entry name, Currency code, Category name, Actual flag, Encumbrance type ID, User conversion type, Accounting date, Budget version ID
156) What subclass in forms6i 48
A Specifies module, storage & name information about the source object and source module for a referenced objects.
157) What is the clause in SQL Loader to program to override data into table
A. REPLACE
158). How do you set profile in oracle applications In Application Developer responsibility
A Open „Profile? Function
159). What is the syntax for loading data through SQL Loader from multiple files simultaneously
A. Sqlldr scott/tiger@orcl control = ctlfile
parfile -- parameter file: name of file that contains parameter specifications
parallel -- do parallel load (Default FALSE)
160) What is the table name for items in Oracle Inventory
A MTL_SYSTEM_ITEMS, MTL_CATEGORIES
161). Tell me names of important production tables & their purpose AP, AR, GL, PO
A AP: AP_INVOICES_ALL, AP_INVOICE_LINES_ALL
To store invoices
AR: RA_SHIPMENT_HEADERS/ _LINES, RA_CUSTOMERS, RA_CONTACTS
PO: PO_VENDORS, PO_VENDOR_SITES - For storing vendor data.
162). Name the interface tables used for the LockBox Interface
A Interface table : AR_PAYMENTS_INTERFACE_ALL
Lockbox transfers the receipts that pass validation to the Receivables interim tables AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL
When you run Post QuickCash, the receipt data is transferred from the QuickCash tables to the following Receipt tables:
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_APPLICATIONS_ALL
AR_CASH_RECEIPT_HISTORY_ALL
163) Name the interface tables used for the Auto Invoice Interface.
A Auto Invoice transfers transaction data from the interface tables
RA_INTERFACE_LINES_ALL,
RA_INTERFACE_SALESCREDITS_ALL, and
RA_INTERFACE_DISTRIBUTIONS_ALL
into the following Receivables tables:
• RA_BATCHES_ALL
• RA_CUSTOMER_TRX _ALL
• RA_CUSTOMER_TRX_LINES _ALL
• RA_CUST_TRX_LINE_GL_DIST_ALL
• RA_CUST_TRX_LINE_SALESREPS_ALL
• AR_PAYMENT_SCHEDULES_ALL
• AR_RECEIVABLE_APPLICATIONS_ALL 49
• AR_ADJUSTMENTS_ALL
164). 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.
a. None (Non Validate at all) (Validation is Minimal)
b. Independent (Input must exist on previous defined list of values)
c. Dependent (Input is checked against a subset of values based on prior Value)
d. Table (Input is checked against a subset of values in an application table)
e. Special (advanced) (Value set uses a flexfield itself)
f. Pair (advanced) (Two Flexfields together specify a range of valid values)
g. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)
h. 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.)
165) 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.
166) What is parameter in apps and from where u can create it.
Ans:- Parameters only using in report, you can create in defining the report in
apps (you can create the parameter there only).
167)What all are the tables used in the modules u have worked on.
In GL – I have worked on GL_JE_HEADERS(JOURNALS HEADER),GL_JE_LINES(JOURNAL LINES), GL_JE_BACHES(JOURNAL BATCHES), GL_SET_OF_BOOK(SET_OF_BOOK_ID),
In PO- I have worked on PO_HEADER_ALL…..
168)What is Profile Explain different levels of Profile.
Ans:- A user profile is a set of changeable options that affects the way your
applications run. Oracle Application Object Library establishes a value
for each option in a user?s profile when the user logs on or changes 50
responsibility. Your user can change the value of profile options at any
time a) To create Profile Option. ( Profile Option can created by developer in application developer area) b)set the value (Values of the profile option , who will have what value at various levels is set by SYSADMIN). Oracle Application Object Library provides many options that. (Edit profile feature for every user is available to set any value to allow the user).your users can set to alter the user interface of your applications to satisfy their individual preferences.
Profile Option – set at run time like – User Related, responsibility, Sequence, Printer, Security.
Values in 4 Levels(HIEARCHY WISE) :-
A. USER
B. RESPONSIBILITY
C. APPLICATION
D. SITE
Application Developer create the profile.
System Administrator make profile option.
(NOTE:- If any change in value, it will active when you re-login or switch
to the responsibility.)
( Usage in the multi-tier, the profile is biggest impact)
169)How to restrict the data for a responsibility as per the ORG-ID
Ans:-Through Multi – Org(MO) u can restrict the data for a responsibility as per the ORG-ID. Only in GL- Set of book Id you set the value to restrict the data for a responsibility.
170) What is Flexfield What is flexfield qualifier and what is segment qualifier
Ans:- A flexfield is made up a segments (Which are actually table columns). Each segment has a name that can be assigned, and set of valid value.
Purpose and Application:-
Flexibility to implement code structure.
Flexibility to capture additional information.
Two Types of Flexfields in oracle apps.
1. Key Flexfields (KFF)
2. Descriptive Flexfields (DFF)
A key flexfield segment has a name you assign, and set of valid values you specify. Each value has a meaning which can be specified.
Flexfield Qualifier:-A flexfield qualifier identifies a particular segment of a key flexfield..
Usually an application needs some method of identifying a particular
segment for some application purpose such as security or computations. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to
use for segment identification.
Segment Qualifier :- A segment qualifier identifies a particular type of value in a single
segment of a key flexfield.
In the Oracle Applications, only the. Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ”identification tag” for a value. In the Accounting Flexfield, segment qualifiers can identify the account type
No comments:
Post a Comment