tag:blogger.com,1999:blog-46516370942728796902012-02-16T03:04:24.164-08:00The main idea is to help the technical community and one point store of most of the technical solutions..if you have good content that can be posted..put a mail to murthyganjam@gmail.comMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.comBlogger711100tag:blogger.com,1999:blog-4651637094272879690.post-29103483837037835922011-11-15T08:49:00.000-08:002011-11-15T09:25:56.870-08:00

Migrating business events and subscriptionsHow do migrate business events and subscription..one of them is using java command wfx load or using packagesBusiness Events$AFJVAPRG oracle.apps.fnd.wf.WFXLoad -d apps apps_pwd machine_name:port_no:SID thin US Custom_File_Name.wfx EVENTS Business_Event_Name Subscriptions:$AFJVAPRG oracle.apps.fnd.wf.WFXLoad -d apps apps_pwd machine_name:port_no:SID thin

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-87606094238672971012011-11-14T14:04:00.000-08:002011-11-14T14:07:26.934-08:00

Whats AME and why?Approval management engine...It gives the flexibility of defining business rules from Fron end thus reducing the customizations required in PLSQL to find the right approvers for the transactionsAME VS WorkflowThere is no comparison between these two.We can use AME in workflow to find the appprover and foward the document for approvalCan AME send notifications??AME doesn't have

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-69730493694654845472011-07-31T10:26:00.001-07:002011-07-31T10:29:32.563-07:00

Use the below script to list all personalizations in the sytem.We then can use the functional administrator to disable the personalizations in case it is required.This would be very useful script at the functional administrator doesnt' provide % search capabilitiesI got this from metalink and putting it here for quick referenceSELECT PATH.PATH_DOCID PERZ_DOC_ID,jdr_mds_internal.getdocumentname(

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-80437209069672693702011-07-31T09:54:00.000-07:002011-07-31T10:06:54.421-07:00

we can use jdr_utils to get OAF personalization details.Normally page level personalization's are done at different levels and we need to explicitly migrate the personalization file.For VO Substitutions we normally do a jpx import.Even the VO susbtiution are also personalization's at site level.If we migrate the personalization's of VO object, substitution can also be taken care.Give the the VO

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-43769121151797971812011-03-23T02:06:00.000-07:002011-03-23T02:10:22.917-07:00

Hi All,Now a days i am spending a lot of time for getting data from some generic sql queriesGoing forward i want post the generic sql which we require in our development activities.I will tag all of them under useful Application queriesR12:select hou.name,application_column_name,segment_name,flex_value_set_idfrom apps.hr_operating_units hou,apps.gl_ledgers gled,FND_ID_FLEX_SEGMENTSwhere ledger_id

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-42795088491526208372010-12-27T23:16:00.000-08:002010-12-27T23:19:24.982-08:00

All the times i forget these profiles always google out for them..just putting it here for quick reference Profile Name:Personalize Self-Service Defn– Yes enables personalization link on all pages..This should be no in Production environment.for development team also it is better to set it yes at the user levelTHis will enable the personalize page on the left side top corner.This allows us to do

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-25341027445203923882010-12-09T07:28:00.000-08:002010-12-09T07:32:32.025-08:00

Hi All,Coming to OA page personalization always becareful while defining personalization's .Dont define personalizations at responsibility level\organization level unless and until it is absolutely required.Because deploying personalizations between instances would be tedious work for the ones defined at organization and responsibility level1.List all the personalization at the responsibility

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-38448417990395092422010-12-03T22:00:00.000-08:002010-12-03T22:03:55.030-08:00

Continuing with my earlier post long way back...Let see what are inbound interfacesinbound interfaces:Inbound interfaces where data comes into our systems.so when ever we are moving from Legacy system to oracle applicationswe need to move the data residing in that system(master and transactional data) from legacy to new oracle apps systemInbound are broadly classified in to two types1.Interfaces2

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-56166985234773480562010-10-01T21:52:00.000-07:002010-10-01T22:46:12.852-07:00

HI All,some basics syntax and statements to work with business events..Business Events:Business event is an activity in the system which is of some significance .Like creating a purchase order, booking a sales order or ship confirming one.Subscription:A subscription is action that needs to be performed on occurrence of the business eventWhat are the standard parameters for the procedure to be

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-21646890549229368722010-09-29T08:19:00.000-07:002010-09-29T08:20:45.987-07:00

