Following is List of articles for Oracle Apps Technical Questions
Alternatively, Go through the following Top 10 Oracle Apps Technical Questions
List of Oracle Apps Technical Interview Questions – Part 5
1. What is difference between TRUNCATE & DELETE
2. We have one million records in our log table, which command either Delete/ Truncate should be used and why?
3. What are the advantages of VIEW?
4. What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?
5. how to find out duplicate records ?
6. What are the different types of files used in SQL Loader ?
7. Can you have multiple layout templates for a single data template?
8. What is the executable and concurrent program used to develop a report without RDF?
9. How to do conditional formatting in XML Publisher?
10. What is the difference between Conditional Formatting and format trigger?
11. I want to create a report output in 10 languages, do I have to create 10 layout templates?
12. How do you pass parameters to your report?For RDF based Reports
13. What are the various sections in the data template?Parameter section
14. What triggers are supported in Data template?
15. Where is the trigger code written?
16. What is the file supporting the translation for a layout template?
17. How do you display the company logo on the report output?
18. In order to enable the attachment feature, what minimum information is needed to know.
19. What are steps to enable attachment feature on any apps form?
20. How do you get profile options values from with in an PL/SQL procedure?
* TRUNCATE is a DDL command whereas DELETE is a DML command.
* TRUNCATE is much faster than DELETE.
When you user DELETE statement, all data get copied into the Rollback Tablespace first, then delete operation get performed. Thatswhy when you user ROLLBACK statement after deleting rows from a table ,you can get back the data(System get it for you from the Rollback Tablespace). All this process take times.
But when you use TRUNCATE statement, it removes data directly without copying it into the Rollback Tablespace. Thatswhy TRUNCATE is faster. Once you Truncate you cann’t get back the data.
* You cann’t rollback in TRUNCATE but in DELETE you can rollback.TRUNCATE removes the record permanently.
* In case of TRUNCATE ,DML Trigger doesn’t get fired.But in DML commands like DELETE .Trigger get fired.
* You cann’t use conditions(WHERE clause) in TRUNCATE.But in DELETE you can write conditions using WHERE clause
* That TRUNCATE command resets the High Water Mark for the table but DELETE does not has any impact on higher water mark.
Truncate should be used as it will not generate redo logs and hence data will be wiped out much fastly.
* To protect some of the columns of a table from other users.
* To hide complexity of a query.
* To hide complexity of calculations.
The SQLCODE returns the value of the error number for the last error encountered.
The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error that occurred in the code. These are especially useful for the WHEN OTHERS exception.
select * from emp where rowid not in ( select min(rowid) from emp group by ename);
There are 5 files are user in SQL Loader.
1. Data File.
data file and control file are required file.
SQL> sqlldr userid=apps/apps control=XYZ.ctl
This control file contain the reference of data file. Log file and Bad file automatically created by sql Loader whereas Discard file is optional.
Yes, multiple layouts can be defined, user has a choice here to use one among them at run time during conc request submission
XDODTEXE is used as executable and jAVA concurrent program is used as concurrent program for developing report without RDF.
Conditional formatting in BI Publisher/ XML Publisher can be done in these some of the following way:
1) if statements
2) if then else statements :
3)choose statements : for multiple conditions
There are more ways for conditional formatting in addition to the above mentioned methods like column formatting, row formatting etc.
In Oracle reports, we have two option to control the formatting of data
This is user interface in oracle reports where we can define the conditions and logic to display data as per our requirement. e.g If amount > 100 its colos should be red other wise no color. Etc
Through Format Triggers
For each text item in oracle reports, you can attach a format trigger, it returns a BOOLEAN value. If you return FALSE, value will not be displayed in output. In this way you can control the behavior e.g if amount is zero no need to display the data etc.
Another person replied this question in following words.
Both provide the same functionality, used to format the output based on particular conditions. Format triggers provide a wide variety of options when compared to conditional formatting(GUI). In format Triggers we have the option to write PL/SQL code where as conditional formatting is GUI based which provide limited options.
No, BI Publisher provides the required translation for your templates, based on the number of languages installed in your oracle apps environment requires outputs are provided
Token defined at concurrent program parameter level should be exactly same as parameter defined in RDF report.
Token for each parameter should match with respective parameter in RDF report to pass the data. If they mismatch, there will be no error but data will not be passed.
For XML Based Reports (Where executable is XDODTXE)
Token defined at concurrent program parameter level should be exactly same as parameter defined in data template.
Sql stmt section
Data Structure section
Before report and After report are supported
The code is written in the plsql package which is given under ‘defaultpackage’ tag of data template.
XLIFF is the file that supports the translation, you can modify the same as required.
Copy and paste the logo (.gif. or any format) on the header section of .rtf file . Ensure you resize per the company standards.
Once the block we want to enable attachments for is identified, we have to identify the following information for it.
* Form Name: PERWSMEA
* Function Name: PERWSMEA
* Block Name: MEA
* Base Table Name: PER_MEDICAL_ASSESSMENTS
* Primary Key Columns: MEDICAL_ASSESSMENT_ID
1. Define document entity
2. Define document category
3. Enable Attachment for the form using “Attachment Functions” menu item in attachments Menu
I. Associate document category created in step2 with attachment function created in step 3.
II. Click on Block button and identify block access method (either allow change of Query Only). Click on Entities
a. select the the privileges
b. Assign primary key fields.
By calling the standard FND_PROFILE.VALUE() procedure.
Following are the FND_PROFILE values that can be used in the PL/SQL code:
Oracle HRMS Interview Questions
Question of the Day
9 Steps to become Oracle Apps Consultant
How to create backend logging mechanism
Steps for creating custom form in Oracle Apps
Clear Global Cache in Oracle Apps
Profile Values in Oracle Forms Personalization
2 simple Steps to make a responsibility read only
Step to Register Discoverer Report
Hierarchy of OLM Tables