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.
--The conventional path loader essentially loads the data by using standard ‘insert’ statement.
-- the direct path loader (direct = true) by possess of logic involved with that, and loads directly in to the oracle data files.
My data.csv file
1001, “scott tiger”,1000,40
Into table emp
Fields terminated by “,” optionally enclosed by ‘”’
(Empno, empname, sal, deptno)
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>
--remember to update INITSID.ORA,
--utl_file_dir = ‘c: \oradata’
Fp: = utl_file.fopen (c: \oradata’, tab1.txt’,’w’);
Utl_file.putf (fp,’%s %s \n ‘text field’, 55);
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)
For inbound interfaces, where these products are the destination, interface tables as well as supporting validation, processing, and maintenance programs are provided.
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 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 stores information about customer sites. One customer account can have multiple sites. The address is maintained in HZ_LOCATIONS.
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 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 stores information about physical locations.
HZ_PERSON_PROFILES stores detail information about people.
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.