In R12 for concurrent programs submission and completion has business events associated with themin the concurrent program definition form there is a business events tab which displays the list of events associatedHere you specify the points at which business events are enabled. The possible points are:Request Submitted Request On Hold Request Resumed Request Running Program Completed Post

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-62889039728530561362010-09-28T19:00:00.000-07:002010-09-28T19:23:42.565-07:00

Recently we are faced a issue with some spanish,french(special charecters) in the data .we are developing the reports using xmlpublisher and the xml data is generated using plsql.Because of the special characters the concurrent program is ending in warning state with no output generated. even the xml output is errroing out.To overcome this scenario we need to add encoding tag to the xmlBy default

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-86353402659750218062010-05-16T01:37:00.001-07:002010-05-18T10:55:00.606-07:00

Hi All,it is taking long time for to write on my blog due to some personal constraints and work load.. :)going forward i will try to publish atleast 2 to 3 post per month

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-28537114761281790312009-09-12T22:55:00.000-07:002009-09-12T23:12:07.081-07:00

Hi All,There are two way of migrating workflow definitions between instances.1.open the workflow in the workflow builder and using save as in to the target systemsecond way is using wfloadselect * from wf_item_types_tl to the get the workflow short nameWFLOAD apps/apps 0 Y DOWNLOAD REQAPPRV --download eqappv_final.wftftp the reqappv_final.wft to the target instanceWFLOAD apps/apps 0 Y UPGRADE

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-8865228214345518072009-09-12T22:51:00.000-07:002009-09-12T22:54:57.040-07:00

Hi All,here i a putting all standard activities of workflow builder from the developer guide..this is basically for a quick refernce(interview perpective)..just go through all once so that you know what all can be done easily in the workfkow..for details plz check the oracle workflow developer guide ..AND/OR Activities:In cases where multiple parallel branches transition to a single node,you can

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-90692925042651580782009-09-09T03:00:00.000-07:002009-09-09T03:18:40.299-07:00

Hi ALL,Here i am trying to put the MOAC techical architecture in simple terms..we are might have heard the term multi organization till 11.5.10 prior it is only one organizationwhat does multiorganization mean??Managing multiple organizations data in a single system...putting it in lay man termsFor example lets take GEfinancialIt is headquarted in US and operations in india also..assume it

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-42920268845316508372009-08-20T02:48:00.000-07:002009-08-20T02:51:07.753-07:00

Hi ALl,This is one good ways of writing dynamic in clause..if you have a select stament where you are uing in clause to restrict the data.if you are not sure on the inclause statmentwhat you will do..what i used to do is make a dynamica sql build inclause on run time and then execute it ..But there is another smart way of building it dynamically..Example1:cursor c_cust_info is select * from

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-4254968189015397932009-07-03T02:40:00.000-07:002009-07-03T02:59:49.555-07:00

Hi All QP_CUSTOM is a standard package given by oracle to customize the price derivation based on our custom logic.Recently i customisee this package to get freight charge based on the wegith of the line items.This was not so tough to achieve but the user want to show some messages when ever any exception occurs....But the qp_custom is supposed to return a number..This api is called from dynanic

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-72799634111153697652009-06-22T23:00:00.000-07:002009-06-22T23:05:08.495-07:00

Hi All,Normally when ever we want to use date parameter for pl/sql stored procedures we ecounter a common error saying that format string doenst match...then we do a data conversion to_date(p_date,'RRRR/MM/DD HH24:MI:SS') and then use it..The better way of doing it is define the data parameter as varchar2 and use the function FND_DATE.date_to_canonical(p_date).This will direclty convert the text

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-35380894822173091012009-05-08T02:52:00.000-07:002009-05-08T03:06:52.222-07:00

How to change a LOV query from Forms Personalization??This is one of the requrirement that we want to add a additional condition to the LOV query or you want to populate the LOV all together from your SQL.Its a simple four step processStep1:Get the Query that of the LOV of the standard form. You can do it by opening the standard form in the form builder or Get the query by taking the trace of the

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-83596634888618969402009-05-05T22:58:00.001-07:002009-05-05T22:58:50.497-07:00

Hi ALL,One way of finding the session id for concurrent is through fnd_cocurrent_request...as discussed in my earlier postBut there is another easy way...select sid,serial#,MODULE,ACTION,status from V$sessionthe module will contain the concurrent program short name...If only one instance of the concurrent program is running we can easily identify the sessions of it..If we terminate the program

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-90391744499620466062009-05-05T22:41:00.000-07:002009-05-05T22:47:13.987-07:00

