tag:blogger.com,1999:blog-46516370942728796902024-03-21T06:18:33.213-07:00Murthy Ganjams Oracle Apps Technical WorldThe 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.comBlogger77125tag:blogger.com,1999:blog-4651637094272879690.post-51252852790724583752018-10-03T14:12:00.000-07:002018-10-03T14:12:16.645-07:00Connecting Python to Oracle
Recently i started learning python and ran it to issue while connecting python to oracle database.
It took me almost 1.5 hours to establish a connection from a python script to the Database I know.
Biggest challenge for the developer is knowing the
First Step:
The below query will give you the host name and Port no(Type=Local Listener)
select * from v$listener_network;
To get Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com0tag:blogger.com,1999:blog-4651637094272879690.post-31359127840490506962015-06-01T12:42:00.000-07:002015-06-01T12:43:11.908-07:00Oracle Workflow:Providing Approval/Rejection for a notifcation through API's
Hi All,
Recently i got a requirement to Overide a work flow Approval process programmatically
Scenario:Let assume the workflow is pending with supervisor and he is not available to provide approval/rejection a oracle notification.
Possible reasons:
1.users didnt set up vaccation rules
2.Notification is timedout and pending with supervisor manager
One way to handle these Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com19tag:blogger.com,1999:blog-4651637094272879690.post-92092844811171411842013-01-06T04:32:00.000-08:002013-01-06T04:32:20.220-08:00Oracle DBMS_UTILITY error handling
Today we observed on weird issue when using one of the standard API which used work prior started giving error
ORA-06508: PL/SQL: could not find program unit being called
The easiest way to resolve this issue is by adding DBMS_UTILITY format_error_stack and format_call_stack to the when others block
This gave us the exact error of the internal package which was invalid
Begin
Null;
--keep Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com6tag:blogger.com,1999:blog-4651637094272879690.post-86403830051144523512012-11-11T10:37:00.001-08:002012-11-11T10:37:23.960-08:00Oracle SQL:Converting Row to Columns
Rows to columns..This is second time i came across this requirement of converting rows as columns.
I remember this question in one of the exercises in oracle OCP certification program.The solution was to use Decode and max functionality in combination
Posting it here for easy reference and for people new to oracle.
In the below query our requirement was to get the current quarter and Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com7tag:blogger.com,1999:blog-4651637094272879690.post-78083538565842619042012-11-10T20:02:00.000-08:002012-11-10T20:02:43.379-08:00OAF:Set Text Color/Highlight record
Lets discuss on some of the common requirements in custom OAF pages
When ever there is a business validation failure display the content(text) in red color/other or mark the text.
This can be achieved by defining a custom css style.
CSSStyle cellBGColor = new CSSStyle();
cellBGColor.setProperty("color","#FF0000");
#FF0000--red color
OAMessageStyledTextBean field12=(OAMessageStyledTextBean)Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com4tag:blogger.com,1999:blog-4651637094272879690.post-8661266385289388932012-11-10T17:00:00.002-08:002012-11-10T17:00:53.006-08:00Oracle OAF:Date Field -set min and max date
Hi All,
Its long time i have written anything interesting..too much occupied in job and not able find time to write anything...
Now a days i am working some interesting projects.. projects just to enhance user experience in using oracle projects.
Instead of multiple clicks in OOB we are developing a single screen to perform the same transaction...
and one screen to view all the data he need.Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com8tag:blogger.com,1999:blog-4651637094272879690.post-29103483837037835922011-11-15T08:49:00.000-08:002011-11-15T09:25:56.870-08:00Migration Business events and subscriptionsMigrating 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 thinMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com54tag:blogger.com,1999:blog-4651637094272879690.post-87606094238672971012011-11-14T14:04:00.000-08:002012-12-05T08:32:06.033-08:00AME Basics--Intro
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 transactions
AME VS Workflow
There is no comparison between these two.
We can use AME in workflow to find the appprover and foward the document for approval
Can AME send notifications??
AME Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com13tag:blogger.com,1999:blog-4651637094272879690.post-69730493694654845472011-07-31T10:26:00.001-07:002011-07-31T10:29:32.563-07:00Script to list All OAF personalizations in the systemUse 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.com13tag:blogger.com,1999:blog-4651637094272879690.post-80437209069672693702011-07-31T09:54:00.000-07:002011-07-31T10:06:54.421-07:00How to get VO substituion details??/JDR_UTILSwe 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.com3tag:blogger.com,1999:blog-4651637094272879690.post-43769121151797971812011-03-23T02:06:00.000-07:002011-03-23T02:10:22.917-07:00Sql Query for Operating unit,Chart of Accoutns,Segments and valuesetsHi 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_idMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com5tag:blogger.com,1999:blog-4651637094272879690.post-42795088491526208372010-12-27T23:16:00.000-08:002010-12-27T23:19:24.982-08:00Key profiles for OAF personalizationsAll 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.com3tag:blogger.com,1999:blog-4651637094272879690.post-25341027445203923882010-12-09T07:28:00.000-08:002010-12-09T07:32:32.025-08:00Steps to Move OA page personalizations at responsibility/Organization levelHi 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.com4tag:blogger.com,1999:blog-4651637094272879690.post-38448417990395092422010-12-03T22:00:00.000-08:002010-12-03T22:03:55.030-08:00Intro to Interfaces --Part2Continuing 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.Interfaces2Murthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-56166985234773480562010-10-01T21:52:00.000-07:002010-10-01T22:46:12.852-07:00Basics of Business eventsHI 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.com10tag:blogger.com,1999:blog-4651637094272879690.post-21646890549229368722010-09-29T08:19:00.000-07:002010-09-29T08:20:45.987-07:00Concurrent Programs Business EventsIn 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.com5tag:blogger.com,1999:blog-4651637094272879690.post-62889039728530561362010-09-28T19:00:00.000-07:002010-09-28T19:23:42.565-07:00Special Characters in XMLRecently 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 defaultMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com3tag:blogger.com,1999:blog-4651637094272879690.post-86353402659750218062010-05-16T01:37:00.001-07:002010-05-18T10:55:00.606-07:00Oracle Procure to Pay Technical FlowHi 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 monthMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com5tag:blogger.com,1999:blog-4651637094272879690.post-28537114761281790312009-09-12T22:55:00.000-07:002009-09-12T23:12:07.081-07:00Migrating workflow between instancesHi 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.com24tag:blogger.com,1999:blog-4651637094272879690.post-8865228214345518072009-09-12T22:51:00.000-07:002009-09-12T22:54:57.040-07:00Oracle workflow standard activitiesHi 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.com9tag:blogger.com,1999:blog-4651637094272879690.post-90692925042651580782009-09-09T03:00:00.000-07:002009-09-09T03:18:40.299-07:00Multiple oraganizations Access control(MOAC)-R12--Part1Hi 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.com7tag:blogger.com,1999:blog-4651637094272879690.post-42920268845316508372009-08-20T02:48:00.000-07:002009-08-20T02:51:07.753-07:00Dynamic IN clauseHi 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.com3tag:blogger.com,1999:blog-4651637094272879690.post-4254968189015397932009-07-03T02:40:00.000-07:002009-07-03T02:59:49.555-07:00QP_CUSTOM--OE_MSG_PUBHi 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 dynanicMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com8tag:blogger.com,1999:blog-4651637094272879690.post-72799634111153697652009-06-22T23:00:00.000-07:002009-06-22T23:05:08.495-07:00Date parameter in Concurrent programs-FND_DATEHi 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.com3tag:blogger.com,1999:blog-4651637094272879690.post-35380894822173091012009-05-08T02:52:00.000-07:002009-05-08T03:06:52.222-07:00Oracle Apps-Changing LOV Query-Form PesonalizationHow 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 theMurthy Ganjamhttp://www.blogger.com/profile/02275014422366766620noreply@blogger.com9