Introduction
One of the most common requirement for every Technical Consultant working with Oracle and Related Technologies is to find out specific database tables which holds a specific piece of information. This input is required to create reports, understand links between various tables and even for troubleshooting purpose.
While I don’t deny that this information can also be easily available from Fusion Apps OER Tables and Views section but sometimes they might not yield desired results.
Say for example, I am interested to know Which All Tables has ASSIGNMENT_ID as a table column
We would try to find the answer to this question in two ways:
-
Using OER
-
Executing a SQL
So let’s begin then
Using OER
As a first step we would click on the Fusion Apps OER link which will take us to the below page:
Next, we need to click on Functional Area ( either of Sales, Global Human Resources, Financials, Procurement, Project Portfolio Mgmt, Supply Chain Mgmt) and then choose any of the available options under Tables and Views Section (highlighted below)
Once you click the same it will take you to a new screen (screen-shot below)
One would enter the name of the Table , Field, View in the Search Text Box (Highlighted in yellow in above screenshot) and when they click on serach icon the below screen will appear
We could see that the search returns 150 results and only the first 20 are shown. One can use the Prev/Next button to navigate through the entire list.
We would click on Next and
Bump! While we were expecting to see the next 20 items we got a “No results found ”. Not sure why this happened but yes these things do happen . If we are lucky enough we can get the details in the first page of search and are good to go but if not we need to find an alternative solution. The SQL based approach might come to rescue in such cases.
Executing a SQL
One may even create a SQL data model to find the details. For this example we would illustrate ow o find list of all tables which holds a particular column (Assignment_id) .
We would use the below SQL query and create a Data Model
SQL Query |
SELECT * FROM ALL_TAB_COLUMNS |
Screenshot
And once we click on Data (Tab) and pass Assignment_Id as the Column Name in parameter followed by a click on View we could see the results
Note: There is a LOV List besides Rows which by default holds a value of 5 and other available values are 10,50,100,200. So in case there are more than 200 rows (which one can figure out by running a count(*) query on the above sql ) one would need to create a report.
Comments
I've read stuff from. I appreciate you for posting when yoou have the opportunity, Guess I will juzt book mark this site.
Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!) Excellent
job. I really enjoyed what you had to say, and more than that,
how you presented it. Too cool!
the time.
user can know it. So that's why this post is perfect.
Thanks!
as I provide credit and sources back to your weblog? My website is in the exact
same niche as yours and my users would truly benefit from a lot of the information you present here.
Please let me know if this okay with you.
Many thanks!
thats why i have read it fully
that in fact how to do blogging.
it can survive a 40 foot drop, just so she
can be a youtube sensation. My apple ipad is now broken and she has 83 views.
I know this is completely off topic but I had to share it with someone!
20% greater than when you started.
my blog post :: Click
here: https://cse.google.ps/url?sa=t&url=https%3A%2F%2Fnewtt.com%2F
to Powerball's website.
Here is my web blog Visit this website: https://cse.google.com.tr/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
Lottery and 1 of two men, along with Steve Caputo, who came up with the Powerball game.
my homepage ... Look
at more info: https://www.google.com.om/url?sa=t&url=https%3A%2F%2Fbgbbg.com%2F
Here is my web site ... here: https://cse.google.com.br/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
Here is myy web page - Additional resources: https://cse.google.bs/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
Corporation.
Feel free to surf to my web page ... Homepage: https://images.google.td/url?sa=t&url=https%3A%2F%2Fclubnow.top%2F
my website - Additional resources: https://maps.Google.to/url?sa=t&url=https%3A%2F%2Fgo-poker.com%2F
Here is my homepage - The original source: https://maps.google.tn/url?sa=t&url=https%3A%2F%2Fbgbbg.com%2F
Review my page :: Helpful resources: https://maps.google.mw/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
Powerball, according to USA These days.
Take a liok at my webpage Check over here: https://cse.google.ne/url?sa=t&url=https%3A%2F%2Fnewtt.com%2F
Stop by my blog post: Go to
this site: https://www.google.co.ls/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
Also visit myy webpage: Click for info: https://maps.google.com.na/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
my web-site Check over
here: https://cse.google.ru/url?sa=t&url=https%3A%2F%2Fcacake.top%2F
Look info myy blog post: Get more information: https://www.google.tt/url?sa=t&url=https%3A%2F%2Fmcmong.top%2F
bapls and tthe red Powerball number.
My web page ... follow this link: https://www.google.ht/url?sa=t&url=https%3A%2F%2Fmcmong.top%2F
evenibg ere six, 14, 25, 33, and 46.
My homepage: Have a peek
here: https://maps.google.lt/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
drawing Tuesday night.
Feel free to surf to my web blog; website: https://t.me/iv?url=https%3A%2F%2Fmrblog.top
Here is my web page; Visit this page: https://images.google.com.et/url?sa=t&url=https%3A%2F%2Fmrblog.top%2F
Stop by my website: Click for source: https://cse.google.com.lb/url?sa=t&url=https%3A%2F%2Fbgbbg.com%2F
my webpage Additional
reading: https://cse.google.fm/url?sa=t&url=https%3A%2F%2Fblogee.top%2F
according to the lottery website, orr have tthe choice
of $450.2 million in money.
Take a look at my web site :: The original source: https://cse.google.com.tj/url?sa=t&url=https%3A%2F%2Fblogee.top%2F
Review mmy blog post click
here: https://cse.google.com.ng/url?sa=t&url=https%3A%2F%2Fdoitblog.top%2F
Feel free to surf to my webpage - More
helpful hints: https://cse.google.mv/url?sa=t&url=https%3A%2F%2Fdoitblog.top%2F
prize of $416 million inn the draw heeld on Monday, Dec.
27.
Heree is my web blog Click here
for more: https://www.bing.com/news/apiclick.aspx?ref=FexRss&aid=&tid=9BB77FDA801248A5AD23FDBDD5922800&url=https%3A%2F%2Fmcmong.top
Feel ree to surf to my blog; Additional resources: https://images.google.com.jm/url?sa=t&url=https%3A%2F%2Fbgbbg.com%2F
Look at my site; Home page: https://cse.google.com.sg/url?sa=t&url=https%3A%2F%2Ftoscorp.com%2F
workplace for prize payment.
Also visit mmy blog post: website: https://images.google.com.my/url?sa=t&url=https%3A%2F%2Fexoblog.top%2F
Also visit my web-site; Helpful site: https://www.google.lv/url?sa=t&url=https%3A%2F%2Fnewtt.com%2F
Stopp by my blog post - More helpful hints: https://www.google.st/url?sa=t&url=https%3A%2F%2Fdoitblog.top%2F
Visit my web blog - Extra resources: https://www.google.com.tw/url?sa=t&url=https%3A%2F%2Fnewtt.com%2F
is the youngest player in in Florida Lottery history to win a Powerball jackpot, the
agency said Thursday.
Feel free to visit my webpage :: Article source: https://www.google.sr/url?sa=t&url=https%3A%2F%2Fnewtt.com%2F
Oct. 4, 2021 drawing byy a single ticket in California that won a $699.8 million grand prize.
Also visit my homepage; More help: https://Maps.google.hr/url?sa=t&url=https%3A%2F%2Fandit.top%2F
prizes earned from physical tickets.
Feel free to surf to my page ... Additional hints: https://www.google.hn/url?sa=t&url=https%3A%2F%2Fgo-poker.com%2F
My blog post :: Go
here: https://maps.google.dm/url?sa=t&url=https%3A%2F%2Fceravilla.com%2F
Here is myy webpage ... Click for source: https://www.google.fi/url?sa=t&url=https%3A%2F%2Fgo-poker.com%2F
$225.1 million cssh — both pre-tax —Powerball mentioned.
My web blog: Learn here: https://maps.google.hu/url?sa=t&url=https%3A%2F%2Fceravilla.com%2F
in California, Florida and Tennessee.
Here is my website ... Click for more info: https://maps.google.cl/url?sa=t&url=https%3A%2F%2Fceravilla.com%2F
сайтов заказать создание корпоративного сайта
Feel free to surf to mmy web page: Visit
website: https://Cse.google.co.in/url?sa=t&url=https%3A%2F%2Fbgbbg.com%2F
my wweb blog; Click for info: https://www.google.kz/url?sa=t&url=https%3A%2F%2Fcacake.top%2F
My web page; Helpful hints: https://cse.google.md/url?sa=t&url=https%3A%2F%2Fcacake.top%2F
national sales.
Feel free to surf to my wweb blog: Go here: https://maps.google.com.sb/url?sa=t&url=https%3A%2F%2Fcacake.top%2F
jackpot, this would be foolish.
mywebsite :: Informative post: https://www.google.com.gi/url?sa=t&url=https%3A%2F%2Fmrblog.top%2F
great draw gamess to attempt your luck on ...
my page ... Click here!: https://www.google.com.cy/url?sa=t&url=https%3A%2F%2Fbuzzplot.top%2F
tax liabilities, according lottery officials.
Here iss my webb blog ... Visit
this page: https://images.google.ca/url?sa=t&url=https%3A%2F%2Feggcs.com%2F
$80 million Powerball jackpot.
My blog post; Extra resources: https://maps.google.dm/url?sa=t&url=https%3A%2F%2Feggcs.com%2F
Feel frde to visit mmy site: Continue reading: https://cse.google.co.ao/url?sa=t&url=https%3A%2F%2Feggcs.com%2F
Look into my webpage :: Click here: https://www.google.be/url?sa=t&url=https%3A%2F%2Feggcs.com%2F
ones are most most likely to enale yyou strikke itt wealthy.
Look into my webpage: Helpful
site: https://Images.Google.ee/url?sa=t&url=https%3A%2F%2Fuprice.top%2F
in San Francisco Bay. This article will provide information on Arroyo Alto
Prep, Irvington, El Modena, Bellarmine, and more.
These schools are famous for their academic achievements.
But what do you think of the riding experience? Are you looking for an adventure?
Prep for the Sacred Heart
Sacred Heart Prep in Arroyo defeated Sacred Heart Prep in Arroyo Arroyo Grande 10-6 in a nonleague girls water polo
match on Thursday. Ashley Penner scored two goals and also assisted with
three goals. The Sacred Heart Prep girls water
polo team plays St. Ignatius in a WCAL match
on Wednesday. SHP defeated Arroyo Grande 7-5 at the
St. Francis Invitational.
Irvington
The Arroyo Alto area offers an excellent neighborhood for those looking to buy a home.
This gorgeous home has stunning views of the lake
and an excellent layout. The living space includes a gas fireplace, a
boveda brick ceiling, a pantry, and an open plan.
The kitchen is equipped with stainless steel appliances as well as sliding glass doors that open to a
covered patio that allows for outdoor and indoor living.
The master bedroom features an extensive walk-in closet, as well as its own private
covered patio.
El Modena
The El Modena High School, a Distinguished School located in California
was established in 1966 and has been serving the community of East
Orange for nearly four decades. It has graduated more
than 10000 students and alumni share an enduring bond.
Here are five memorable memories from the El Modena experience.
Continue reading to find out more. These are the most common feedback we
receive from students about El Modena High School.
Bellarmine
Bellarmine changed its name from the original "Bellarmine College Preparatory" in 1928.
The school was named in honor of the Jesuit of the 16th century,
Robert Cardinal, who was a canonized saint. The school colors changed from the red and white of Santa Clara to blue and white which
are the colors of Saint Mary. The athletics program at the school is
among the top ten in California.
Villa Park
In 1860, Villa Park was known as Mountain View and the
Post Office refused to deliver mail to this area. The town was about the same size as Anaheim and Orange in 1880.
Horse and buggies were the commonplace. There were many orchards, primarily of citrus,
walnuts, apricots and grapes. It was the birthplace of the first Miss Villa Park, Millicent
Strahan.
St. Ignatius
Since 1886, St. Ignatius Catholic Jesuit High School has been forming future leaders, focusing on academics and outstanding athletics.
The school's culture is a reflection of its commitment to faith as well as academics.
St. Ignatius offers many opportunities for students to
enhance their education, including the Summer Enhancement Program.
The athletics program offers students in the eighth grade an opportunity to learn more about the game as well as their peers.
and I'm surprised why this twist of fate did not took
place in advance! I bookmarked it.
I'll bookmark your web site and take the feeds additionally?
I am glad to search out a lot of useful information here within the submit, we want work
out more strategies in this regard, thanks for sharing. .
. . . .
My web site - RUAY: https://community.standout.digital/user/ruayshuay
I'm planning to start my own site soon but I'm a little lost on everything.
Would you advise starting with a free platform like Wordpress or go for a paid option? There are so many options out there that I'm totally confused ..
Any ideas? Thank you!
My blog post RUAY: https://www.goodreads.com/user/show/124428964-ruayshuay
well as with the layout on your weblog. Is this a paid theme
or did you customize it yourself? Anyway keep up the nice quality writing, it's rare to see a great
blog like this one nowadays.
Check out my web site - RUAY: https://www.mapleprimes.com/users/ruayshuay
author.I will make sure to bookmark your blog
and may come back in the future. I want to encourage you to ultimately continue your
great job, have a nice weekend!
My web-site :: RUAY: https://www.arkcorp.com.au/community/profile/ruayshuay123/
this post was good. I do not know who you are but definitely you are going to a famous blogger if
you aren't already ;) Cheers!
My blog post: RUAY: https://yed.yworks.com/support/qa/user/ruayshuay
different topic but it has pretty much the same layout and design. Superb choice of colors!
Also visit my web site; RUAY: https://www.turnkeylinux.org/user/1648165
amazing spirit.
my website ... RUAY: https://stackoverflow.com/users/17720383/ruays-huay
like yours these days. I truly appreciate people like you!
Take care!!
my page ... RUAY: https://cycling74.com/author/5f9f72dae738ca58a079eb8e
are you using? Can I get your affiliate link to your host?
I wish my site loaded up as fast as yours lol
Here is my site: แทงหวยออนไลน์: https://www.buzzfeed.com/ruayvipx
nickel
exchange
bag33ondu.com
bag33ondu.com
http://bag33ondu.com
desist
software
lacquer
RSS feed for comments to this post