Hi All,we all use the log files for debugging issues by writting text into them when ever a exception occurs or to know the process flow of our code...Here are few steps that will make us to have better log and make our life easy during supporting phase..7 ways for writing a Better Log1.Always Display the Name of the package/procedure in the LOG File. The main advantage of doing this is no

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-49784668972306067332009-04-28T00:43:00.000-07:002009-04-28T00:49:11.348-07:00

Recently i want to query on a stadard form for records having reversal date as nulli remember that i need to give is null but it didn't work...some how i manager to do it from backend..Even i searched developer guide with no use...So how i get this from the form guide and i am publishing for easy reference..these things will be very useful..and makes our life easy..1. to enter query by example2.

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-22379345062305032792009-04-27T01:46:00.000-07:002009-04-27T02:00:40.287-07:00

Hi ALL,As we all know there are two mandatory parameters that need to be pased for all the procedures called 1.ERRBUFF 2.RETCODE..They are very useful parameters if used properly..like setting the status of the conucrrent program and putting the log messages...i think it is better we make some rule like we make the program end in Error when ever there is a unidentified exception occurs based on

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-53593896287454646972009-04-26T23:26:00.000-07:002009-04-26T23:31:28.622-07:00

From very long i used to get a common requirement that some system will place the files in a server.the system should get the files and process themfor achieving this we need to have shell script which will connect to the server and ftp the files to the source server..Plz find the sample script for doing this..after writing the script we have to schedule the script in unix using a cronjob...--

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-73240296154256016822009-04-02T22:58:00.000-07:002009-04-02T23:49:41.631-07:00

Hi,This is one of the good documents from metalink..good reference document when you want to do tracing....WHAT TO SET UP BEFORE GENERATING THE TRACEThese steps must be performed by the DBA on the database server.1. Set TIMED_STATISTICS to TRUE.For performance issues, make sure TIMED_STATISTICS is turned on,before attempting to generate the trace.Set the following in the init.ora file:

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-71988213222102516672009-03-01T21:49:00.000-08:002009-03-01T22:00:19.209-08:00

Hi All,this is basic to sink employee information between two instances....CREATE OR REPLACE PROCEDURE APPS.XX_HRMS_INTF_PROC(retcode VARCHAR2, errbuff VARCHAR2)AS l_emp_num VARCHAR2 (30); l_person_id NUMBER; l_assignment_id NUMBER; l_per_object_version_number NUMBER; l_asg_object_version_number NUMBER;

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-51467056796013505332009-02-11T23:01:00.000-08:002009-02-11T23:08:02.664-08:00

Hi All,Recently i got a requirement to create request and attach all the standard reports of GL to these request groups...it seems a lot tedious task to do manually...so i developed this script to copy the request group content to other request groups..THis is very useful if you have to create multiple requestgroups and attach reports to all,....declarecursor z isselect b.CONCURRENT_PROGRAM_NAME

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-12027035723603554882009-01-28T04:06:00.000-08:002009-01-28T04:23:31.237-08:00

Hi All.We all are using concurrent programs ..but might have never put much thought into concurrent manager details....We know that there are concurrent managers running in background which will be processing the concurrent programs submitted.Basically they are three managers1.Internal Manager2.Standard Manager3.Conflict managerFirst let us see few scenarios..1.In a instance when ever we are

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-75509145679114526472009-01-27T23:22:00.000-08:002009-01-28T01:02:37.739-08:00

Hi All,Now a days i am developing a concurrent program...while developing in some scenarios the concurrent program is not completingso i want to terminate,make some corrections and resubmit my program..even i terminate, the lock on my object are not getting releasedso i need to find the locked session and terminate the session...i thought of getting the information of session which i am currently

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-66833780252994351652009-01-22T02:50:00.001-08:002009-01-22T02:52:54.800-08:00

SQL Loader in Oracle Applications…Step1:create a Sqlloader file.(the ctl file)Step2:Create a executable with Execution method type as SQLLOADERStep3:move .ctl file to executable application top bin folder For example for GL it is GL_TOP/binStep4.Create a program for the executable with paramertes like file name..Step6:Attach the concurrent program to a request group and the run the

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-9758564914557638362009-01-22T02:48:00.000-08:002009-01-22T02:50:21.573-08:00

