1) What is ERP?
Architecture of apps?
A packaged business software system
that lets a company automate and integrate the majority of its business
processes; share common data and practices across the enterprise; [and] produce
and access information in a real-time environment.
2) Tell me some
thing about SQL-LOADER.
Sql * loader is a
bulk loader utility used for moving data from external files into the oracle
database.
Sql * loader
supports various load formats, selective loading, and multi-tables loads.
1) conventional
--The conventional path loader
essentially loads the data by using standard ‘insert’ statement.
2) direct
-- the direct path loader
(direct = true) by possess of logic involved with that, and loads directly in
to the oracle data files.
EX:-
My data.csv file
1001, “scott tiger”,1000,40
1002,”gvreddy”,2345,50
Load data
Infile
‘c:\data\mydata.csv’
Into table emp
Fields terminated
by “,” optionally enclosed by ‘”’
(Empno, empname,
sal, deptno)
>sqlldr
scott/tiger@vis
Control=loader.ctl log= gvlog.log bad=gvbad.bad
discard=gvdis.dsc .
3) How does u dump data from pl/sql block to
flat files?
Using utl_file package, we can dump data
from pl/sql block to flat file.
PRE-REQUIREMENTS for UTL_FILE is specify
the accessible directories for the UTL_FILE function in the initialization file
(INIT.ORA) Using the UTL_FILE_DIR parameters.
Ex: UTL_FILE_DIR = <Directory
name>
EX:-
--remember to update INITSID.ORA,
--utl_file_dir = ‘c: \oradata’
Declare
Fp
utl_file.file_type;
Begin
Fp: =
utl_file.fopen (c: \oradata’, tab1.txt’,’w’);
Utl_file.putf
(fp,’%s %s \n ‘text field’, 55);
Utl_file.fclose
(fp);
End;
4) What is
SET-OF-BOOKS?
Collection of
Chat of Accounts and Currency and Calendars is called SOB
5) What is the
interface?
Interface Table is a table which is
used as medium for transfer of data between two systems.
6) What is
invoice?
Send you a request for payment
7) What is
INBOUND and OUT BOUND? (Different types of interfaces)
Inbound Interface:
For inbound interfaces, where these products
are the destination, interface tables as well as supporting validation,
processing, and maintenance programs are provided.
Outbound Interface:
For outbound interfaces, where these products
are the source, database views are provided and the destination application should
provide the validation, processing, and maintenance programs
8) Tell me what r the Base tables in the AR?
hz_parties (party_id) (store info about org, groups and people)
HZ_PARTIES stores
information about parties such as organizations, people, and groups, including
the identifying address information for the party.
hz_cust_accounts (cust_account_id)
HZ_CUST_ACCOUNTS stores
information about customer relationships. If a party becomes a customer,
information about the customer account is stored in this table. You can
establish multiple customer relationships with a single party, so each party
can have multiple customer account records in this table.
hz_cust_acct_sites_all
(cust_acct_site_id)
HZ_CUST_ACCT_SITES_ALL stores
information about customer sites. One customer account can have multiple sites.
The address is maintained in HZ_LOCATIONS.
hz_cust_site_uses_all (site_use_id)
HZ_CUST_SITE_USES_ALL stores
information about site uses or business purposes. A single customer site can
have multiple site uses, such as bill to or ship to, and each site use is
stored as a record in this table.
hz_party_sites (party_site_id)
HZ_PARTY_SITES stores information
about the relationship between Parties and Locations. The same party can have
multiple party sites. Physical addresses are stored in HZ_LOCATIONS.
hz_locations (location_id)
HZ_LOCATIONS stores information
about physical locations.
hz_Person_Profiles (person_profile_id)
HZ_PERSON_PROFILES stores
detail information about people.
hz_Organization_Profiles
(organization_profile_id)
HZ_ORGANIZATION_PROFILES stores
credit rating, financial statistics, and socioeconomic and corporate linkage
information for business sites. The primary key for this table is
ORGANIZATION_PROFILE_ID.
