tag:blogger.com,1999:blog-5969715620587526519Mon, 09 Nov 2009 15:55:28 +0000http://www.aboutoracleapps.com/noreply@blogger.com (MG)Blogger143125tag:blogger.com,1999:blog-5969715620587526519.post-2138439153211723360Thu, 29 Jan 2009 09:00:00 +00002009-01-29T14:35:10.318+05:30Fast FormulaIn this article you will learn how to define a QuickPaint Report in Oracle HRMS. The article also speaks about how to edit QuickPaint Formula.Defining a QuickPaint Report1. Define a QuickPaint report that displays contact information for an employee.For example, your report could display the following database items: PER_EMP_NUMBER PER_FULL_NAME PER_KNOWN_AS PER_WORK_PHONE PER_ADR_PHONE_1 http://feedproxy.google.com/~r/aboutOracleApps/~3/XSCbGgqDYRo/how-to-generate-develop-or-edit.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/InqdzdnzKpgiuVGfgNjwOmKyUaw/0/da"><img src="http://feedads.g.doubleclick.net/~a/InqdzdnzKpgiuVGfgNjwOmKyUaw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/InqdzdnzKpgiuVGfgNjwOmKyUaw/1/da"><img src="http://feedads.g.doubleclick.net/~a/InqdzdnzKpgiuVGfgNjwOmKyUaw/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/XSCbGgqDYRo" height="1" width="1"/>http://www.aboutoracleapps.com/2009/01/how-to-generate-develop-or-edit.htmltag:blogger.com,1999:blog-5969715620587526519.post-4359539182636843922Thu, 29 Jan 2009 08:50:00 +00002009-01-29T14:23:50.125+05:30Fast FormulaIn this practice you will learn how to write a fast formula that validates the user table. For this you need to first write a validation formula and then select the formula in the Columns window and test it by entering values outside the valid range in the Table Values window.Writing Formulas to Validate User TablesWrite a validation formula that returns an error and a message if a user enters a http://feedproxy.google.com/~r/aboutOracleApps/~3/dprCWg6F2h8/fast-formula-to-validate-user-tables-in.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/E8_ic2RM7G1w35J6yEXYNXK5uJQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/E8_ic2RM7G1w35J6yEXYNXK5uJQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/E8_ic2RM7G1w35J6yEXYNXK5uJQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/E8_ic2RM7G1w35J6yEXYNXK5uJQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/dprCWg6F2h8" height="1" width="1"/>http://www.aboutoracleapps.com/2009/01/fast-formula-to-validate-user-tables-in.htmltag:blogger.com,1999:blog-5969715620587526519.post-1837156525824860101Fri, 02 Jan 2009 11:58:00 +00002009-01-02T17:34:59.818+05:30Oracle Apps (IQ)Interview QuestionsAOL and SyadminBelow is the list of question asked in Oracle Apps Technical Interviews.1. Explain Directory Structure of APPS?2. How to activate, deactivate and run Concurrent Managers?3. What is the location for concurrent request or manager logfiles and output files?4. Specify the standard naming conventions for the logfile and output file?5. How to write LOG information from PL/SQL block to log file?6. What http://feedproxy.google.com/~r/aboutOracleApps/~3/GSMEGQ-6OhM/oracle-apps-technical-interview.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/oqi6aEQK0kkwaDml_mdq4Kz23zo/0/da"><img src="http://feedads.g.doubleclick.net/~a/oqi6aEQK0kkwaDml_mdq4Kz23zo/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/oqi6aEQK0kkwaDml_mdq4Kz23zo/1/da"><img src="http://feedads.g.doubleclick.net/~a/oqi6aEQK0kkwaDml_mdq4Kz23zo/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/GSMEGQ-6OhM" height="1" width="1"/>http://www.aboutoracleapps.com/2009/01/oracle-apps-technical-interview.htmltag:blogger.com,1999:blog-5969715620587526519.post-457275582323191849Fri, 02 Jan 2009 11:39:00 +00002009-01-02T17:20:02.255+05:30Oracle Apps (IQ)Interview QuestionsBelow is the step by step process of registering shell script as a host program or concurrent program in Oracle Applications.1. Create a shell script ( say xyz) and move it to the appropriate BIN directory in Oracle Application.2. The parameters in the shell scripts should start with $5 , $6 Onwards.3. Rename the shell script to *.prog ( xyz.prog).4. Change Permissions to 755 for the *.prog filehttp://feedproxy.google.com/~r/aboutOracleApps/~3/jlV_e5P3Qbc/how-to-register-shell-script-as.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/cBeKCgXbOG1KJ3IsY_ItAl3JcOI/0/da"><img src="http://feedads.g.doubleclick.net/~a/cBeKCgXbOG1KJ3IsY_ItAl3JcOI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/cBeKCgXbOG1KJ3IsY_ItAl3JcOI/1/da"><img src="http://feedads.g.doubleclick.net/~a/cBeKCgXbOG1KJ3IsY_ItAl3JcOI/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/jlV_e5P3Qbc" height="1" width="1"/>http://www.aboutoracleapps.com/2009/01/how-to-register-shell-script-as.htmltag:blogger.com,1999:blog-5969715620587526519.post-2163946874134255102Mon, 29 Dec 2008 06:03:00 +00002008-12-29T11:39:22.745+05:30Oracle HRMSFast FormulaYou should now be familiar with Oracle Fast Formulas. In the following tutorial you will learn how to define user tables and access table values in Fast Formulas.AssignmentCreate a user table called xx Union Dues (where xx is your group identifier), using the following information.Enter 30 and 32 as Value against column dues.Row1-Union A 30Row2-Union B 32Then write a formula called XX_UNION_DUES http://feedproxy.google.com/~r/aboutOracleApps/~3/SzBIt_vVuic/oracle-fast-formula-tutorial-defining.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/evokb-kbSM1Qe1uEkNzBYqs_Wt8/0/da"><img src="http://feedads.g.doubleclick.net/~a/evokb-kbSM1Qe1uEkNzBYqs_Wt8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/evokb-kbSM1Qe1uEkNzBYqs_Wt8/1/da"><img src="http://feedads.g.doubleclick.net/~a/evokb-kbSM1Qe1uEkNzBYqs_Wt8/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/SzBIt_vVuic" height="1" width="1"/>http://www.aboutoracleapps.com/2008/12/oracle-fast-formula-tutorial-defining.htmltag:blogger.com,1999:blog-5969715620587526519.post-5811046633012563886Mon, 29 Dec 2008 05:28:00 +00002008-12-29T11:13:20.773+05:30Site HubOracle NewsOracle has added ‘Site Hub’ to its multi-domain MDM product family. It provides a holistic data hub for all site-specific data throughout the entire lifecycle of a site. Site hub can offer a complete site management solution by leveraging a number of assets from the existing hubs and out-of-the box integration with other Oracle applications such as Enterprise Asset, Inventory & Property http://feedproxy.google.com/~r/aboutOracleApps/~3/n13jr5ovaTg/eseminar-on-oracle-site-hub-competitive.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/W6vIih4LNeHbiSRJL6v-9SkMDrc/0/da"><img src="http://feedads.g.doubleclick.net/~a/W6vIih4LNeHbiSRJL6v-9SkMDrc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/W6vIih4LNeHbiSRJL6v-9SkMDrc/1/da"><img src="http://feedads.g.doubleclick.net/~a/W6vIih4LNeHbiSRJL6v-9SkMDrc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/n13jr5ovaTg" height="1" width="1"/>http://www.aboutoracleapps.com/2008/12/eseminar-on-oracle-site-hub-competitive.htmltag:blogger.com,1999:blog-5969715620587526519.post-6345586353656039073Fri, 26 Dec 2008 12:50:00 +00002008-12-26T18:34:50.197+05:30Oracle HRMSFast FormulaAssignment Edit your Travel Payment formula to ensure that the result is always rounded to two decimal places.Using the Round Function Edit your Travel Payment formula to ensure that the result is always rounded to two decimal places. It can be done by using functions in Fast Formulas.Using the Round Function1. Navigate to the Formula window using your local Super HRMS Manager responsibility. http://feedproxy.google.com/~r/aboutOracleApps/~3/IpOUJXGVgOQ/how-to-add-functions-to-fast-formulas.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/Qw13ZQWjKGhrRA-1CaFHzKZ7sag/0/da"><img src="http://feedads.g.doubleclick.net/~a/Qw13ZQWjKGhrRA-1CaFHzKZ7sag/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Qw13ZQWjKGhrRA-1CaFHzKZ7sag/1/da"><img src="http://feedads.g.doubleclick.net/~a/Qw13ZQWjKGhrRA-1CaFHzKZ7sag/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/IpOUJXGVgOQ" height="1" width="1"/>http://www.aboutoracleapps.com/2008/12/how-to-add-functions-to-fast-formulas.htmltag:blogger.com,1999:blog-5969715620587526519.post-6715443743977810503Fri, 19 Dec 2008 05:59:00 +00002008-12-19T11:39:01.344+05:30Oracle HRMSFast FormulaAssignmentWrite a simple Fast formula to update your Travel Payment formula to use the override travel rate, if it has been entered, and otherwise to use the global value. Make sure you have read following articles on Fast Formulas.1. Oracle HRMS Fast Formula – Tutorial2. How to Define or Setup Global Value in HRMS3. How to write simple Fast Formulas in Oracle HRMSWriting Conditional LogicLet us http://feedproxy.google.com/~r/aboutOracleApps/~3/yUY_HHlgWiA/writing-conditional-logic-in-fast.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/nm6KPJIVl1d4odXQEu7lJQPRLP0/0/da"><img src="http://feedads.g.doubleclick.net/~a/nm6KPJIVl1d4odXQEu7lJQPRLP0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/nm6KPJIVl1d4odXQEu7lJQPRLP0/1/da"><img src="http://feedads.g.doubleclick.net/~a/nm6KPJIVl1d4odXQEu7lJQPRLP0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/yUY_HHlgWiA" height="1" width="1"/>http://www.aboutoracleapps.com/2008/12/writing-conditional-logic-in-fast.htmltag:blogger.com,1999:blog-5969715620587526519.post-6677485599735860411Fri, 19 Dec 2008 05:13:00 +00002008-12-19T10:57:53.699+05:30Oracle HRMSFast FormulaAssignment Write a formula to calculate the travel payment Pay Value by multiplying Distance by the company travel rate, which is stored as a global value. How to define Global value has been already covered before.Writing Simple Formulas Assume that a company has defined an element called ‘Travel Payment’ with an input value called ‘Distance’. Write a formula to calculate the travel payment Pay http://feedproxy.google.com/~r/aboutOracleApps/~3/zDHec7wAJBA/how-to-write-simple-fast-formulas-in.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/-E5Mt17Ghc20nGiSXeWG-oFp4E4/0/da"><img src="http://feedads.g.doubleclick.net/~a/-E5Mt17Ghc20nGiSXeWG-oFp4E4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/-E5Mt17Ghc20nGiSXeWG-oFp4E4/1/da"><img src="http://feedads.g.doubleclick.net/~a/-E5Mt17Ghc20nGiSXeWG-oFp4E4/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/zDHec7wAJBA" height="1" width="1"/>http://www.aboutoracleapps.com/2008/12/how-to-write-simple-fast-formulas-in.htmltag:blogger.com,1999:blog-5969715620587526519.post-7691086466635904832Tue, 16 Dec 2008 12:36:00 +00002008-12-19T10:59:23.848+05:30Oracle HRMSFast FormulaTo set-up the different rates for employee reimbursement options you define global value. Here in this example I will define a global value called XX_TRAVEL_RATE, where xx is your group identifier. Enter a value for the amount of money paid per mile or kilometer for reimbursement of business travel expenses. The screenshot is itself self explanatory.Follow the simple steps for defining a Global http://feedproxy.google.com/~r/aboutOracleApps/~3/KJYtXUezVm0/how-to-define-or-setup-global-value-in.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/OrAq28hVouipvBSFvsfyWhRIm-g/0/da"><img src="http://feedads.g.doubleclick.net/~a/OrAq28hVouipvBSFvsfyWhRIm-g/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/OrAq28hVouipvBSFvsfyWhRIm-g/1/da"><img src="http://feedads.g.doubleclick.net/~a/OrAq28hVouipvBSFvsfyWhRIm-g/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/KJYtXUezVm0" height="1" width="1"/>http://www.aboutoracleapps.com/2008/12/how-to-define-or-setup-global-value-in.htmltag:blogger.com,1999:blog-5969715620587526519.post-8095198910846887300Mon, 10 Nov 2008 09:01:00 +00002008-11-10T15:09:00.643+05:30Oracle HRMSFast FormulaOracle FastFormula is a simple way to write formulas using English words & basic mathematical functions. You can use information from your database in formulas without learning the database structure or a programming language.Common tablesSELECT *FROM all_objectsWHERE object_type = 'TABLE' AND object_name LIKE 'FF%'http://feedproxy.google.com/~r/aboutOracleApps/~3/jdt69XkyWfo/oracle-hrms-fast-formula-tutorial.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/4wN5O5w5kuJXamX7I-I7moNjuHU/0/da"><img src="http://feedads.g.doubleclick.net/~a/4wN5O5w5kuJXamX7I-I7moNjuHU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/4wN5O5w5kuJXamX7I-I7moNjuHU/1/da"><img src="http://feedads.g.doubleclick.net/~a/4wN5O5w5kuJXamX7I-I7moNjuHU/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/jdt69XkyWfo" height="1" width="1"/>http://www.aboutoracleapps.com/2008/11/oracle-hrms-fast-formula-tutorial.htmltag:blogger.com,1999:blog-5969715620587526519.post-7363068362514732764Mon, 10 Nov 2008 07:39:00 +00002008-11-10T13:15:46.282+05:30Oracle Apps (IQ)Interview QuestionsBelow is the list of Questions that are frequently asked in an Oracle Applications Interview for entry level consultants. Go through them to brush up your skills.1) How will you register Sql*Loader in apps.2) Where the Control file is placed.3) What is format of your flat file before uploading the records via SQL * loader.4) What is syntax while Running Sql*Loader.5) How to register custom table http://feedproxy.google.com/~r/aboutOracleApps/~3/HxOzwDBLpAM/interview-questions-for-oracle-apps.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/VZU61WXkfg5CofvmIC-dhKxw8y0/0/da"><img src="http://feedads.g.doubleclick.net/~a/VZU61WXkfg5CofvmIC-dhKxw8y0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/VZU61WXkfg5CofvmIC-dhKxw8y0/1/da"><img src="http://feedads.g.doubleclick.net/~a/VZU61WXkfg5CofvmIC-dhKxw8y0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/HxOzwDBLpAM" height="1" width="1"/>http://www.aboutoracleapps.com/2008/11/interview-questions-for-oracle-apps.htmltag:blogger.com,1999:blog-5969715620587526519.post-845434824467492652Thu, 23 Oct 2008 10:18:00 +00002008-10-23T16:07:37.608+05:30Oracle Apps (IQ)Interview QuestionsBelow is a list of 50 common questions pertaining to Oracle Applications that are asked in any interview questions for the position of Technical Oracle Apps Consultant. As of now I am only providing you with the list of questions. Please send me along with the answers in a .doc format to admin@aboutoracleapps.com. I will randomly select 5 people using random.org with most correct answers. The 5 http://feedproxy.google.com/~r/aboutOracleApps/~3/WYfem6CEFbg/participate-in-oracle-application.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/1xUdVL3Z4dzRW7gdXBhd-qF52G8/0/da"><img src="http://feedads.g.doubleclick.net/~a/1xUdVL3Z4dzRW7gdXBhd-qF52G8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/1xUdVL3Z4dzRW7gdXBhd-qF52G8/1/da"><img src="http://feedads.g.doubleclick.net/~a/1xUdVL3Z4dzRW7gdXBhd-qF52G8/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/WYfem6CEFbg" height="1" width="1"/>http://www.aboutoracleapps.com/2008/10/participate-in-oracle-application.htmltag:blogger.com,1999:blog-5969715620587526519.post-3189605603844837124Mon, 29 Sep 2008 10:34:00 +00002008-09-29T16:06:51.578+05:30PL/SQL<!-- google_ad_section_start -->While uploading the data into Oracle system make sure that you upload the valid email address. Below is a small function that will validate the email address while uploading. The function returns 'VALID' valid address and 'INVALID' for Invalid email id'sCREATE OR REPLACE FUNCTION xxx_validate_email(l_email_id IN VARCHAR2) RETURN VARCHAR2 IS l_str_length http://feedproxy.google.com/~r/aboutOracleApps/~3/r1bjxrIs3R8/function-to-validate-email-address-in.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/3US_OosoknbTRNLhuz0x8hUyKqc/0/da"><img src="http://feedads.g.doubleclick.net/~a/3US_OosoknbTRNLhuz0x8hUyKqc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/3US_OosoknbTRNLhuz0x8hUyKqc/1/da"><img src="http://feedads.g.doubleclick.net/~a/3US_OosoknbTRNLhuz0x8hUyKqc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/r1bjxrIs3R8" height="1" width="1"/>http://www.aboutoracleapps.com/2008/09/function-to-validate-email-address-in.htmltag:blogger.com,1999:blog-5969715620587526519.post-219096668050441199Wed, 03 Sep 2008 11:03:00 +00002008-09-03T16:38:45.910+05:30PL/SQL (IQ)Below is the list of Questions related to PL/SQL. The complexity level of these questions is Easy.1.I am having Cursor which returns 10 records.I want to display the 5th record.2.I am having User defined Exception but I want to display error message based on default Oracle error number using User defined Exception.3.Write a query that have atleast 5 employees has to there in a Department.4.http://feedproxy.google.com/~r/aboutOracleApps/~3/qf3i8KVKnh4/interview-questions-on-oracle-plsql.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/WKkOtLY_WibPlov9bi6VeUCHBe8/0/da"><img src="http://feedads.g.doubleclick.net/~a/WKkOtLY_WibPlov9bi6VeUCHBe8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/WKkOtLY_WibPlov9bi6VeUCHBe8/1/da"><img src="http://feedads.g.doubleclick.net/~a/WKkOtLY_WibPlov9bi6VeUCHBe8/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/qf3i8KVKnh4" height="1" width="1"/>http://www.aboutoracleapps.com/2008/09/interview-questions-on-oracle-plsql.htmltag:blogger.com,1999:blog-5969715620587526519.post-7663730966691353158Thu, 28 Aug 2008 11:58:00 +00002008-08-29T19:47:39.677+05:30Are you being interested in writing a guest post for aboutoracleapps.com? Learn more about this blog here.The purpose of this blog has always been to develop a community of passionate Oracle Apps professionals. Now that the blog has achieved critical mass and generated a regular audience, I would like to build a small group of occasional posters with an international perspective to share their http://feedproxy.google.com/~r/aboutOracleApps/~3/geGTMtKTEZE/publish-your-artciles-on.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/Qi3oCAm0sXw22m3xIzwGsOVLVs0/0/da"><img src="http://feedads.g.doubleclick.net/~a/Qi3oCAm0sXw22m3xIzwGsOVLVs0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Qi3oCAm0sXw22m3xIzwGsOVLVs0/1/da"><img src="http://feedads.g.doubleclick.net/~a/Qi3oCAm0sXw22m3xIzwGsOVLVs0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/geGTMtKTEZE" height="1" width="1"/>http://www.aboutoracleapps.com/2008/08/publish-your-artciles-on.htmltag:blogger.com,1999:blog-5969715620587526519.post-8834762287123504378Thu, 28 Aug 2008 11:05:00 +00002008-08-28T16:45:27.591+05:30XML PublisherBelow is a slide on XML publisher which gives you a complete understanding of why and when XML publisher is used. It also provides you with a step by step procedure to develop a report output using XML publisher and how to integrate it with Oracle Applications.XML Publisher (www.aboutoracleapps.com)View SlideShare presentation or Upload your own. (tags: xmlxml publisher)If you have any questions http://feedproxy.google.com/~r/aboutOracleApps/~3/WM-A5ZD6t30/oracle-xml-publisher-how-to-develop.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/mw-0C4tI6V8KykQmyqAUJqU7iJU/0/da"><img src="http://feedads.g.doubleclick.net/~a/mw-0C4tI6V8KykQmyqAUJqU7iJU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/mw-0C4tI6V8KykQmyqAUJqU7iJU/1/da"><img src="http://feedads.g.doubleclick.net/~a/mw-0C4tI6V8KykQmyqAUJqU7iJU/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/WM-A5ZD6t30" height="1" width="1"/>http://www.aboutoracleapps.com/2008/08/oracle-xml-publisher-how-to-develop.htmltag:blogger.com,1999:blog-5969715620587526519.post-2080696018010844643Tue, 26 Aug 2008 12:01:00 +00002008-08-26T17:40:58.328+05:30PL/SQL (IQ)Interview QuestionsBelow is the list of Questions related to PL/SQL. The complexity level of these questions are intermediate.1.What are the valid values for system variable MODE?2.:OLD and :NEW variables cannot be applicable in which triggers?3.When we go for Procedures and when we go for Functions4.In sql*plus,Some update statement is given without commit i am exit the form whether the records would be updated orhttp://feedproxy.google.com/~r/aboutOracleApps/~3/f7SORAHH6CE/faq-oracle-plsql.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/2NosE9U6SoOMWEJNeZp6MWSF6TQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/2NosE9U6SoOMWEJNeZp6MWSF6TQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/2NosE9U6SoOMWEJNeZp6MWSF6TQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/2NosE9U6SoOMWEJNeZp6MWSF6TQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/f7SORAHH6CE" height="1" width="1"/>http://www.aboutoracleapps.com/2008/08/faq-oracle-plsql.htmltag:blogger.com,1999:blog-5969715620587526519.post-15927932971843966Mon, 18 Aug 2008 10:08:00 +00002008-08-18T15:44:01.770+05:30AOL and SyadminA flexfield is a field made up of sub-fields, or segments. A flexfield appears on your form as a pop-up window that contains a prompt for each segment. Each segment has a name and a set of valid values. There are two types of flexfields: key flexfields and descriptive flexfields. BASIC FLEXFIELD CONCEPTSSegment - A segment is a single sub-field within a flexfield. You define the appearance http://feedproxy.google.com/~r/aboutOracleApps/~3/FmGGBoDm5V4/flexfields-in-oracle-apps-basic.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/qrxDx8qW6OKNsCRa8aQiVQRN1sU/0/da"><img src="http://feedads.g.doubleclick.net/~a/qrxDx8qW6OKNsCRa8aQiVQRN1sU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/qrxDx8qW6OKNsCRa8aQiVQRN1sU/1/da"><img src="http://feedads.g.doubleclick.net/~a/qrxDx8qW6OKNsCRa8aQiVQRN1sU/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/FmGGBoDm5V4" height="1" width="1"/>http://www.aboutoracleapps.com/2008/08/flexfields-in-oracle-apps-basic.htmltag:blogger.com,1999:blog-5969715620587526519.post-5082759639346521272Mon, 11 Aug 2008 11:51:00 +00002008-08-12T08:24:26.523+05:30Interview QuestionsAOLAOL and SyadminFind below the Interview questions related to oracle apps technical interview. The Questions are primarily on Sysadmin and AOL (Application Object Library) Responsibilities. The questions are in MCQ style. The answers are written at the end of each question.1. Which of the following is not associated with a responsibility?A. MenuB. Request groupC. Data groupD. Password expiration Ans:D2. What do http://feedproxy.google.com/~r/aboutOracleApps/~3/lqqr4MBcskY/interview-questions-oracle-apps.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/tQvHIVRVIGUjg7ssdKJ7NZh6D_g/0/da"><img src="http://feedads.g.doubleclick.net/~a/tQvHIVRVIGUjg7ssdKJ7NZh6D_g/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/tQvHIVRVIGUjg7ssdKJ7NZh6D_g/1/da"><img src="http://feedads.g.doubleclick.net/~a/tQvHIVRVIGUjg7ssdKJ7NZh6D_g/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/lqqr4MBcskY" height="1" width="1"/>http://www.aboutoracleapps.com/2008/08/interview-questions-oracle-apps.htmltag:blogger.com,1999:blog-5969715620587526519.post-715642514560275748Thu, 31 Jul 2008 09:47:00 +00002008-07-31T15:30:05.634+05:30Oracle FinancialsInterview QuestionsBelow is a list of 25 Important questions that is asked in almost every financials technical interview question. I have also included some of the functional questions that are asked.Answers are included.Qns: What is Flex field? What are different types of Flex field?Ans: Flex field is used to capture information of your Organisations.Qns: Difference between KFF and DFF.KFFUnique identifierStoredhttp://feedproxy.google.com/~r/aboutOracleApps/~3/s_GS0SJqFr0/oracle-financials-interview-question.htmlnoreply@blogger.com (MG)2<p><a href="http://feedads.g.doubleclick.net/~a/0zZhBxONEiMuTidE8YZD_2LT1r4/0/da"><img src="http://feedads.g.doubleclick.net/~a/0zZhBxONEiMuTidE8YZD_2LT1r4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/0zZhBxONEiMuTidE8YZD_2LT1r4/1/da"><img src="http://feedads.g.doubleclick.net/~a/0zZhBxONEiMuTidE8YZD_2LT1r4/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/s_GS0SJqFr0" height="1" width="1"/>http://www.aboutoracleapps.com/2008/07/oracle-financials-interview-question.htmltag:blogger.com,1999:blog-5969715620587526519.post-3826814762514468664Thu, 31 Jul 2008 06:17:00 +00002008-07-31T12:15:58.217+05:30Interview QuestionsBelow is the list of some important interview Questions asked to technical consultants.These questions are for entry level technical consultants but experienced professionals can go through them to brush-up their knowledge base.Qns1 : What are the important tables in AP (not interface tables): 1. AP_INVOICES_ALL2. AP_CHECKS_ALL3. AP_INVOICE_DISRIBUTIONS_ALL4. AP_BATCES_ALL5. http://feedproxy.google.com/~r/aboutOracleApps/~3/VHHhunB1T8Y/oracle-application-technical-interview.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/L7FeMaW4I7Ck3z3j622rBc8gGqk/0/da"><img src="http://feedads.g.doubleclick.net/~a/L7FeMaW4I7Ck3z3j622rBc8gGqk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/L7FeMaW4I7Ck3z3j622rBc8gGqk/1/da"><img src="http://feedads.g.doubleclick.net/~a/L7FeMaW4I7Ck3z3j622rBc8gGqk/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/VHHhunB1T8Y" height="1" width="1"/>http://www.aboutoracleapps.com/2008/07/oracle-application-technical-interview.htmltag:blogger.com,1999:blog-5969715620587526519.post-1457305917840275321Fri, 25 Jul 2008 06:16:00 +00002008-07-25T12:07:26.713+05:30Oracle HRMSScriptBelow is the script to upload the Employee Address Details data into HRMS base tables using API - hr_person_address_api.create_person_address. You may look into the standard API's and add the additional parameters to upload the additional details. I have used only the basic details of an employee. If you want to upload the multiple records you may write the cursor to fetch the employee address http://feedproxy.google.com/~r/aboutOracleApps/~3/IVKQy2e-8wM/how-to-upload-employee-address-details.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/KwB9CqlRwKUVIalqNsrD3D7M4Mc/0/da"><img src="http://feedads.g.doubleclick.net/~a/KwB9CqlRwKUVIalqNsrD3D7M4Mc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/KwB9CqlRwKUVIalqNsrD3D7M4Mc/1/da"><img src="http://feedads.g.doubleclick.net/~a/KwB9CqlRwKUVIalqNsrD3D7M4Mc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/IVKQy2e-8wM" height="1" width="1"/>http://www.aboutoracleapps.com/2008/07/how-to-upload-employee-address-details.htmltag:blogger.com,1999:blog-5969715620587526519.post-7910638372841208552Tue, 22 Jul 2008 10:35:00 +00002008-12-10T06:45:36.220+05:30Oracle HRMSWhen you need to identify the person_type_id of a person, which one do you use - per_all_people_f.person_type_id or per_person_type_usages_f.person_type_id? It is one of the frequently asked question in Oracle Application HRMS Interview. Let me explain you the difference between the two in detail- The answer is you should always use the per_person_type_usages_f.person_type_id. Though on the http://feedproxy.google.com/~r/aboutOracleApps/~3/taoubZBNNqU/difference-between-perallpeoplefpersont.htmlnoreply@blogger.com (MG)1<p><a href="http://feedads.g.doubleclick.net/~a/S_0SAN54yFEZHjf4yihHTXo4jlY/0/da"><img src="http://feedads.g.doubleclick.net/~a/S_0SAN54yFEZHjf4yihHTXo4jlY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/S_0SAN54yFEZHjf4yihHTXo4jlY/1/da"><img src="http://feedads.g.doubleclick.net/~a/S_0SAN54yFEZHjf4yihHTXo4jlY/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/taoubZBNNqU" height="1" width="1"/>http://www.aboutoracleapps.com/2008/07/difference-between-perallpeoplefpersont.htmltag:blogger.com,1999:blog-5969715620587526519.post-528092187677645915Tue, 22 Jul 2008 09:55:00 +00002008-07-22T15:36:00.723+05:30Oracle HRMSThe Soft Coded Legislation Flexfield holds legislation specific information only. The Soft Coded Legislation Flexfield structure that a user will see is determined by the legislation of the Business Group. Localization teams determine the data that is held in this flexfield. Each localization team defines a flexfield structure and uses qualifiers to define the level at which each segment is http://feedproxy.google.com/~r/aboutOracleApps/~3/dCcCp3ro2Ek/what-is-soft-coded-key-flexfield-in.htmlnoreply@blogger.com (MG)0<p><a href="http://feedads.g.doubleclick.net/~a/tIP7_3TTaVwOzwrj6ixzZcEpgoc/0/da"><img src="http://feedads.g.doubleclick.net/~a/tIP7_3TTaVwOzwrj6ixzZcEpgoc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/tIP7_3TTaVwOzwrj6ixzZcEpgoc/1/da"><img src="http://feedads.g.doubleclick.net/~a/tIP7_3TTaVwOzwrj6ixzZcEpgoc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/aboutOracleApps/~4/dCcCp3ro2Ek" height="1" width="1"/>http://www.aboutoracleapps.com/2008/07/what-is-soft-coded-key-flexfield-in.html