Hi allMost of the time we have requirement of moving files….we normally use the Shell script to move the files…It is not mandatory we need to use shell scripts.There are plsql api’s which can move files from one location to other location..I think every one is aware of UTL_FILE .even it has some limitations…like the directory strucuture used by it should be in the UTL_FILE_PATH in init.ora …or

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-62106032077500048572009-01-20T22:33:00.000-08:002009-01-20T22:36:20.909-08:00

Recently i come accross a requirement to capture the requestidof the concurrent with in the concurrent program session...Even i am aware of the FND_GLOBAL package...But it didnt strike'at first go.....so i am writing this article for people who are not even awarethat this package exists..FND_GLOBAL package gives the most of the enviroment valuesTHis package should be used in database side only...

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com10tag:blogger.com,1999:blog-4651637094272879690.post-16823744327031903412009-01-20T21:43:00.000-08:002009-05-11T04:38:22.247-07:00

I am putting this basics for people like me who are poor in unix…and not confident in doing shell scripting..:)we dont need to develop huge scripts in apps..most of the times it will be moving files between servers or deleting files after completion…Recently I developed a few scripts for moving files after program completion like output to some other folder…$1 connect String$2 Userid$3-$4

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-70220831350228473892008-11-05T21:52:00.000-08:002008-11-05T22:00:11.019-08:00

some times we want to know what are queries that are getting executed when any process is run..one way of finding it is using the V$Sql..the SID and Serial# can be used to kill the session in case of long running queriesset pagesize 24set newpage 1set linesize 125column sql_text format a100column user_name format a12 select b.sid, b.serial# , substr(b.username,1,12) user_name,

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-68281003091706653912008-09-29T03:16:00.000-07:002008-09-29T03:20:42.830-07:00

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-44369073664281866102008-08-28T01:50:00.000-07:002008-08-28T02:04:16.212-07:00

This one of the common requirements of adding adding the new concurrent program to the request group in production environment...The critical comes when we dont have access to the sysadmin responsibility and guide the DBA to do it...Actually there is API's for adding the concurrent program from backend.. it is better to create that script and askt he DBA to run the script which will add the

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-65167085225748231642008-08-12T03:03:00.000-07:002008-08-12T03:27:55.519-07:00

STEP 2 - Examine statements using high resourcee===============================================update ...where ... call------ count ---- cpu --- elapsed --- disk ----query --- current ----rows --Parse-----1--------- 7 -----122 -------- -0----------0----------0-------------0---Execute---1------- 75------ 461-------- 5----- [H] 297 -----[I] 3-------- [J]1---Fetch ---- 0-------- 0------0----------

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-20413940803445459212008-08-12T02:54:00.000-07:002008-08-12T03:03:22.512-07:00

Examples:Step 1 - Look at the totals at the end of the tkprof output===========================================================OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ----------------------------------------------------------------- Parse [A] 7 1.87 4.53 385 [G] 553 22 0 Execute [E] 7 0.03

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-10680762247604184232008-08-12T01:54:00.000-07:002008-08-12T02:53:16.182-07:00

Hi All,Now we will see how to read the trace files..It is very difficult to understand from the trace files so we use the TKPROF utility to make the trace files in a better readable format..This is one of the documents i had which i collected from metalink..a good one with clear examples...If you have a system that is performing badly, a good way to identify problem SQL statements is to trace a

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-13393701908369500342008-08-11T02:27:00.000-07:002008-08-11T02:40:11.599-07:00

Hi All,Quite often we come across tunning the queires...This is the area where most people find it difficult to understand ..The blind rule every one says check the explain plan and try to remove the full table scans...most of times it works to a extent..For really tunning to the best u need to understand what oracle is doing to the data you require or perform the transactions you have issued..

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-26843998666290701812008-08-06T03:43:00.000-07:002008-08-06T21:53:33.948-07:00

Hi All,Here i would like to discuss the basic steps for implementing descriptive flex in our custom forms..These steps you will find in the application develeoper as well as in may sites on the net..i am putting the content from one of the documents i have for ready reference and single source place..If you are creating a DFF on the custom form for already defined DFF jump to step 4..Step1:

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-33137110326442797282008-07-25T00:14:00.000-07:002008-07-25T00:52:32.047-07:00

