oracleappssolution.com

oracleappsscripts.blogspot.com

Oracle Applications Scripts

Wednesday, July 22, 2009. Job Creation Sample Script. Op object version number. X job definition id. Lv job group id. Lv job group id. P business group id. P job group id. Lv job group id. P object version number. Op object version number. P job definition id. X job definition id. OUTPUT JOB NAME CREATED : '. Error Message Is: '. Create Employee API Sample Script. Ip p person id NUMBER;. Ip p assignment id NUMBER;. Ip p per object version number NUMBER;. Ip p asg object version number NUMBER;. P sex = 'M'.

oracleappsscriptsandtips.blogspot.com

Oracle Apps Scripts & Tips

Oracle Apps Scripts and Tips. Thursday, June 30, 2016. Query to find out online users. The following query is mainly intended to identify online users as batch jobs can be monitored via the Concurrent Manager. SELECT c.SID, c.serial# ser, c.module, SUBSTR (c.program, 1, 10) program,. Clast call et last call, c.sql hash value, d.spid, c.process. FROM v$session c, v$process d. WHERE c.status = 'ACTIVE' - the session is running in the database. AND clast call et 300 - has been running for over 300 seconds.

oracleappssolution.blogspot.com

Oracle Apps Solution

XML REPORT IN ORACLE APPS and HOW TO GET THE TRACE. There was an error in this gadget. Thursday, May 2, 2013. Posted by Poonam Yadav. Links to this post. Link Between AR transcation and AR receipts:. SELECT ACR.RECEIPT NUMBER RECEIPT NO,RCT.TRX NUMBER INVOICE NO. FROM AR RECEIVABLE APPLICATIONS ALL ARA,. AR CASH RECEIPTS ALL ACR,. RA CUSTOMER TRX ALL RCT. AND ARA.CASH RECEIPT ID=ACR.CASH RECEIPT ID. AND ARA.APPLIED CUSTOMER TRX ID=RCT.CUSTOMER TRX ID. How to Use ROUND in SQL. PARAMETERS OF PROCEDURE :.

oracleappssolution.com

Parking Page

This Site is Under Construction.

oracleappssolutions.com

Parking Page

This Site is Under Construction.

oracleappsstore.wordpress.com

Oracle Apps Store

Oracle Apps Store is Designed and Developed to help people learn New concepts and functionalities who are new to Oracle Applications and who wants to update their knowledge base. We will try our level best to provide screen shots and step-by-step Navigations possible. We welcome author’s who can explain new Concepts. 1 Rating the Document (at the beginning of every post below to the heading). 2 Sharing the information to friends. 3 Like Oracle Apps Store in Facebook. October 4, 2012 at 8:18 AM. I have a ...

oracleappstech-vinoth.blogspot.com

Oracle Apps Technical Related

Oracle Apps Technical Related. Select * from oracle apps technical where level in ('Basic','Intermediate');. Wednesday, March 12, 2014. API to add the responsibility to the user. Fnd user pkg.addresp(username = '. Resp app = 'SYSADMIN'. Resp key = 'SYSTEM ADMINISTRATOR'. Security group = 'STANDARD'. Description = 'Auto Assignment'. Start date = SYSDATE - 1. End date = SYSDATE 1000);. Friday, February 28, 2014. OM to AR and SC to AR Linking queries. OM to AR Table linkage. SELECT ooha.order number. TO CHA...

oracleappstech.com

Coming Soon - Future home of something quite cool

Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.

oracleappstechawareness.blogspot.com

OracleApps - TechKnowledge

Thursday, June 24, 2010. Oracle Apps all module questions. Subscribe to: Posts (Atom). Srikanth Finance Functional and Other stuff. Oracle Apps all module questions. View my complete profile. Watermark template. Powered by Blogger.