oracleapps4u.blogspot.com
Oracle AppsA Blog Specializing in Oracle Applications
http://oracleapps4u.blogspot.com/
A Blog Specializing in Oracle Applications
http://oracleapps4u.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.6 seconds
16x16
PAGES IN
THIS WEBSITE
17
SSL
EXTERNAL LINKS
113
SITE IP
172.217.11.33
LOAD TIME
0.578 sec
SCORE
6.2
Oracle Apps | oracleapps4u.blogspot.com Reviews
https://oracleapps4u.blogspot.com
A Blog Specializing in Oracle Applications
oracleapps4u.blogspot.com
Workflows | Oracle Apps
http://oracleapps4u.blogspot.com/p/workflows.html
Overview of Oracle Workflow. Overview of the Workflow Engine. Applying Workflow Engine APIs to Function Activities. Oracle Workflow Engine APIs. How Oracle Workflow Acquires Information about a Role. Mapping Oracle Workflow to a Directory Repository. Components of a Workflow Process. Define a new Workflow process. How to Monitor Workflow to View its Progress. How to Create a Workflow Diagram. Workflow tables and queries. How to Incorporate Standard Activities in a Workflow Process.
Sample Projects | Oracle Apps
http://oracleapps4u.blogspot.com/p/projects.html
We provide sample projects with all the relevant Codes / Scripts. If you are interested to get the Sample projects, please drop me an email to oracleapps4all@gmail.com. It will include the following:. 1 Code technical design Functional requirement docs. 2 2 Interfaces (Inbound-1 and outbound - 1). 3 2 Reports (RDF with XMLP). 4 2 form customization. NOTE: This is a Paid Service, as lot of effort was involved by our team to develop this content. Subscribe to: Posts (Atom). Enter your email address:.
How to invoke a calendar in a form | Oracle Apps
http://oracleapps4u.blogspot.com/2015/02/how-to-invoke-calendar-in-form.html
How to invoke a calendar in a form. You can enter a value directly to a date field or use the calendar facility in APPS. Calendar lets you the following needs. Represent date and time graphically so that you can make a quick selection without typing. Select only those dates or date ranges that are suitable for the current field. How to invoke a calendar in a form. To invoke a calendar in a custom form you need to do the following. Create a text item with data type DATE in the form.
Oracle Apps Online Trainings Videos | Oracle Apps
http://oracleapps4u.blogspot.com/2011/07/oracle-apps-online-trainings_26.html
Oracle Apps Online Trainings Videos. Haring knowledge is not about giving people something, or getting something from them. We believe that " Knowledge Increases By Sharing. This is the main motto in creating our blog. Visit our online training videos on oracle apps:. On the following topics:. Oracle Applications Core HRMS. Oracle SCM (OM, PO and Other Inventory concepts Needed for OM and PO). OAF – Oracle Application Frame work. ADF – Application Development Frame work. Enter your email address:.
Imp. Links | Oracle Apps
http://oracleapps4u.blogspot.com/p/imp-links.html
DBA Scripts / Q&A:. Http:/ oracle-dba-quickanswers.blogspot.in. Http:/ www.dba-village.com. Https:/ communities.bmc.com/communities/docs/DOC-9942. Raapps.blogspot.in/2009/08/reprocessing-period-close-pending.html. Http:/ www.jonk.co.uk/resources.html. SQL*Plus User's Guide and Reference. Http:/ www.csee.umbc.edu/portal/help/oracle8/server.815/a66736/toc.htm. Receiving Transaction Processor sample code. Http:/ coskan.wordpress.com/. Http:/ alexanderanokhin.wordpress.com/. Http:/ mukx.blogspot.in/. JDevelo...
TOTAL PAGES IN THIS WEBSITE
17
Oracle Flashback Query: Recovering at the Row Level (Recover deleted rows) | Home
http://oracle-appss.blogspot.com/2011/09/oracle-flashback-query-recovering-at.html
Friday, September 16. Oracle Flashback Query: Recovering at the Row Level (Recover deleted rows). In a data recovery context, it is useful to be able to query the state of a table at a previous time. If, for instance, you discover that at 12:30 PM, an employee. Had been deleted from your. Querying the past state of the table is achieved using the. Statement. For example, the following query retrieves the state of the employee record for '. At 9:30AM, April 4, 2003:. SELECT * FROM EMPLOYEE AS OF TIMESTAMP.
oracleappsemployment.blogspot.com
Oracle Apps Jobs: Job Alert
http://oracleappsemployment.blogspot.com/2015/07/job-alert_19.html
Sunday, 19 July 2015. 1349 new job offers match the following search criteria:. Oracle apps - India. If you want to view these offers click on the link below:. Http:/ www.careerjet.co.in/a/W1507192659b94c5e66ba4f61c3ce9a7be26e7a. To modify your alerts, add new ones or delete existing ones:. Http:/ www.careerjet.co.in/ma/e597cdf259ce549c3b0c86e0d5e637d6. To modify your email address click on the following link:. Http:/ www.careerjet.co.in/me/e597cdf259ce549c3b0c86e0d5e637d6. Thank you for using Careerjet.
List of all active workflow users and their roles | Home
http://oracle-appss.blogspot.com/2011/09/list-of-all-active-workflow-users-and.html
Saturday, September 10. List of all active workflow users and their roles. Select wu.name user name,. From wf users wu,. Wf user roles wur,. Where wu.name = wur.user name. And wur.role name = wr.name. And wu.status = 'ACTIVE'. And wr.status = 'ACTIVE'. And wr.orig system = 'WF LOCAL ROLES'. Order by wu.name,. Posted by Jithendra Kumar B. Subscribe to: Post Comments (Atom). Total no of Hits on my blog (As per date -Sep30 ). Usage of :$FLEX$ in oracle apps. Oracle Apps Shortcut Keys. Working with Trace fil...
Get all the views that refer a particular table : | Home
http://oracle-appss.blogspot.com/2011/09/get-all-views-that-refer-particular.html
Saturday, September 10. Get all the views that refer a particular table :. SELECT o.object name, o.status, o.last ddl time. FROM SYS.dba objects o. WHERE o.object type = 'VIEW'. FROM SYS.dba dependencies d. WHERE d.referenced type = 'TABLE'. AND dTYPE = 'VIEW'. AND downer = 'APPS'. AND dNAME = o.object name. AND dreferenced name LIKE ' TABLE NAME ');. Posted by Jithendra Kumar B. Subscribe to: Post Comments (Atom). Total no of Hits on my blog (As per date -Sep30 ). Usage of :$FLEX$ in oracle apps. Workin...
Query to find the user, responsibility and concurrent program details of submitted requests | Home
http://oracle-appss.blogspot.com/2011/08/query-to-find-user-responsibility-and.html
Friday, August 26. Query to find the user, responsibility and concurrent program details of submitted requests. Select B.user concurrent program name,C.user name,D.responsibility name, A.*. From apps.fnd concurrent requests A, apps.fnd concurrent programs tl B, Apps.fnd user C, apps.fnd responsibility tl D. And Buser concurrent program name like. Enter the concurrent program name '. And Bconcurrent program id=A.concurrent program id. And Arequested by=C.user id. Order by request date desc. Find Vacation ...
Check Current Applied Patch & Patch level status of all modules | Home
http://oracle-appss.blogspot.com/2011/09/check-current-applied-patch.html
Saturday, September 10. Check Current Applied Patch and Patch level status of all modules. Check Current Applied Patch. SELECT patch name, patch type,. Maint pack level,. FROM applsys.ad applied patches. ORDER BY creation date DESC. Query used to view the patch level status of all modules. SELECT a.application name,. DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,. FROM apps.fnd application vl a,. Appsfnd product installations b. WHERE a.application id = b.application id;. Script to dis...
XML Template code and template name | Home
http://oracle-appss.blogspot.com/2011/08/xdotemplates.html
Friday, August 26. XML Template code and template name. We can get Lob Code from this query to get the details of RTF files. Query with lob code in the application in case if we don't know the template name. Select * from XDO LOBS. Where file name like '%po terms%'. And XDO File type='RTF'. And trunc(last update date)=trunc(sysdate). Posted by Jithendra Kumar B. Subscribe to: Post Comments (Atom). Making field as mandatory using Forms Personalizat. How to get Login Passwords for application and Data .
sql / plsql | Home
http://oracle-appss.blogspot.com/p/sql-basic.html
This page covers on basic Sql and Plsql queries. Simple sub-queries and with Group functions. General Functions and Types. Conversion Functions in Oracle and Types. Number Functions in Oracle. Date Functions in Oracle. Arthemetic Functions In Oracle. Analytical functions, LISTAGG and XMLAGG. How to submit a concurrent program from pl sql. How to Register a Concurrent Program with a Responsibility. Script to asign Concurrent Program to a Request group. Script to set org context in Oracle apps R12 and 11i.
Get the complete history of concurrent program. | Home
http://oracle-appss.blogspot.com/2011/09/get-complete-history-of-concurrent.html
Saturday, September 10. Get the complete history of concurrent program. SELECT DISTINCT fcpt.user concurrent program name,. Frgrequest group name,. Fcpconcurrent program name,. Uncommment the above to get the list of responsibility's. FaAPPLICATION SHORT NAME,. FROM fnd request group units frgu,. Fnd concurrent programs fcp,. Fnd concurrent programs tl fcpt,. Fnd request groups frg,. Fnd executables fe,. Fnd responsibility fr,. Fnd responsibility tl frt,. Fnd application tl fat,. WHERE 1 = 1. How to Regi...
oracleappsemployment.blogspot.com
Oracle Apps Jobs: Immediate openings for Oracle Apps HRMS -UAE/Qatar/Saudi Arabia/Bahrain/Oman/UK Consultants- Technical , Functional ,Technofunctional for
http://oracleappsemployment.blogspot.com/2012/06/immediate-openings-for-oracle-apps-hrms.html
Thursday, 14 June 2012. Immediate openings for Oracle Apps HRMS -UAE/Qatar/Saudi Arabia/Bahrain/Oman/UK Consultants- Technical , Functional ,Technofunctional for. The sender of this email is registered with Naukri.com as NexWave Talent Management Solutions Pvt Ltd. Experience required for the Job:. 2 - 6 years. Annual Salary of the Job:. 00 - 10.0 Lacs. Send your Naukri profile to express interest to the recruiter). We have job openings for Oracle HRMS Consultant for Evosys. About the company profile:.
TOTAL LINKS TO THIS WEBSITE
113
Oracle Apps DBA & SYSADMIN
Oracle Apps DBA and SYSADMIN. Oracle 11i SQL Scripts. How to Find out Product Installations and Patch Set level in Oracle Applications 11i. How to Monitor Long Running Concurrent Requests in Oracle 11i. How to find out blocking locks and sessions. How to List Reponsibilities for an User in Oracle Applications 11i. How to List Responsibility And Assigned Request Group in Oracle Applications 11i. Hourly Concurrent Managers Performance Report in Oracle Applications 11i. 11i/R12 Setup,Installation,Upgrade.
oracleapps11itechnical.blogspot.com
Oracle Apps Technical 11i
Oracle Apps Technical 11i. Sunday, June 27, 2010. PL/Sql Script to assign responsibilities to Oracle Users. L user id NUMBER;. FROM fnd responsibility vl. WHERE UPPER (responsibility name) = UPPER ('Name');. INTO l user id. WHERE user name = 'Name';. FOR rec cur IN cur rec. Fnd user resp groups api.insert assignment. User id = l user id,. Responsibility id = rec cur.responsibility id,. Responsibility application id = rec cur.application id,. Security group id = 0,. Start date = SYSDATE - 1,. After the ba...
ORACLE APPLICATIONS
Sunday, 27 July 2014. Monday, 13 August 2012. WSH :ATO Retain Reservations. There are several reasons why a shipper can backorder at the time of ship confirmation ,Some of the reasons could be . The material could not be found at the staging area. Customer wants to cancels the orders ,Customer service seeking the shipper to backorder to enable. WSH :ATO Retain Reservations controls whether we can retain the reservations at the time of backordering . Monday, 12 March 2012. Monday, 9 January 2012. If you n...
oracleapps4people.blogspot.com
be happy and make others to be happy
Oracle Apps
Inter-Organization Transfers in Oracle Apps. You can transfer items directly from one organization to another, or you can transfer items through intransit inventory. Intransit inventory represents inventory items that has not yet arrived at the receiving organization. Elemental Cost Visibility Option. Note: This functionality will be supported in a future release that includes the Oracle Order Management product. Average and Standard Costing in Oracle Apps. Standard and Average Costing Compared. Measure ...
Oracle Apps 4u
Oracle Apps SCM – PO & OM. Our Team: Take advantage of our team's vast experience in global delivery. Our Expertise: Our team is a hotbed of Industry expertise and Innovation with a highest quality delivery standards. Our Experience is our confidence: We provide high-quality, end-to-end Oracle E-Business Suite solutions across industries through our unique models and methodologies. First, we deliver through a proved highly efficient global hierarchy model. We deliver measureable results for our clients: ...
oracleapps | learning
July 28, 2009. Colection of Concurrent Programs which will be used to submit the Cnocurrent Programs. Either sequentially or Paraalley multiple programs. It is also like Request group but in Requuest group we can submit only one program at. A time from SRS Window. Where as in Request set we can submit multiple programs at a time. 1)Select the Programs which we would like to group in the set. 2)Open the Request Set form Select the button called Request set wizard and. Enter the concurrent Program list.
Oracle Applications
Thursday, April 5, 2018. Queries to Get the SLA Details. 1) Fields code combination id,Period name,ledger id,status. 2) Fields Batch ID,Reference(type:PO,AR,AP). 3) Fields header id,code combination id,ledger id. Gl sl link id. Gl sl link id. Fields Source distribution type,Accounting line code,event class code,event type code,ae line num. Gl sl link id. Gl sl link id. Posted by Raju Chinthapatla. Queries to Oracle ETAX Details. TRX ID: Transaction ID. This is linked to the. C PO REQ DISTRIBUTIONS ALL: T...
SOCIAL ENGAGEMENT