Hi All,Quite often we get the requirements for restricting access and fuctionalites in form which is normally done either by formspersonalization or custom.pll or standard form modificationIn HRMS quite often i have seen the restrictions like create applicant ,create placment ,create employement functionalities to certain responsibilities...For these forms there is no need to do forms

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-29073561831234826092008-07-01T04:01:00.000-07:002008-07-03T01:28:23.480-07:00

Hi All,Recently we got a requirement for sending mail..on a business logic..we tried to set the mail system on alerts..but still not succesful due to some other reasons..which we are still figuring out..In the mean time we tried to send mail functionality from PLSQL..This is one package we found out in asktom.oracle.com...use this one directly to compile ..and send mail...it works...create or

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-30805918517279877472008-06-28T22:13:00.000-07:002008-06-28T22:33:36.006-07:00

Hi all,I am trying for some information on sqlloader on net..there is tonnes of information available..out of all at one place i found this artice which covers most of the sqlloader queries..."http://www.orafaq.com/wiki/SQL%2ALoader_FAQ"I am putting this here for ready reference...next atricel i will try to cover doing it from oracel applications...What is SQL*Loader and what is it used for?SQL*

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com10tag:blogger.com,1999:blog-4651637094272879690.post-68400060850306782522008-06-09T03:54:00.000-07:002008-06-09T22:38:25.154-07:00

1. Open APPSTAND form in your current form first2. drag and drop QUERY_FIND object from APPSTAND asCOPY onto c01_CHN_REP form.After It copies in three places.1. then Delete QUERY_FIND object group from your C01_CHN_REP form.Query FindThere are two implementations for Query Find. One implementation shows a Row–LOV that shows the available rows and allows you to choose one. The other implementation

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com13tag:blogger.com,1999:blog-4651637094272879690.post-88177290618592967322008-04-28T23:00:00.000-07:002008-04-29T03:59:20.916-07:00

why do i need a attachment functionality?The attachments feature enables users to link unstructured data, such as images, wordprocessing documents, spreadsheets, or text to their application data. For example,users can link images to items or video to operations as operation instructions.Can i enable it to any form i want?For most of the standar you can do that..i hope custom form done in

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com12tag:blogger.com,1999:blog-4651637094272879690.post-76256061103068799182008-04-27T23:08:00.000-07:002008-04-28T16:00:09.702-07:00

Hi all,This is one of the common requirement.They are many ways of doing this like formpersonalization ,Cutom.plland others ..the easiest way to do it is by passing the parameter QUERY_ONLY=YES..But it doesn't gurantee all the forms will behave as expected because the form should be coded to make it work for this..not all standard forms have this..In HRMS Forms case there is another concept

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com5tag:blogger.com,1999:blog-4651637094272879690.post-4755095505858272582008-04-24T23:15:00.000-07:002008-04-24T23:28:39.381-07:00

How do you validate the parameter value of a concurrent program submitted through SRS window?This is one of the recent requirement i come across..after some research i came to know it can be done using special valueset.1.create a valueset of specail validation type2.create a validate Event.you can write the PLSQL COde to validateFND PLSQL "declare l_email VARCHAR2(2000) := :!VALUE;BEGIN IF

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-56448510044013734652008-04-24T17:43:00.000-07:002008-04-25T05:53:16.860-07:00

We got this requirement to change the logo after some little search a good article i found in metalink 468971.1 .1. Attributes of the login pageIt is possible to control the display of some attributes of the login page, for instance user name or password hints, language switchers, forgot password link, corporate policy message, etc.For this, you need to set the profile option 'Local Login Mask'

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-63287085877343248742008-04-24T17:25:00.000-07:002008-04-24T17:28:59.876-07:00

