Difference Between Technical and Functional and Techno Functional
Hello Friends, here i am posting some of basic oracle applications questions , will try to collect more and put in future posts, here i am putting quite easy and basic questions. If you like to know Questions of any specific area or modules, plz communicate so i will post those as well.
What are Oracle Apps API?
Where APIs are physically store? n What is the latest version of API?
They are Application Program Interfaces, which are standard stored procedure, package or functions created for performing specific activities in the Oracle Apps E-Business Suite.
Ex: The Order Import API when called would create orders corresponding to the record in the Order Interface tables.
How to attach reports in Oracle Applications?
The steps are as follows:
1. Design your report.
2. Generate the executable file of the report.
3. Move the executable as well as source file to the appropriate product’s folder.
4. Register the report as concurrent executable.
5. Define the concurrent program for the executable registered.
6. Add the concurrent program to the request group of the responsibility.
How to attach Forms in Oracle Applications
1. Develop the form in Developer 2000.
2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US]
3. Define the FORM in Application Developer
4. Define FORM as FUNCTION.
5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine]
6.Copy the above MENU and go to Application Developer and query on MENU tab
What is the difference between Customization and Personalization?
Customization is done by making the changes in the cutom.pll whereas the Form Personalization is done through the Front End in Oracle Apps.
Difference between Key and Descriptive Flexfield?
key flex fields are used to identify particular entity like(accounts,objects) supoose take debit cards each debit card contain unique number to identify them. eg; 100-023-323 key flex fields are used to store this number along with description.
Key Flexfield are stored in segment
For key flexfield there are flexfield Qualifier and segment Qualifier
DFF’s are used to capture additional informtion required for our organization without any programming.
To capture extra information
Stored in attributes
Context-sensitive flexfield is a feature of DFF. (descriptive flexfield)
What is the difference between data conversion and data migration?
Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA), validating it and converting it to ur our the target module using the standard import program.
What is the difference between Organization_id and Org_id ?
OrgId: Org Id is an unique ID for the Operating Unit.Organisation Id: The Organisation Id is an ID for the Inventory Organisation which is under an Operating Unit.
What are _ALL tables in Oracle Apps?
_all tables will store information about multiple oraganizations. these table contain ORG_ID column that picks particular organizations from multiple organizations. _all tables will be created when we install multiorg.
What is one full life cycle implementation?
Full Life Cycle means implementing a project from the begining to the production and maintenance stage.
(1) System Planning:
(Scope & Budget of the Project)
(2) Business Analysis:
(Business Requirements, Mapping & GAP Analysis)
(3) System Analysis & Design
(Design Conceptual & Functional Data Models)
(4) System Development
(Programming & System/Integration/Validation Testing)
(5) System Implementation
(Data Conversions, Interfaces, Extensions,User Manuals & User Training)
(6) System Maintenance & Support
Thanks – Shivmohan Purohit
Oracle Applications – Interview Questions (All Modules)
Question: What are the key benefits of forms personalization over custom.pll?
Answer: Multiple users can develop forms personalization at any given point in time.
It is fairly easy to enable and disable forms personalization.
–>A programmer is not required to do simple things such as hide/disable fields or buttons.
–>Provides more visibility on customizations to the screen.
Question: Tell me some limitations of forms personalization when compared to CUSTOM.pll?
–>Can’t create record group queries, hence can’t implement LOV Query changes.
–>Can’t make things interactive, i.e. can’t have a message box that gives multiple choices for example Proceed or Stop etc.
Question: How can you import invoices into Oracle Receivables?
Question: In OA Framework, once your application has been extended by substitutions, is it possible to revert back to remove those substitutions?
Answer: yes, by setting profile option “Disable Self-Service Personal%” to Yes, keeping in mind that all your personalizations will get disabled by this profile option. This profile is also very useful when debugging your OA Framework based application in the event of some error. By disabling the personalization via profile, you can isolate the error, i.e. is being caused by your extension/substitution code or by Oracle’s standard functionality.
Question: For a PL/SQL based concurrent program do you have to issue a commit at the end?
Answer: The concurrent program runs within its own new session. In APPS, the default database setting enforces a commit at the end of each session. Hence no explicit COMMIT is required.
Question: What is the difference between running Gather Stats and “Program – Optimizer[RGOPTM]” in Oracle General Ledger?
Answer: “Gather Stats” will simply gather the stats against existing tables, indexes etc. However Gather Stats does not create any new indexes. But “Program – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided accounting segment has the indexed flag enabled,
Question: How do you know if a specific Oracle patch has been applied in apps to your environment?
Answer: Use table ad_bugs, in which column bug_number is the patch number.
SELECT bug_number ,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated
WHERE bug_number = TRIM(‘&bug_number’) ;
Question: How to make concurrent program end with warning?
Answer: If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter. For a Java Concurrent program, use the code similar to below ReqCompletion lRC; //get handle on request completion object for reporting status IRC = pCpContext.getReqCompletion(); lRC.setCompletion(ReqCompletion.WARNING, “WARNING”);
Question: Which table is used to provide drill down from Oracle GL into sub-ledger?
Question: You have just created two concurrent programs namely “XX PO Prog1” & “XX PO Prog2”. Now you wish to create a menu for Concurrent Request submission such that only these two Concurrent Programs are visible from that Run Request menu. Please explain the steps to implement this?
a) Define a request group, lets say with name “XX_PO_PROGS”
b) Add these two concurrent programs to the request group “XX_PO_PROGS”
c) Define a new Form Function that is attached to Form “Run Reports”
d) In the parameter field of Form Function screen, enter REQUEST_GROUP_CODE=”XX_PO_PROGS” REQUEST_GROUP_APPL_SHORT_NAME=”XXPO” TITLE=”XXPO:XX_PO_PROGS” e) Attach this form function to the desired menu.
Question: Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10
Answer:You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.
Question: This is a very tough one, almost impossible to answer, but yet I will ask. Which Form in Oracle Applications has most number of Form Functions?
Answer: “Run Reports”. And why not, the Form Function for this screen has a parameter to which we pass name of the “Request Group”, hence securing the list of Concurrent Programs that are visible in “Run Request” Form. Just so that you know, there are over 600 form functions for “Run Reports”
Question: How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions from one environment to another without Keying? Will you use FNDLOAD?
Answer: FNDLOAD can not be used in the scenario. You can use migrator available in “Oracle iSetup” Responsibility
Question: How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
Answer: This script can be attached to a Concurrent Program via a concurrent program executable. The user will then be given access to this Concurrent Program.
Question: But how will the end user or Oracle Apps make this script run every 10hours daily?
Answer: A concurrent program can be scheduled to run at desired intervals. The schedule is defined at the time of submission.
Question: What are the basic steps when defining a concurrent program?
Answer: Broadly speaking there are three steps when developing a concurrent program in Oracle Apps Step 1. Make Oracle Apps identify the executable Step 2. Provide a handle to the executable by means of defining a concurrent program Step 3. Make this concurrent program accesible to selected users via their responsibility.
thanks - shivmohan purohit
Oracle Account Payables:The New Supplier Open Interface Feature is Now Available in Financials Family Pack F for 11i
Payable has added new open interface tables and concurrent programs to support the automated import of supplier records from external sources. This feature offers the same validations as the Suppliers and Suppliers Sites window. This feature is available as of 11.5.10 or 11i Financials Family Pack F and will not be back ported to any prior release. The Supplier Open Interface Request Set submits:
Supplier Open Interface Import
Supplier Site Open Interface Import
Supplier Site Contacts Open Interface Import
More details about the Supplier Open Interface can be found on page G-5 and G-6 of the latest Oracle Payables User’s Guide. If you like to furthur on this in any way either functinally or technically, plz let me know i will dig into it.
Below is just a Payables functionality in a diagram.