appsstuff.blogspot.com
Oracle Application Stuff: October 2009
http://appsstuff.blogspot.com/2009_10_01_archive.html
Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Thursday, October 22, 2009. 2 Write a PL/SQL program to do the processing. It crea...
retoscripts.blogspot.com
Apps Scripts: March 2010
http://retoscripts.blogspot.com/2010_03_01_archive.html
Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. Based on a request from one of the reader here is the query which he was looking for. He needed query that can list all the responsibilities attached to a user. Select fu.user name, fr.responsibility name, furg.START DATE, furg.END DATE. From fnd user resp groups direct furg, fnd user fu, fnd responsibility tl fr. Where fu.user user name = :user name. And furg.user id = fu.user id. And fr.language = userenv('LANG'). And p...
retoscripts.blogspot.com
Apps Scripts: Simple Script to load the HR Locations using API
http://retoscripts.blogspot.com/2009/10/simple-script-to-load-hr-locations.html
Thursday, October 22, 2009. Simple Script to load the HR Locations using API. L location id NUMBER;. L object version number NUMBER;. Appshr location api.create location. P effective date = SYSDATE,. P location code = 'XX LOCATION',. P description = 'XX Location',. P address line 1 = 'XX Avenue',. P country = 'US',. P postal code = '6442',. P telephone number 1 = '7587612050',. P town or city = 'XX',. P business group id = '0',. P style = 'US GLB',. P location id = l location id,. Anto Joe Natesh I.
retoscripts.blogspot.com
Apps Scripts: Script to display status of all the Concurrent Managers
http://retoscripts.blogspot.com/2009/10/script-to-display-status-of-all.html
Thursday, October 22, 2009. Script to display status of all the Concurrent Managers. SELECT DISTINCT concurrent process id "Concurrent Process ID",. Pid "System Process ID", os process id "Oracle Process ID",. Qconcurrent queue name "Concurrent Manager Name",. Pprocess status code "Status of Concurrent Manager",. TO CHAR(p.process start date,'MM-DD-YYYY HH:MI:SSAM') "Concurrent Manager Started at". FROM fnd concurrent processes p,. Fnd concurrent queues q,. AND spid = os process id. Anto Joe Natesh I.
retoscripts.blogspot.com
Apps Scripts: How to get the create statement of sql view
http://retoscripts.blogspot.com/2009/10/how-to-get-create-statement-of-sql-view.html
Thursday, October 22, 2009. How to get the create statement of sql view. SELECT owner "view owner name", view name "view name". WHERE view name = :view name. SELECT DBMS METADATA.get ddl ('VIEW', 'view name',. Anto Joe Natesh I. Subscribe to: Post Comments (Atom). Oracle Application Inbound Interfaces. Simple Script to load the HR Locations using API. Order by clause for column datatype as character. Query to print the calender for the year. How to get the create statement of sql view. Anto Joe Natesh I.
retoscripts.blogspot.com
Apps Scripts: Query to print the calender for the year
http://retoscripts.blogspot.com/2009/10/query-to-print-calender-for-year.html
Thursday, October 22, 2009. Query to print the calender for the year. SELECT LPAD (MONTH, 20 - (20 - LENGTH (MONTH) / 2) MONTH, "Sun", "Mon",. Tue", "Wed", "Thu", "Fri", "Sat". FROM (SELECT TO CHAR (dt, 'fmMonthfm YYYY') MONTH,. TO CHAR (dt 1, 'iw') week,. MAX (DECODE (TO CHAR (dt, 'd'),. 1', LPAD (TO CHAR (dt, 'fmdd'), 2). MAX (DECODE (TO CHAR (dt, 'd'),. 2', LPAD (TO CHAR (dt, 'fmdd'), 2). MAX (DECODE (TO CHAR (dt, 'd'),. 3', LPAD (TO CHAR (dt, 'fmdd'), 2). MAX (DECODE (TO CHAR (dt, 'd'),. Query to ext...
appsstuff.blogspot.com
Oracle Application Stuff: November 2007
http://appsstuff.blogspot.com/2007_11_01_archive.html
Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Monday, November 26, 2007. Difference Between Lexical and Bind Variable. Oracle Re...
appsstuff.blogspot.com
Oracle Application Stuff: August 2008
http://appsstuff.blogspot.com/2008_08_01_archive.html
Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Friday, August 8, 2008. Metalink ID and Patch:. XML Publisher 4.5 - 3554613. WHERE...
appsstuff.blogspot.com
Oracle Application Stuff: FND Message
http://appsstuff.blogspot.com/2010/05/fnd-message.html
Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Tuesday, May 18, 2010. FND MESSAGE.GET - Retrieves a translated and token̵...
appsstuff.blogspot.com
Oracle Application Stuff: May 2010
http://appsstuff.blogspot.com/2010_05_01_archive.html
Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Tuesday, May 18, 2010. FND MESSAGE.GET - Retrieves a translated and token̵...