This query will give the values of the profile option set at different level..just use the profile option name or user profile option name which you see in the front end.to querySELECT user_profile_option_name,SUBSTR(e.profile_option_name,1,25) PROFILE,DECODE(a.level_id,10001,'Site',10002,'Application',10003,'Resp',10004,'User') "Level",DECODE(a.level_id,10001,'Site',10002,

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-40642305855537628442008-04-18T21:05:00.000-07:002008-04-18T21:44:53.030-07:00

What is forms Personalization? It is new features where some of the customization can be handled easy by simply setting the rules from the front end.It is available from 11.5.10.2 Why do we need forms Personalization? For example in scenarios like 1.Change the prompts 2.Display some custom message when certain conditions are met 3.Enable and disabling fields/buttons based on

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-81359065736119626022008-04-18T16:42:00.000-07:002008-04-18T17:02:56.127-07:00

i am not a expert in unix and i always maintain a list of simple commands to work in the black screens..here i am posting it for people like for easy reference...How to convert a file from dos mode to unix?? some time shell script developed in the window environment will create some problems because of carriage returns and other thing..those can be removed using the follwoing commanddos2unix

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-62545785595552290282008-04-12T07:16:00.001-07:002010-10-15T04:14:10.705-07:00

Hi All,Here i a trying to get the basics of Interfaces.I will try to post as many interfaces code available.Even though they might not very much helpful ..but gives the direction to look into and some head start...First before i post the interfaces codes i would like to introduce some general concepts of interfaces for freshers..What is a interface?In terms of oracle applications interface is a

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com17tag:blogger.com,1999:blog-4651637094272879690.post-43322869863349901142008-04-07T06:23:00.000-07:002008-04-19T21:06:22.072-07:00

There are different ways to handle Forms Level Customizations.1.Using Custom.PLL2.Using Forms Personalizations3.Copy the Standard form Object and Change the CodeFirst lets see Custom.pll how to use it?What is Custom.PLL??The CUSTOM.pll library is a standard Oracle Forms PL/SQL library that is supplied by Oracle with the OracleApplications. This is Oracle’s built-in feature that allows the

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com7tag:blogger.com,1999:blog-4651637094272879690.post-78757961884872261762008-04-07T01:08:00.000-07:002008-04-07T01:33:23.313-07:00

Hi All,Today is the New Year for US.I wish u all a happy New Year..Today is New Start Even for My blog..i see my blog getting registered in blogs.oracle.com..This give me the encouragement to do better and share more knowledge and help the technical community in a better way..Thank you,Murthy Ganjam.

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-2179390375532732802008-04-01T04:03:00.000-07:002008-04-01T04:18:04.441-07:00

Hi All,Today i come across a problem of selecting layout based on parameter in XML Publisher..After a bit of R&D i come up with this solutionOne way of doing it is1.Create a plsql procedure with all the parameter of the report2.Based on the parameter select the layout either if Else logic or some where defined in the database.3.set the layout using this function define below submit the report

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-69849694902990341112008-03-31T07:46:00.000-07:002008-04-07T03:57:04.098-07:00

HI All,Here i try to analyze different Data loading methods available...and some other debatable issues..Best Practices: 1.Always have the rightly balanced teams.A typical ratio for medium complexity process would be(1:1:2 )(Functional:Technical Designer:Developers).Techical designer should be a guy who understands both the importance of business and technical limitations.And the rule should be ,

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-84326879504627026372008-03-31T03:34:00.000-07:002008-03-31T03:51:08.705-07:00

For generating reports with barcodes1) You should have barcode font in your system i.e. Font name FREE3OF9 (Find as attachment)2) Copy and paste the attached “Free 3of9” font in your machine directories “C:\WINDOWS\Fonts” and $JAVA_HOME\ lib\fontsExample Java path “C:\Program Files\Java\j2re1.4.2_10\lib\fonts”3) There is one configuration file i.e. file name is “xdo” as

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com4tag:blogger.com,1999:blog-4651637094272879690.post-73332864616184695222008-03-28T23:17:00.000-07:002008-03-28T23:25:57.208-07:00

Things to take care in a migration project..These are all my personal observations if any one has anything new to add plz put out a mail i will incorporate them also..Now a days we are coming across many migration projects..comparitviely these are supposed to be easy and straight forward..But if we take care of few more things..it would be even smoother...What is a migration project.??It is

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-27308778405207633932008-03-18T18:44:00.000-07:002008-03-18T19:29:38.670-07:00

Recently we came around a scenario whether the naming convention of the out files need to be changed.After some R&D we find some good document regarding this..Where do concurrent request or manager logfiles and output files go? The concurrent manager first looks for the environment variable $APPLCSF. If this is set, it creates a path using two other environment variables:

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-32597543438719032832008-02-16T18:54:00.000-08:002008-04-07T01:04:18.548-07:00

Hi,Currently i am doing a migration project ..and migrating forms...But for migrating forms there is oracle standard process to do..but unfortunately many people didn't do that way...But this process is the recommended one.Currently i am facing some issues with FLint60 utility...i will post them also here1."ERROR ? Item BLOCKNAME.RADIO_BUTTON81 (Radio Group) requires Hint Text ""ERROR ? Library

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-34246424780158008062008-02-16T18:50:00.000-08:002008-04-07T01:07:54.691-07:00

