oracleappss.blogspot.com
Oracle Apps TechnicalObjective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps.
http://oracleappss.blogspot.com/
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps.
http://oracleappss.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Monday
LOAD TIME
0.5 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
7
SSL
EXTERNAL LINKS
0
SITE IP
172.217.11.33
LOAD TIME
0.484 sec
SCORE
6.2
Oracle Apps Technical | oracleappss.blogspot.com Reviews
https://oracleappss.blogspot.com
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps.
oracleappss.blogspot.com
Oracle Apps Technical: Create Agency Phone details
http://oracleappss.blogspot.com/2009/10/create-agency-phone-details.html
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps. Tuesday, October 20, 2009. Create Agency Phone details. CREATE OR REPLACE PROCEDURE XXX Hrmig Proc Agency Phone AS. L object version number NUMBER(30);. L phone id NUMBER(30);. L err message VARCHAR2(1000);. Ls err msg VARCHAR2(200);. L valid VARCHAR2(10) := 'Y';. L effective date DATE;. L rows processed NUMBER := 0;. L commit point NUMBER := 10;. WHERE last n...
Oracle Apps Technical: October 2009
http://oracleappss.blogspot.com/2009_10_01_archive.html
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps. Tuesday, October 20, 2009. CREATE OR REPLACE PROCEDURE XXX Hrmig Proc Contact Rel AS. LN ROWS PROCESSED NUMBER := 0;. LN COMMIT POINT NUMBER := 50;. LS FIRST NAME VARCHAR2(20);. LS MIDDLE NAME VARCHAR2(60);. LS LAST NAME VARCHAR2(40);. LN PERSON ID NUMBER;. LN ASSIGNMENT ID NUMBER;. LN PER OBJECT VERSION NUMBER NUMBER;. LN ASG OBJECT VERSION NUMBER NUMBER;.
Oracle Apps Technical: Create Agency in HRMS
http://oracleappss.blogspot.com/2009/10/create-agency-or-third-party.html
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps. Tuesday, October 20, 2009. Create Agency in HRMS. CREATE OR REPLACE PROCEDURE XXX Hrmig Proc Agency AS. LN ROWS PROCESSED NUMBER := 0;. LN COMMIT POINT NUMBER := 50;. LS ERROR TEXT VARCHAR2(2000);. L ERR MESSAGE VARCHAR2(1000);. L VERIFY FLAG VARCHAR2(10):='Y';. LN PERSON ID NUMBER;. L OBJECT VERSION NUMBER NUMBER(10);. L EFF START DATE DATE;. P sex = 'M'.
Oracle Apps Technical: Item on hand quantity , Lot and Serial No Interfaces
http://oracleappss.blogspot.com/2008/07/item-on-hand-quantity-lot-and-serial-no.html
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps. Friday, July 25, 2008. Item on hand quantity , Lot and Serial No Interfaces. TO MIGRATE ITEM ON HAND QUANTITY , LOT and SERIAL NO. Interface Tables are :-. Mtl transaction lots interface. Mtl serial numbers interface. How to run the Import Pgm :. Inventory Super User -. Tool from Menu -. After correcting the error apply the below code. Set process flag = 1,.
Oracle Apps Technical: Create Employee Records
http://oracleappss.blogspot.com/2009/10/create-employee-records.html
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps. Tuesday, October 20, 2009. How to create Employee records through "Hr Employee Api.CREATE EMPLOYEE". Please make the necessary changes according to your requirements. Please create the structure for the staging table "XXX HRMIG EMP PER 16MAR07". CREATE OR REPLACE PROCEDURE XXX Hrmig Proc Create Emp AS. LN ROWS PROCESSED NUMBER := 0;. LN PERSON ID NUMBER;.
TOTAL PAGES IN THIS WEBSITE
7
Computer Creations Inc.
Oracle Applications DBA and Developer. Managing an Oracle Applications instance is no small task. The consultants at Computer Creations can help you with. Aspects of your Oracle Applications installation:. Install and Upgrade Oracle Applications. Install and Upgrade Oracle Database software. Oracle Application and database tuning. Hyperion installation and support. Custom reports and software development. Mill Valley, CA 94942. Phone / (415) 310 2410. Email / Jeff@OracleAppsPro.Com.
About | www.OracleAppsQuery.com
By Babu Chalamalasetti,To help Oracle community bridge the knowledge gaps.). All Responsibilities by Module. Mobile Supply Chain Applications (MSCA). Work in Process (WIP). Bill of Materials ( BOM). Landed Cost Mgmt (LCM). Advanced Supply Chain Planning (ASCP). Global Order Promising (GOP). Asset Management ( eAM). Period End Closing Process. Period End Closing Processing - FIN. Difference between 11i and R12. Daily Business Intelligence for Projects. ALL Tables and Views. Key Flexfields ( KFF). Is an Or...
Oracle Apps Query | Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning.
Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning. August 14, 2010. Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging! Query : R12 Link ap invoice distributions all to a GL Header via SLA. August 13, 2010. Ssegment1 as supplier no,. Levent class code as event class, i.invoice id, ad.invoice distribution id,. Jlaccounted dr as debit,.
oracle apps R12(ERP)
Thursday, July 1, 2010. CREATION OF FLEX FIELD IN ORACLE APPS R12(ERP). CREATION OF FLEX FIELD. Help Diagnostics Exams. Block = $DESCRIPTIVE FLEXFIELD$. Field = where u want to create a flex field (Headers, Lines, or another form box). Value = Value automatically return. Then copy the value and past below form. Responsibility System administrator. ApplicationFlexfieldDescriptiveSegments. F11 then Past the value in title ctrl F11. Now unfreeze Flexfield Definition. Now click on segments. Enterpr...
Oracle Apps Technical
Objective of this blog is to share my oracle apps knowledge with the people who are working in oracle apps or freshers who are interested in apps. Tuesday, October 20, 2009. CREATE OR REPLACE PROCEDURE XXX Hrmig Proc Contact Rel AS. LN ROWS PROCESSED NUMBER := 0;. LN COMMIT POINT NUMBER := 50;. LS FIRST NAME VARCHAR2(20);. LS MIDDLE NAME VARCHAR2(60);. LS LAST NAME VARCHAR2(40);. LN PERSON ID NUMBER;. LN ASSIGNMENT ID NUMBER;. LN PER OBJECT VERSION NUMBER NUMBER;. LN ASG OBJECT VERSION NUMBER NUMBER;.
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 :.
