Total Pageviews

September 18, 2016

9/18/2016 09:48:00 PM

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.