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

http://oracleapps-diary.blogspot.com/

OVERVIEW OF oracleapps-diary.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

8

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEAPPS-DIARY.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

February

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Monday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.1 out of 5 with 16 reviews

5 star

9

4 star

2

3 star

4

2 star

0

1 star

1

Hey there! Start your review of oracleapps-diary.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT ORACLEAPPS-DIARY.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

8

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

0 sec

SCORE

6.2

PAGE TITLE

Oracle Apps Diary | oracleapps-diary.blogspot.com Reviews

<META> DESCRIPTION

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

<META> KEYWORDS

1 oracle apps diary

2 select

3 steppriority

4 from

5 where

6 0 comments

7 email this

8 blogthis

9 share to twitter

10 share to facebook

CONTENT

Page content here

KEYWORDS ON PAGE

oracle apps diary,select,steppriority,from,where,0 comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels dac,obiee,practice notes,reactions,labels assignment type,labels obiee administration,obiee answers,older posts

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle Apps Diary | oracleapps-diary.blogspot.com Reviews

https://oracleapps-diary.blogspot.com

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

INTERNAL PAGES

oracleapps-diary.blogspot.com

1

Oracle Apps Diary: Practice Notes: Query for DAC metadata

http://oracleapps-diary.blogspot.com/2011/10/practice-notes-query-for-dac-metadata.html

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

2

Oracle Apps Diary: Practice Notes: PER_ALL_ASSINGMENTS_F ASSINGMENT_TYPE

http://oracleapps-diary.blogspot.com/2011/09/practice-notes-perallassingmentsf.html

Friday, September 30, 2011. Practice Notes: PER ALL ASSINGMENTS F ASSINGMENT TYPE. Probably not worth blogging. But don't have mind to just leave it after having searched for quite sometime. The lookup type for the PER ALL ASSINGMENTS F.ASSINGMENT TYPE is ALL ASGN TYPE. So next time i can just look at my diary. Posted by Parameshwaran Venkataraman. Subscribe to: Post Comments (Atom). Practice Notes: PER ALL ASSINGMENTS F ASSINGMENT T. FEEDJIT Live Traffic Feed. View my complete profile.

3

Oracle Apps Diary: April 2010

http://oracleapps-diary.blogspot.com/2010_04_01_archive.html

Wednesday, April 28, 2010. Practice Notes: Payroll Fast Formula. Fast formulas exist not only for payroll calculation but also for many other purposes. One of them being input value validation i.e. using these type of formulas we will be able to validate the screen entry values of element's input values. We can add these validations against particular elements in. Form Functions(ctrl L) - element entries. Such custom formula can be created in. Form Functions(ctrl L) - write formula. Let us consider an ex...

4

Oracle Apps Diary: May 2010

http://oracleapps-diary.blogspot.com/2010_05_01_archive.html

Tuesday, May 25, 2010. OBIEE - Script for creating Time Dimension. A basic plsql script for creating time dimension table and populating it with data for years together. CREATE TABLE mh time periods. Time period id NUMBER NOT NULL. YEAR NUMBER(4) NOT NULL. Quarter NUMBER(1) NOT NULL. MONTH NUMBER(2) NOT NULL. DAY NUMBER(2) NOT NULL. Month end flag char(1) DEFAULT 'N'. Year end flag char(1) default 'N'. Quarter end flag CHAR(1) DEFAULT 'N'. Period date DATE NOT NULL. P end date DATE. L day NUMBER(2) := 1;.

5

Oracle Apps Diary: August 2011

http://oracleapps-diary.blogspot.com/2011_08_01_archive.html

Tuesday, August 23, 2011. OBIEE : Beware of Session Variables. Blogging after a long time. It may be interesting to note some interesting outcomes in the usage of server variables. You may refer to the syntax of using different OBIEE variables here. We may note that the syntax for referring a session variables is. VALUEOF(NQ SESSION.sess var name) - - - - (1). To refer a repository variable,. VALUEOF("rep var name") - - - - - - - - (2). But what if you refer a session variable using syntax (2)?

UPGRADE TO PREMIUM TO VIEW 3 MORE

TOTAL PAGES IN THIS WEBSITE

8

OTHER SITES

oracleapplicationstraining.com

間違いなく女子力アップできるネイルサロン

その中でも銀座に店舗を構えるネイルサロントリシアはどのお客様も大切な友人をお迎えする気持ちでおもてなししてくれるので、居心地も良く気軽に立ち寄ることができます。

oracleapplinks.blogspot.com

Nice Links for Oracle Applications

Nice Links for Oracle Applications. Blog gives nice links for Oracle Application. Friday, September 29, 2006. Oracle General Ledger Overview. In AppsBI : Applications Business Intelligence. Nilesh Jethwa posted this nice overview about Oracle General Ledger. It is very nice introduction for people who wants to learn Oracle Apps without Accounting backgroud. Posted by Karth @ 4:15 AM 0 comments. Oracle EBS 11.5.10.2 Installation Steps. Has nice step by step guide to install on Linux. Posted by Karth @ 3:3...

oracleappraisals.com

Real Estate Appraisal - home appraisal - appraiser - real estate appraiser - residential appraisals - [CITY], [STATE] - [COMPANY]

This website is no longer active. To find other Real Estate Appraisers in Litchfield County,. Visit the XSites Network by clicking here. You can use the XSites Network to find real estate property listings. If you are the site owner and wish to reactivate your site call 1-800-ALAMODE (252-6633).

oracleapps-abdulwazid.blogspot.com

Oracle Apps Technical

Thursday, 21 December 2017. Interview Question for Oracle Apps Technical. Define Interfaces. What are the different types of Interfaces? Interfaces are used to integrate external systems and data conversion in Oracle Applications. These can be used to either transfer data from Oracle Applications to a Flat File or Data from Legacy System to Oracle Applications. There are two types of Interfaces. Inbound and Outbound Interfaces. Open Interface is the interface whose interface logic is provided by Oracle.

oracleapps-atechniciansview.blogspot.com

Oracle Apps - A Technician's View

Oracle Apps - A Technician's View. Some Oracle Applications Technical Topics. Thursday, August 9, 2012. How to find the Package/Procedure/View associated with A WEBADI Integrator. At times we want to know what is the name of the pacakge/procedure/view assciated with a WEBADI. I stuggle to get this information for long and finally got the answer, posting the same for easy reference. Query to find the View Name :. SELECT bct.user name. FROM apps.bne contents tl bct,. Appsbne contents b bcb,. DISCLAIMER: PL...

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