Steps to create Folder FormStep – 1 Create Folder Objects• Reference Folder ObjectEvery folder form must contain the folder objects (such as the windows that are used for saving folders and changing prompts) included in the STANDARD_FOLDER object group. If this object group does not already exist in your form, reference it from APPSTAND. $AU_TOP/au/11.5.0/forms/US/APPSTAND.fmb• Attached the

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-4831029820134082932008-02-11T02:37:00.000-08:002008-04-07T03:58:50.654-07:00

Folder option is one of the good concepts available to reduce the Future customization in many custom Forms.Here i am putting basic functionality ofthe folders and will try to put the simple steps to do them.These thing are available in the metalink with a little search but i putting for ready reference...for technical peopleFunctions of the FolderFolders provide the following functions to the

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1tag:blogger.com,1999:blog-4651637094272879690.post-6143349250802991272008-01-31T22:39:00.000-08:002008-01-31T22:52:32.368-08:00

Normally where do you find the out and log files..i always learnt that they will be in the corresponding top out and log directories.But i never checked..Last week i got a requirement to find the files and when i check i dont find any out files or log files in the corresponding Top.later after some hard work i find that there is a setting.If that is not specified only then they will be stored in

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-83498693200969737282008-01-25T10:38:00.000-08:002008-01-25T11:26:16.838-08:00

Hi All,Many of you might be knowing this...many like me might not ..Many a time i wondered what all these numbers are all about..so i publish this one for easy referencejust double click the above image to see properly

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-53618839969763443382008-01-23T10:15:00.000-08:002008-04-07T03:59:54.107-07:00

Best Practices:1. keep the source of all Customized objects(Tables,Packages,Procedures ..) in the PLS folder in the custom top.It is easy to say but making people to follow it is very difficult(Even i don't :-) ).One way to make people to follow is by dropping objects whose lastest source is not present in the UNIX box.we need to compare the last update date in the UNIX box and last_modified date

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-70372614644207721382008-01-18T03:59:00.001-08:002008-01-18T04:41:31.129-08:00

we all find different objects withlots of suffixes...her i am putting the meaning of some thosesuffixes..i read this thing in one of the blogs i find itgood...so i am posting it as it will useful to understand thesethings.. _ALL : Table holds allthe information about different operating units. Multi-Orgenvironment. You can also set the client_info to specificoperating unit to see the data

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-52046451537461253772007-12-04T10:09:00.000-08:002008-04-07T04:01:24.963-07:00

HI All,I would like to consolidate a list of best practices and common mistakes done in implmentation projects.I think you people might have come across different best practices and some amazing workarounds.I request all of you to provide me your valuble inputs to put a road map for a ideal implementation.From now onwards I will be sending different best practices and Process so that we can

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com2tag:blogger.com,1999:blog-4651637094272879690.post-41759726900881167282007-11-28T10:29:00.001-08:002008-04-07T04:09:17.217-07:00

create or replace procedure XXBOB_FND_MULTILINE_PRINT_PROC(P_TEXT varchar2,P_FRAME_SIZE NUMBER )asv_text varchar2(1000) ;v_cut number;v_print_text varchar2(1000);v_next_start number;v_tot_length number;v_cut_length number;v_fram_size number :=4;x number;beginv_text:=P_TEXT;If p_frame_size is null thenV_fram_size:=60;end if;v_fram_size:=p_frame_size;v_cut:=instr(v_text,' ',v_fram_size);

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-4933182803091903372007-11-11T21:34:00.000-08:002008-04-07T04:02:21.968-07:00

Hi All,Plz find the different ways of using fnd load.Most of time we required for the movement of different objects majorly likelookups,Menus,Concurrent ProgramsAlerts,valueset...Using FND Load we can load many of the different FND objects from one server to other server.But Unfortunate i never find all the FND load Examples at one place.So i thought i put diffrent examples at one point so that

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com4tag:blogger.com,1999:blog-4651637094272879690.post-75302118947567222432007-11-04T01:59:00.000-07:002008-04-07T04:07:44.784-07:00

Hi all,We can fnd_user_pkg api to create users and attach responsibilities all at one shot..Here i am providing the code which will update or create new users and their repsonsibilitiesThis script need to be improved a bit more to meet your changes/******************************************************************************/create or replace package body XX_FND_USER_PKG asprocedure create_user(

Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com1