tag:blogger.com,1999:blog-46516370942728796902009-11-06T03:14:51.363-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.comBlogger59125tag: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.com0tag: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.com1tag: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.com1tag: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.com2tag: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.com0tag: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.com1tag: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.com0tag: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.com1tag: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.com2tag: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.com1