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...

http://oracleapps11itechnical.blogspot.com/

OVERVIEW OF oracleapps11itechnical.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEAPPS11ITECHNICAL.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

June

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.4 out of 5 with 11 reviews

5 star

5

4 star

5

3 star

1

2 star

0

1 star

0

Hey there! Start your review of oracleapps11itechnical.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.3 seconds

CONTACTS AT ORACLEAPPS11ITECHNICAL.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

1.313 sec

SCORE

6.2

PAGE TITLE

Oracle Apps Technical 11i | oracleapps11itechnical.blogspot.com Reviews

<META> DESCRIPTION

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...

<META> KEYWORDS

1 declare

2 cursor cur rec

3 select

4 begin

5 select user id

6 from fnd user

7 loop

8 description = null

9 commit;

10 end loop;

CONTENT

Page content here

KEYWORDS ON PAGE

declare,cursor cur rec,select *,begin,select user id,from fnd user,loop,description = null,commit;,end loop;,end;,posted by,sreekanth,reactions,no comments,expense report/invoice entry,ap invoices all,creating payments,journal entries,gl code combinations

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle Apps Technical 11i | oracleapps11itechnical.blogspot.com Reviews

https://oracleapps11itechnical.blogspot.com

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...

INTERNAL PAGES

oracleapps11itechnical.blogspot.com

1

Oracle Apps Technical 11i: May 20, 2009

http://oracleapps11itechnical.blogspot.com/2009_05_20_archive.html

Oracle Apps Technical 11i. Wednesday, May 20, 2009. ITEM CONVERSION IN ORACLE INVENTORY MODULE WITH CODE OR CONVERT LEGACY ITEMS DATA INTO ORACLE APPS. Objects to create the Item Conversion. Formatted on 2008/11/06 11:16 (Formatter Plus v4.8.0) */. Oracle ERP 11.5.10 Implemenation. FILE NAME : XX ITEM CON CREATE OBJECTS.SQL. DESCRIPTION : CONVERSION STAGING TABLE AND ERROR TABLE. OBJECT NAMES : CREATING CONVERSION TABLE,SYNONYMS,SEQUENCES,INDEXES AND TRIGGERS. CREATED BY : SREEKANTH REEDY. INCREMENT BY 1;.

2

Oracle Apps Technical 11i: Oracle General Ledger Technical Document

http://oracleapps11itechnical.blogspot.com/2010/06/oracle-general-ledger-technical.html

Oracle Apps Technical 11i. Sunday, June 27, 2010. Oracle General Ledger Technical Document. Sets of Books and Charts of Accounts govern Oracle’s General Ledger. The set of books keeps what currency, chart of accounts structure and calendar that the book will use. The main tables for this are. GL SETS OF BOOKS. FND ID FLEX STRUCTURES. GL DAILY RATES (If needed). Payables Import to General Ledger. Create Journal Entries (Fixed Assets). PRC: Interface Revenue to General Ledger (Projects). GL SETS OF BOOKS.

3

Oracle Apps Technical 11i: ITEM CONVERSION IN ORACLE INVENTORY MODULE WITH CODE OR CONVERT LEGACY ITEMS DATA INTO ORACLE APPS

http://oracleapps11itechnical.blogspot.com/2009/05/item-conversion-in-oracle-inventory.html

Oracle Apps Technical 11i. Wednesday, May 20, 2009. ITEM CONVERSION IN ORACLE INVENTORY MODULE WITH CODE OR CONVERT LEGACY ITEMS DATA INTO ORACLE APPS. Objects to create the Item Conversion. Formatted on 2008/11/06 11:16 (Formatter Plus v4.8.0) */. Oracle ERP 11.5.10 Implemenation. FILE NAME : XX ITEM CON CREATE OBJECTS.SQL. DESCRIPTION : CONVERSION STAGING TABLE AND ERROR TABLE. OBJECT NAMES : CREATING CONVERSION TABLE,SYNONYMS,SEQUENCES,INDEXES AND TRIGGERS. CREATED BY : SREEKANTH REEDY. INCREMENT BY 1;.

4

Oracle Apps Technical 11i: Mar 5, 2009

http://oracleapps11itechnical.blogspot.com/2009_03_05_archive.html

Oracle Apps Technical 11i. Thursday, March 5, 2009. Sql Queriwns and sql Notes. How to select Nth Salary highest salary. Select sal from emp e where :n = (select count(max(sal) from emp where e.sal. 1 How to implement ISNUMERIC function in SQL *Plus? Select length (translate (trim (column name),' -.0123456789',' ') from dual ;. Will give you a zero if it is a number or greater than zero if not numeric (actually gives the count of non numeric characters). It returns 0 if it is a number, 1 if it is not.

5

Oracle Apps Technical 11i: Sep 17, 2009

http://oracleapps11itechnical.blogspot.com/2009_09_17_archive.html

Oracle Apps Technical 11i. Thursday, September 17, 2009. Signifies that the statement is a pragma (compiler directive). Pragmas are processed at compile time, not at run time. They do not affect the meaning of a program; they simply convey information to the compiler. Autonomous Transactions is the child transaction, which are Independent of Parent transactions. In Our Example, p1 is child transaction, which is used in the Parent transaction. CREATE or REPLACE Procedure p1 IS. Delete from TEST T;. After ...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

oracleapps-diary.blogspot.com

Oracle Apps Diary

Thursday, October 20, 2011. Practice Notes: Query for DAC metadata. Time and Again there may a situation where one may need find the DAC tasks which populate particular target table be it a temporary table or staging table or the warehouse table. This information could easily be found from the DAC interface. But if we need to get this data from a TOAD/SQL developer, the following query would do the work. Stepname as "DAC TASK",. Tblname as "TARGET TABLE",. Stepapp wid as "ETL LAYER",. W etl step step,.

oracleapps-mylearnings.blogspot.com

Oracle Apps Order Managemnt - My learnings

Oracle Apps Order Managemnt - My learnings. Friday, December 3, 2010. Oracle apps SCM techno functional question Arrow interview. 1Rate yourself in pl/sql and Order to cash cycle. 2 Types of cursor. 3Explicit and implicit cursor. 4Order to Cash cycle. 5How to personalise a LOV. 6back to back flow. 7Table related to Order Managemnt. 8TCA architecture ,Customer and the party tables. Sunday, November 28, 2010. Oracle apps Form Personalisation Debugging Steps. WHY FORM PERSONALISATION IS NOT WORKING. GRules ...

oracleapps.co.uk

Oracleapps.co.uk

oracleapps.com

The Sponsored Listings displayed above are served automatically by a third party. Neither the service provider nor the domain owner maintain any relationship with the advertisers. In case of trademark issues please contact the domain owner directly (contact information can be found in whois).

oracleapps11idba.blogspot.com

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...

oracleapps123.blogspot.com

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

oracleapps4u.blogspot.com

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 ...