1) What is ERP? Architecture of apps?
A packaged business software system that lets a company automate and integrate the majority of its business processes; share common data and practices across the enterprise; [and] produce and access information in a real-time environment.
2) Sys Admin Module?
a) Define Custom Users, b) Define Login Users, c) Register oracle DB users,
d) Define Concurrent Programs, e) Register Concurrent Executables, f) Setting Profile Option Values, g) Define Request Types.
3) AOL?
a) Registering tables. b) Registering views c) Registering db sequences
d) Registering profile options e) Registering lookups and lookup codes
f) Registering forms g) Registering Form and Non-Form functions i) registering
Menus and sub-menus. j) Registering DFF and KFF. k) Libraries
4) What is responsibility?
Is collection of menus, request security groups and data groups
System admin -> security -> responsibility -> define
Security -> user -> define
Menus:
—collection of forms is nothing but menus
Application -> menu
Tables
- FND_MENU
- FND_MENU_ENTRYES
Request groups:
—-collection of concurrent programs.
security -> responsibility -> request
Tables
- FND_REQUEST_GROUP
- FND_REQUEST_UNITS
Data groups:
—- is a collection of modules used to integrate one or more modules for cross application data transfer and for data repeating and referencing.
security -> oracle -> data group
Tables
1) FND_DATAGROUPS
2) FND_DATAGROUP_UNITS
5) Tell me some thing about SQL-LOADER.
Sql * loader is a bulk loader utility used for moving data from external files into the oracle database.
Sql * loader supports various load formats, selective loading, and multi-tables loads.
1) Conventional
–The conventional path loader essentially loads the data by using standard ‘insert’ statement.
2) Direct
— The direct path loader (direct = true) by possess of logic involved with that, and loads directly in to the oracle data files.
EX:-
My data.csv file
1001, “scott tiger”,1000,40
1002,”gvreddy”,2345,50
Load data
Infile ‘c:\data\mydata.csv’
Into table emp
Fields terminated by “,” optionally enclosed by ‘”’
(empno, empname,sal,deptno)
>sqlldr scott/tiger@vis
control=loader.ctl log= gvlog.log bad=gvbad.bad discard=gvdis.dsc .
1) CONTROL FILE: insert, append, truncate, replace.
Consist of interface table name data file name and columns
a) Not null columns
b) Along with required columns
Control file will contain the sql*loader script, which is used to load data from the data file into oracle base table ( these are situations where data can be included it with in the control file it self)
2) DATA FILE: Actual data for that column
horizontal way only
1) Flat file (.dat/.txt)
2) csu file (comma separator value)
3) LOG FILE: the log file after a load to be sure that no error occurred (or) at least that no unexpected error occurred this type of information is written in log file.
4) BAD FILE: records that cause errors ( insert operations to file, data base errors while trying to load a record)
5) DISCARD: records not selected for loading
7) How do u dump data from pl/sql block to flat files?
Using utl_file package, we can dump data from pl/sql block to flat file.
PRE-REQUIREMENTS for UTL_FILE is specify the accessible directories for the UTL_FILE function in the initialization file (INIT.ORA) Using the UTL_FILE_DIR parameters.
Ex: UTL_FILE_DIR = <Directory name>
EX:- –remember to update INITSID.ORA,
–utl_file_dir = ‘c:\oradata’
Declare
Fp utl_file.file_type;
Begin
Fp := utl_file.fopen(c:\oradata’,tab1.txt’,’w’);
Utl_file.putf(fp,’%s %s \n ‘text field’, 55);
Utl_file.fclose(fp);
End;
8) What is SET-OF-BOOKS?
Collection of Chat of Accounts and Currency and Calendars is called SOB
9) What is the interface?
Interface Table is a table which is used as medium for transfer of data between two systems.
10 what is invoice?
Send you a request for payment
11 What is INBOUND and OUT BOUND? (Different types of interfaces)
Inbound Interface:
— Destinations of oracle applications
—Inbound interface used to transfer data from external system to oracle
applications
Outbound Interface:
—source of the oracle applications
—is used to transfer data from oracle applications to external system.
Open interface:
— is the interface whose logic is provided by oracle
Custom interface:
— is an interface whose logic is developed by implementation team.
What is Legacy system?
---- Other than oracle products
What is Feeder system?
---- Oracle product it-self
- Tell me what is the procedure to develop an
interface?
- First we will get the Requirement document.
- We will create control file based on that plot file.
- Then the control files which loads the data into staging tables.
- Through pl/sql programs we will mapping and validate the data and then dump into the interface tables.
- Through the standard programs we will push the data from interfacetables to Base tables.
- Tell me what r the Base tables in the AR?
hz_parties (party_id) (store info about org, groups and people)
HZ_PARTIES stores information about parties such as organizations, people, and groups, including the identifying address information for the party.
hz_cust_accounts (cust_account_id)
HZ_CUST_ACCOUNTS stores information about customer relationships. If a party becomes a customer, information about the customer account is stored in this table. You can establish multiplecustomer relationships with a single party, so each party can have multiple customer account records in this table.
hz_cust_acct_sites_all (cust_acct_site_id)
HZ_CUST_ACCT_SITES_ALL stores information about customer sites.One customer account can have multiple sites. The address is maintained in HZ_LOCATIONS.
hz_cust_site_uses_all (site_use_id)
HZ_CUST_SITE_USES_ALL stores information about site uses or business purposes. A single customer site can have multiple site uses, such as bill to or ship to, and each site use is stored as a record in this table.
hz_party_sites (party_site_id)
HZ_PARTY_SITES stores information about the relationship between Parties and Locations. The same party can have multiple party sites.Physical addresses are stored in HZ_LOCATIONS.
hz_locations (location_id)
HZ_LOCATIONS stores information about physical locations.
hz_Person_Profiles (person_profile_id)
HZ_PERSON_PROFILES stores detail information about people.
hz_Organization_Profiles (organization_profile_id)
HZ_ORGANIZATION_PROFILES stores credit rating, financial statistics, socioeconomic and corporate linkage information for business sites. The primary key for this table is ORGANIZATION_PROFILE_ID.
- What r the table’s interface tables in the customer interface tables?
- Ra_customers_interface_all
This table stores customer, address, and business purpose information. You do not have to enter values in this table if you do not want to import customers, addresses, or business purposes.
HZ_LOCATIONS.ADDRESS1,
HZ_LOCATIONS.ADDRESS2,
HZ_LOCATIONS.ADDRESS3,
HZ_LOCATIONS.ADDRESS4
2) Ra_customer_profile_int_all
A customer level profile must exist in A_CUSTOMER_PROFILES_INTERFACE for new customers and each bill–to business purpose.
3) Ra_contact_phones_int_all
This table stores telephone numbers for customers, addresses and contacts as well as contacts for customers and addresses.
4) Ra_customer_banks_int_all
This table stores bank information for a customer or for a specific Bill–To address, you must enter a bank account for this customer,
5) Ra_cust_paymethod_int_all
To import payment methods for customers and bill–to business purposes,
- What r the staging tables in the customer interface?
Ra_customers_stg
Ra_customers_address_stg
Ra_customers_point_stg
Ra_customers_contact points_stg
Ra_customers_relate_stg
Ra_customer_error.
- Tell me some mandatory columns in the customer interface tables?
a) Ra_customers_interface_all
1) Orig_system_customer_ref
2) insert_update_flag
3) customer_number
4) customer_status
5)last_updated_by
6) last_updated_date
7)created_by
8) creation_date.
b) Ra_customer_profile_int_all
1) customer_profile_class_name
c) Ra_contact_phones_int_all
1)orig_system_telephone_ref
2)telephone
3) telephone_type
d) Ra_customer_banks_int_all
1) bank_a/c_name
2)bank_a/c_no
3)bank_a/c_currency_code
e) Ra_cust_paymethod_int_all
1) payment_method_name
- Tell me the Navigation for customer interface?
Receivables à Interface à Customers
- What tables cannot be updated through customer interface?
RA_SITE_USES_ALL
RA_CUSTOMER_RELATIONSHIPS_ALL
RA_CUST_RECEIPT_METHODS
AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_BANK_ACCOUNT_USES_ALL
19) How to send additional customer and address information through customer interface?
Here is where attribute columns are used.
* Additional Customer data can be populated in
RA_CUSTOMERS_INTERFACE_ALL.customer_attribute1 to 15
This will go into RA_CUSTOMERS.attribute1 to 15
* Additional address information can be populated in
RA_CUSTOMERS_INTERFACE_ALL.address_attribute1 to 15
This will go into RA_ADDRESSES_ALL.attribute1 to 15
20) What should be the batch size (number of customer records) general guidelines for optimal performance
About 10,000 records per batch is ideal, it is suggested to keep the batch size small.
21) How do you send records at customer level profile and address/site level profile?
For every customer record in RA_CUSTOMERS_INTERFACE_ALL, insert two records in table RA_CUSTOMER_PROFILES_INT_ALL.
22) Customer Interface process can be used for updating the customer information How does the UPDATE work?
Current functionality of Customer Interface is to update all the data. You cannot run Customer Interface to update only changed data. (Refer Bug: 879121 for the intended functionality)
23) What are some of the important fields that Customer Interface does not load?
SIC_CODE
GSA_INDICATOR
FOB_POINT
SALES_CHANNEL_CODE
FREIGHT_TERM
WAREHOUSE_ID
PRICE LIST
SHIP_PARTIAL
PAYMENT_TERM_ID in RA_SITE_USES.PAYMENT_TERM_ID
24) New TCA/Customer Model, how to load customer as PERSON or ORGANIZATION through Customer Interface?
a) Populate ra_customers_interface_all . person_flag = ‘Y’
Run Customer Interface process will load this record as PERSON
b) Populate ra_customers_interface_all . person_flag = ‘N’ ( or NULL )
Run Customer Interface process will load this record as ORGANIZATION
- What validations u did in the customer interface?
- customer name : the same customer reference can’t have different customer names with in this table
HZ_PARTIES.PARTY_NAME
- customer number : must be null if your r using
automatic customer numbering, must exit if you are not using automatic customer
numbering. This value much be unique with in HZ_PARTIES
- customer status : must be ‘A’ for active or ‘I’ for inactive
HZ_PARTIES_STATUS
- bank account num or bank account currency code :
if the bank a/c already exist do not enter a value
if the bank a/c does not exist you must enter a value
- bank a/c name : it must exist in AP_BANK_ACCOUNTS or if it does not exist values must exist for BANK_A/C_CURRENCY_CODE
BANK_A/C_NUM
BANK_NAME
BANK_BRANCH_NAME
- Sob id constant or not
- Periods are opened or not
- Populate all who columns
- New org-id, and organization is.
- Populate all not null columns
- U can populate null columns also if required.
Note: every interface table has two error msg
- Error code.
- Error msg.
- Tell me some API?
FND_FILE.PUTLINE (FND_FILE.LOG, ‘MESSAGE’)
FND_FILE.PUTLINE (FND_FILE.OUTPUT, ‘MESSAGE’)
FND_FILE.PUT (which number, buff in varchar);
FND_FILE.NEW_LINE (which number, buff in varchar);
FND_REQUEST.SET_MODE àCall this functionbefore calling
fnd_request.submit_request from the database.
FND_PROFILES
FND_APPLICATIONS
FND_GLOBAL
FND-FILE
FND_CONCSUB (can submit conc program in host invironment)
Is the Program exits, delete conc program and its executables.
IF FND_PROGRAM.PROGRAM_EXITS (‘EMP’,APPLICATION_NAME_IN) THEN
FND_PROGRAM.DELETE_PROGRAM (‘EMP’,APPLICATION_NAME_IN)
FND_PROGRAM.DELETE_EXECUTABLE (‘EMP’,APPLICATION_NAME_IN)
END;
How can u call a standard interface program from sql or pl/sql code?
FND_REQUEST.SUBMIT_REQUST (‘PO’,’EXECUTABLE NAME’,,,,PARAMETERS)
To know the status of the request?
FND_CONCURRENT.GET_REQUEST_STATUS
Roll back statements?
FND_CONCURRENT.AF_ROLLBACK;
FND_CONCURRENT.AF_COMMIT
API’s for Customer interface?
HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C
HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C
- What are profile options?
Is the Functional and Technical behavior of Oracle Applications Package.
EX: – I want to assign the user3 responsibility to p4 printer then
System Administrator àProfile àSystem
Types of profile options:
1) Site: which affects all users at an installation site.
2) Application: which affects all users working under responsibility owned
by a particular application.
3) Responsibility: which affects all user working a specific responsibility.
4) User: which affects a unique application user.
Profile options will be stored in these tables
1) FND_PROFILE_OPTIONS
2) FND_PROFILE_OPTIONS_VALUES
MO: OPERATING UNIT: Is one of the profiles which we will set organizations to a particular operating unit
API’S:- FND_PROFILE.PUT (‘USER_ID’, VALUE);
FND_PROFILE.GET (‘USER_ID’);
FND_PROFILE.VALUES (‘USER_ID’) RETURN number;
- Oracle E-Business suite?
Oracle apps + analytical components software.
(Oracle discover)
(Oracle sales analyzer)
(Oracle financial analyzer)
(Oracle marketing analyzer)
29) What is multi org?
“Legal entity has more than one operating unit is called as multi orc”
a) Business group — Human resources information is secured by
Business group
b) Legal entity. — inter-company and fiscal/tax reporting.
c) Operating unit — secures AR,OE, AP,PA and PO Information.
d) Organizations — is a specialize unit of work at particular locations
Multi-org tables?
1) HRG_ORGANIZATION_DEFINATIONS.
2) ARF_BUSINESS_GROUPS.
3) GL_SET_OF_BOOKS
4) HR_LEGAL_ENTITIES_
5) HR_OPERATING_UNITS
6) MTL_SYSTEM_PARAMETERS
30) How do u restrict the data for a responsibility as per the org-id?
—- Through multi-org (MO) you can restrict the data for a responsibility as per ORG-ID only.
31) Difference between ORG-ID and Organization id?
—-a global variable exists in the oracle data base called client info which is 64 bytes long, the first 10 bytes are used to store the operating unit id(or org-id) for the multiple organization support features.
—-multi-org views are partitioned by ORG-ID the org-id value is stored in CLIENT-INFO variable (it comes ap, po, ar and om level)
ORGANIZATION-ID:
—-It’s for inventory, mfg and bom.
32) What is template?
a) The TEMPLATE form is the required starting point for all development of new
Forms.
b) The TEMPLATE form includes platform–independent attachments of several
Libraries.
APPSCORE:-
— It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS.
APPSDAYPK:-
— It contains packages that control the oracle applications CALENDER FEATURES.
FNDSQF:-
— It contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.
CUSTOM:-
—it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)
It contain 2 functions –Zoom function available
– Style function available
1 procedure – Event procedure
33) Who information’s?
1) Created by
2) Creation date
3) Last _updated by
4) last_update_date
5) last_update_value
34) Form development process?
a) Open template form
b) Save as <your form>.fmb
c) Change the form module name as form name.
d) Delete the default blocks, window, and canvas
e) Create a window.
f) Assign the window property class to window
g) Create a canvas (subclass info)
h) Assign canvas property class to the canvas
I) assign the window to the canvas and canvas to the window
j) Create a data block (Must be register in the AOL)
k) Modify the form level properties. (sub class item à Text item)
l) Modify the app_cusom package. In the program unit.
1) If (wnd = <’object name’> then
2) If (wnd =<’object name’> then
Go_block<’object name’>;
Return;
m) Modify the pre-form trigger (form level)
app.window.set.window_position (<’object name’> ,null, <’object name’> )
n) Modify the module level properties ((console window, First navigation
p) Save and compile the form.
Place the .fmx in the server directory.
Q) Register in the AOL
APPLICATION à FORM
APPLICATION à FUNCTION
APPLICATION à MENU (ar_navigate_gui)
35) What are the triggers that can’t be modified during forms customization?
Standard_attachment
Zoom
Folder_action
Key_help
Key_exit
Key_commit
When_window_closed
Close_window
36) How do u identity its name of report?
System administrator à concurrent à program à define
System administrator à concurrent à program àexecutable
37) sql*plus files registration?
- create .sql or plr script file
- Place in .sql or .pls files in the specified module like <prompt>11.50\sql dir.
(While putting in the server dir u specify the module name like “ar.gv_table”)
- Register the executable with AOL(method name à sql*plus)
- Define a conc prog based on the registered executable
- Add/assign concurrent program to request group.
Passing the parameters:
- before that u have to create the value set
Go to applicationà validation àset
(Before creating value sets, you have to register the parameters in the AOL)
- sys adminà concurrent à programàdefine
- Click on parameters, and here enter the parameter name and validation type and all and save it.
- Then go to sys adminà securityà responsibilityà request(listing)
- Then go receivables responsibility à reportsà listing
37) B) sql*loader file registration?
- Create a .CTL file
- Place the .ctl file in <prompt>\11.5.0\bin\
- Place .dat file in any directory of concurrent process server
- Register the sql*loader executable (execution methodà sql*loader)
- Define a concurrent program
- Add/assign the concurrent prog to a request group
39) What are the User PARAMETERS in the Reports?
P_CONC_REQUEST_ID
40) FND USER EXITS:-
FND SRWINIT sets your profile option values, multiple organizations and allows Oracle Application Object Library user exits to detect that they have been called by an Oracle Reports program.
FND SRWEXIT ensures that all the memory allocated for AOL user exits have been freed up properly.
FND FLEXIDVAL are used to display flex field information like prompt, value etc
FND FLEXSQL these user exits allow you to use flex fields in your reports
FND FORMAT_CURRENCY is used to print currency in various formats by using formula column.
USER EXITS
We build user exits when we want to pass control from report builder to a program we have written, which performs some function, and then returns control to report builder.
SRW.USER_EXIT (‘FND RSWINIT’) (Before report trigger)
Fetches concurrent request information and setup profile options.
SRW.USER_EXIT (‘FND SRWEXIT’) (after report trigger)
Frees all the memory allocation done in other oracle applications user exits.
SRW.USER_EXIT (‘FND FLEXSQL’) (Before report)
CODE =”flex field code”
APPL_SHORT_NAME =”application short name”
OUTPUT =”: out put lexical parameter name”
MODE =” {select | where | having| order by}”
DISPLAY = {all | flex filed qualifier | segment no “}
This user exit populates the lexical parameter that we specify with the appropriate column names/sql fragment at runtime.
This enables the report itself to retrieve the concatenated flex field segment values
Out put: – specify the name of the lexical parameter to store the sql fragments.
SRW.USER_EXIT (‘FND FLEXIDVAL
CODE =”FLEX FIELD CODE”
APPL_SHORT_NAME = “Application short name”
DATA =”: source column name”
[NUM = “: structure defining source column [lexical]”
Call this user exit to populate fields for display we pass the key flex field’s data retrieved by the query into this exit from the formula column
SRW.USER_EXIT (‘FND_FORMAT_CURRENCY
CODE =”: column containing currency code’
DISPLAY_WIDTH =” field width for display”
AMOUNT =”: source column name
DISPLAY =”: display column name”
This user exit format the currency amount dynamically depending upon the precision of the actual currency value
41) PL/SQL stored procedure parameters? Or
what are the two parameters that are mandatory for pl/sql type
concurrent program?
Procedure/function (ERRBUF OUT
RETCODE OUT
………………….)
ERRBUF :- Used to write the error message to log or request file.
RETCODE :- Populate log request file with program submission details info.
42) What is Value Set?
–The value set is a collection (or) container of values.
–When ever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.
— If the list of values needed to be dynamic and ever changing and define a table based values set.
The table name to store value set values?
—FND_FLEX_VALUE_SETS
43) What r the validation types?
1) None
—no validation will occur, does not provide lov’s.
— We have to assign the values at runtime.
2) Independent
—input must exist on previously defined list of values
—doesn’t dependent on the value of any other segment
—independent values are stored in oracle AOL.
3) Dependent
—input is checked against a subset of values based on a prior value.
—the segment value is based on another segment value
—the sub-account segment value is dependent on the account segment value
4) Table
—input is checked against values in an application table
—table indicates another oracle table will provide the list of valid values.
5) Special
—values set use a flex field itself.
6) Pair
— Two flex fields together specify a range of valid values.
— These are used SRS parameters
—you don’t use these value sets for normal FF Segments.
7) Translatable independent
— Input must exist on previously defined list of values; translated values
can be used.
—a/c FF don’t support these value sets
8) Translatable dependent
— Input is checked against a subset of values based on a prior values
Translated value can be used.
44) Tell me some report names and their table names in GL, AP, AR, PO?
1) ra_customer_trx_all
customer_trx_id
trx_number (invoice no, debit memo no, credit memo no)
cust_trx_type_id
2) ra_customer_lines_all (details of invoice)
cutomer_trx_id
3) ar_payment_schdules_all
check_id
This table stores all transactions except adjustments and miscellaneous cash receipts.
4) ra_cust_trx_types_all (invoice types)
cust_trx_type_id
5) ra_batches_all
Batch_id
This table stores information about each receipt batch that you create in Oracle Receivables.
6) ra_receivable_application_all
7) ra_adjustments_all
This table stores information about your invoice adjustments.
8) ra_cash_receiots_all
Cash_receipt_id
This table stores one record for each receipt that you enter. Oracle Receivables
ORACLE PAYABLES
- ap_invoice_all
invoice_amount, base_amount, payment_status_flag(‘y’ –fully paid
‘n’—unpaid
‘p’ –partially paid)
- ap_invoice_payments_all
invoice_id,
- ap_invoice_distibutions_All
amount, base_amount, dist_code_combination_id, line_type_lookup_code
- ap_payment_schdules
payment_status_flag(“ ‘’’’’”)
- ap_payment_dustributions_all
- ap_checks_all
check_id,
AP_CHECKS_ALL stores information about payments issued to suppliers or refunds received from suppliers.
- ap_accounting_events_all
- ap_bank_accounts_all
9) ap_bank_accounts_uses_all
AP_BANK_ACCOUNT_USES_ALL stores information for the internal and external bank accounts you define in Oracle Payables and Oracle
Receivables applications.
PO
- po_vendors_all
- po_vendors_sites_all
- po_headers_all
po_header_id
- po_lines_all
po_line_id
- po_line_locations_All
- po_distributions_all
po_distribution_id,
GENERAL LEDGURE
- Gl_code_combinations
GL_CODE_COMBINATIONS stores valid account combinations for each Accounting Flexfield structure within your Oracle General Ledger application.
- Gl_je_batches.
GL_JE_BATCHES stores journal entry batches.
- Gl_je_headers
GL_JE_HEADERS stores journal entries. There is a one–to–many relationship between journal entry batches and journal entries.
- Gl_je_lines.
GL_JE_LINES stores the journal entry lines that you enter in the Enter Journals form.
- Gl_set of books
- Gl_periods
GL_PERIODS stores information about the accounting periods you define using the Accounting Calendar form.
REPORTS:
- OPEN-DEBIT MEMO REPORT?
This report shows all the open-debit memo transactions, based on customer number and dates.
Columns :- type, customer_no, trx_no, amt_due, remaining.
Parameter :- type, customer, from_date, to_date.
- GENERATING POSITIVE PAY FILE FOR BANK REPORT?
Basically this report generates a flat file of all the payments in order to send in to the bank.
- UPDATE POSITIVEPAY CHECKS REPORT?
This report which updates the data into the (AP) account payables system from the plot file, the file which is sent by bank
- UPDATE POSITIVEPAY OUT STANDING CHECKS?
This report which shows the out standing checks
- CUSTOMER PAYMENT DETAILS REPORT?
Which shows each customer original amount, amount pay and due amount based on transaction type (books, pens)
45) FLEX FIELDS?
Oracle applications provide flex fields to allow each organization the ability to define its own reporting structure.
DFF | KFF |
Additional | Unique Info, Mandatory |
Captured in attribute prefixed columns | Segment prefixed |
Not reported on standard reports | Is reported on standard reports |
To provide expansion space on your form With the help of []. [] Represents descriptive Flex field. FLEX FILED : DESCRIPTIVE : REGIGSTER —FND_ID_FLEXS— | Used for entering and displaying key information For example Oracle General uses a key Flex field called Accounting Flex field to uniquely identifies a general account. FLEX FILED : KEY : REGIGSTER —FND_DESCRIPTIVE_FLEXS_VL— |
46) COPY TO:- choose this button to create another concurrent programs using the same executables request and report information’s
47) $FLEX$ :- (Bind variable) $FLEX$.VALUE_SET_NAME
—Is used to get the previous parameter value
— is used to give the profile value at runtime
—basically we will use these two ways in the “where clause” and the default value
of parameter window
48) What is Concurrent?
Simultaneous access o the same data by multiple users
1) Concurrent Manager?
—is a back ground utility which handles all the long running request while align the end user to perform other operations in the application package
View à request
2) Concurrent Request?
—- a request issued to the concurrent processing facility when you submit non-interactive task.
3) Concurrent Process?
—-is a task that runs by the concurrent manager.
4) Concurrent Processing Facility?
—is an oracle applications facility that runs time-consuming, non-interactive tasks in the back ground.
5) Concurrent Queue?
—- A list of concurrent requests waiting for completion.
—- Each concurrent manager has its own queue of pending requests.
6) What is concurrent programming?
— Concurrent processing in oracle apps simultaneously executes programs running in the back ground with online operations to fully utilize your hardware capacity.
— use concurrent programming for long running-data in pensive tasks such as posting a journal or generating report
49) What are the requests groups?
a) Single request: – this allows you to submit an individual request.
b) Request set : – this allows you to submit a pre-defined set of requests.
50) The following number will return the concurrent program?
0 – success
1 – Warning
2 – Error
51) Concurrent managers?
1) Conflict manager
2) Standard manager (default)
3) Internal manager
4) Specialized manager
52) What is conflict manager?
— keeps in the requests.
53) Concurrent manager Utility?
1) Short running task
2) Long running task
54) SRS (standard request submit ion)?
—–it provides you with a set of windows for running reports and programs and a set of windows for creating groups o reports and programs to run together.
Features:
1) Specify whether reports or programs in a request set run sequentially or simultaneously
2) View a log file
3) Specify alternative requests based on completion status of previously run requests in a request set.
55) Difference between concurrent manager and SRS?
Non-interactive task | Interactive task |
This not specifying these much of requests you should complete | Here u can specify as much as you want. |
56) What is In-Compatibility?
Identify a program that should not run simultaneously with your concurrent program because they might interface with its execution.
57) 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,
RESPONSIBULITY_ID NUMBER,
USER_ID NUMBER,
SEQURITY_GROUP_ID NUMBER);
58) How can we call concurrent program from oracle apps?
Using 1) SRS (Standard Request Submission)
2) FND_REQUEST.SUBMIT_REQUEST.
59) Concurrent program parameter types?
- Constant
- Segment
- Profile
- field
60) Pre-defined value sets in oracle financials?
FND_STANDARD_DATE
FND_STANDARD_TIME
61) How parameters passed form to reports?
Using FND_EXECUTE TABLE
62) To capture user name and user-id in pl/sql of oracle apps?
1) FND_GLOBAL.USER_NAME
2) FND_GLOBAL.USER_ID
63) What is MLS Function?
— multingual concurrent request uses to submit a request once to be run multiple times.
64) Oracle JINITIATOR?
—- It is a applet viewer program, it is used to run the java applet on the client system
Applet: is a program that runs client system download on the server.
65) What are the report Formats?
Text Format
Html format
Pdf format
Post script
Binary
66) Difference between the versions of App’s?
— In back-end —-client server architecture (old)/ 3 tire architecture
— In front-end —-client server application (old) / web based applications
67) Where the environment variables are located?
APPL – TOP Directory
68) What are ad-hoc reports?
Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query
69) What are different execution methods of executabls?
FlexRpt The execution file is wrnitten using the FlexReport API.
FlexSql The execution file is written using the FlexSql API.
Host The execution file is a host script.
Oracle Reports The execution file is an Oracle Reports file.
PL/SQL Stored Procedure The execution file is a stored procedure.
SQL*Loader The execution file is a SQL script.
SQL*Plus The execution file is a SQL*Plus script.
SQL*Report The execution file is a SQL*Report script.
Spawned The execution file is a C or Pro*C program.
Immediate The execution file is a program written to run as a subroutine of the concurrent manager. We recommend against defining new immediate concurrent programs, and suggest you use either a PL/SQL Stored Procedure or a Spawned C Program instead.
70) Difference between User and Super User?
User: login user or front end user
Super user: it has full access of particular module
71) USER-AUDITS ACTIVITIES?
— You choose sign-on audit records user name, dates time of users accessing the system, as well as what responsibilities, forms, terminal users are using
Sign on : notification
Sign on : password length
Sign on : audit forms
Sign on : audit reports
Sign on : audit responsibilities
Sign on : audit users
Audit-types
- db row
- db row changes
- db auditing
- end user access
72) Ad-dd package: (application development –data-definition)
1) Procedure register_table
(p_appl_short_name in varchar2,.
P_table_name in varchar2,
P_table_type in varchar2 –T (transaction) or S (seeded)
P_next_extent in number dedault 512,
P_pct_tree in number
P_pct_used in number);
Ex:
Execute AD.DD.REGISTER_TABLE(‘GL’,’GL_JE_LINES’,’T’,15,15,15);
2) Procedure registering_column
(p_appl_short_name in varchar2,.
P_table_name in varchar2,
P_column_name in varchar2,
P_column_sequence in number,
P_column_type in varchar2,
P_column_width in numer,
P_nullable in varchar2,
P_translate in varchar2);
Ex:
Execute AD.DD.REGISTER_column(‘GL’,’GL_JE_LINES’,je_header_id,’1’,NUMBER’,4,Y,’N’);
3) Procedure Delete_table
(p_appl_short_name in varchar2,.
P_table_name in varchar2);
73) NEW APPLICATION DEVELOPMENT.
- register the module in the AOL
AOL à Application à Register
- create the directory structure
- modify the vis.ENV or prod.ENV File (d:\oracle\visappl\prodappl)
- run the vis.CMD or prod.CMD
- register
the module data base user with system administrator
- connect SYS/MANAGER/ORAFIN2
- Create user gvr_ocp identified by OCP(password)
- Grant connect, resource to ocp;
- Conn ocp/ocp@orafin2
- then go to the system admin responsibility
security à oracle à register
- include the module in a data group (Standard)
security à oracle à data group
Then u have to create the Responsibility
- Create the MENU
Application à menu
- Create DATA GROUP
Security àoracleàdata group
- Create REQUEST GROUP
Securityà responsibilityà request
- Finally we have to create responsibility.
Security à responsibility
- AOL à Application àmenu
TEHN REGISTER IN REGEDIT
Local_michine\software\oracle\application\\11.5.0\vis
FINALLY WE HAVE TO RUN THE .CMD FILE
CREATING VALUE-SETS
- Create one new module
- Develop new form with kff
- Register the kff
- Flex field à key àregister
- Flex field à key àsegments
- Flex field à keyà values
73) Oracle app’s instance (or) oracle environments?
1) Test
2) Vision demonstration (end user training)
3) Production (is actual data)
By using ‘Cloning’ we will send the data from test environment to production
VPN virtual private network
ALERTS
- What are
alerts? What are the different types of alerts? Explain?
- Immediately inform you of the database activity as it happens.
- Can periodically trigger off events as and when required
- Can take predefined actions
- Allow you to define distributions list
- Can keep history of the exceptions and actions taken against them.
There are 2 types of alerts
- event alerts
- Periodic alerts.
- What are the event alerts?
—Triggered off when a particular event occur in the database event can be insert or
Update.
- what are alert action level?
—- There are two levels of actions that can be performed detail action and summary action.
- What is summary threshold?
—-oracle alerts automatically determine whether to perform a detail action or summary action based on the number of exceptions in the database.
- What are
the different actions that can be performed in alerts?
- Message actions
- Concurrent program actions
- Operating script actions
- Sql statement script actions
- What are
the steps involved in creating periodic alerts?
- Write a select statement
- Verity and run the sql
- Specify alert inputs
- Define alert outputs
- Create periodic alert actions
- Create a periodic alert actions set
- Check your periodic alert
- What is the distribution list in alerts?
— A pre-defined set of electronic mail ids and printer instructions that you can use on message actions instead of re-entering all the recipient names each time.
- What are the advance features available in alerts?
- Distribution list
- Periodic sets
- Summay thresholds
- Action set checks
- What are the four implicit inputs in alerts?
- Mailid
- Rowid
- Orgid
- Date_last_checked
What are the application implementation methods?
1. study the existing system
2. analyses the system
3. solution phase
4. build phase
5. development and transaction phase
6. production phase (UAT-user acceptance test)
SQL * INTERNATIONAL
- How can u show in reports the descriptive flex field values?
(Or) flex fields in reports? How do u show them in reports?
Using user exits
- parameterized reports?
Reports which contains user parameters by using value sets we give parameters to reports.
- Tokens in the reports?
Is used to specify the user parameter name
- How do u print the report in the character mode?
Change the module level property of mode à character
- Why do u give application name while registering an executable?
By using the application name only it will locate the path.
- How system does know the path?
By using the application name
- how do u give list of values to a parameter through value set?
Value set is of type is LIST OF VALUES.
- Update statement …..will it raise NO_DATA_FOUND?
No.
- How do u know which installation you r working on (dev,product,test,patch)? Table –which table?
FND_APPLICATION_VL
- Where are all my tables information stored?
USER_OBJECTS
- 6 modules which feature MRC(Multiple Reporting Currency)?
GL,AR,AP,CM,FA,PA (Procurement Application)
15) How do I check if Multi-org is installed?
SELECT multi_org_flag FROM fnd_product_groups;
16) How do I find out what the currently installed release of Applications is?
SELECT release_name FROM fnd_product_groups
17) How do I find the name of a form?
GUI: Use Help->About Oracle Applications
Scroll down to find the form name
Character: Use \Help->Version
18) How do I run reports from the commandline?
ar25run userid=apps/apps@database destype=file
desname=try.out
desformat=$FND_TOP/srw/L
batch=yes report=<path to report>
19)Clean out the Concurrent Manager tables?
DELETE from fnd_concurrent_processes;
20) How do I find the errors when a package will not compile?
From SQL*Plus, ‘show errors’ will usually give you the last error messages.
SELECT name, text FROM user_errors will give you the errors.
21) How do I backup a table?
CREATE TABLE backup_table AS SELECT *FROM table to_backup;
22) What is the use of Temp tables in Interface programs?
Temporary tables are used in Interface programs to hold the intermediate data. The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.
24) Why is _all tables used in apps?
It is used to represent multi_org,
26) What is the utility used when migrating from 11 to 11i?
–To upgrade forms,the form can be directly compiled in next release(forms 6i)
— form can be compiled by using IFCMP60.EXE.
— FLINT60 batch executable can be used to check whether the form is compatible to
apps or not
27) How do you capture errors in reports?
Using Exceptions we find errors
- when
srw.do_sql failure
- srw.message.
28) How do you call one report to another report?
Using SRW RUN REPORT
28) Name some FND tables?
1) fnd_applications 2)fnd_views 3) fnd_used 4)fnd_tables 5)fnd_sessions
6) fnd_menus 7)fnd_dual 8) fnd_columns.
29) How can we issue DDL statements through forms?
DDL (Data Definition Language) commands like CREATE, DROP and ALTER are
not directly supported from Forms because Forms are not suppose to manipulate
the database structure.
A statement like CREATE TABLE My_table (Ship_id number);
will result in error:
Encountered the symbol “CREATE” which is a
reserved word.
However, you can use the FORMS_DDL built-in to execute DDL
statements. Eg:
FORMS_DDL (‘CREATE TABLE my_table (ship_id NUMBER)’);
30) How does Oracle Reports
integrate with Oracle Discoverer?
Oracle Discoverer is seamlessly
integrated with Oracle Reports. Oracle Reports is one of the export options to
which a workbook may be exported in Discoverer. Simply create/open your
workbook in Discoverer, select File, Export To, and choose RDF. This creates an
RDF file (Report Definition File) which may be modified in the Report Builder, if
necessary, and then be published across the Enterprise using the Reports
Server.
1) Max length of the table name?
30 char actors
2) Max columns use in a table?
254 columns
3) Global variable data type?
Char
In unix GREF Command you used?
Yes, I m using for searching
5) FLASH BACK QUERIES?
Suppose user accidentally deleted some important rows of a table and now he wants to recover the deleted rows, to achieve this using o FLASH BACK QUERY and they query the database by time or user specified system change no :(scn)
Flash back queries do not work through DDL statements that modify columns or drop or truncate tables.
Ex: create table t (a number (10), b number(10));
Begin
For I in 1..100 loop
Insert into t values (1,i);
End loop;
End;
Commit;
- select count(*) form t; –100 rows
- delete from t; –100 rows deleted
Execute DBMS_FLASHBACK.ENABLE_At_TIME(SYSDATE – 5/1440)
5à Displays 5 Minits before deleting rows.
1) Autonomous transactions?
2) how do u link the HZ_LOCATIONS to HZ_PARTIES?
Hz_party_sites.loaction_id
3) How a parameter is passed from a form to report while calling?
Fnd concurrent <short name> <conc prog name>
4) What is the table name to store value set values?
Fnd_flex_value_Sets
5) Bulk bind?
6) pragma?
7) Break order?