Apps Technical Interview Questions Part 1

[et_pb_section bb_built=”1″ _builder_version=”3.0.52″ background_image=”https://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg” parallax=”on” parallax_method=”off” inner_shadow=”on”][et_pb_row _builder_version=”3.0.52″ parallax=”on” parallax_method=”off” background_position_1=”top_left” background_repeat_1=”no-repeat” make_fullwidth=”on” use_custom_width=”on” custom_width_percent=”100%” custom_width_px=”1702px” use_custom_gutter=”on” width_unit=”off” make_equal=”on”][et_pb_column type=”4_4″][et_pb_toggle _builder_version=”3.0.52″ title=”What is an ERP?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

• It is 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, which produce and access information in a real-time environment.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me some thing about SQL-LOADER?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

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. There are commonly Two ways of loading format as given below:

• Conventional – The conventional path loader essentially loads the data by using standard ‘insert’ statement.
• Direct – Direct path loader (direct = true) by possess of logic involved with that, and loads directly in to the oracle data files.

 

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How would you dump data from pl/SQL block to flat files?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

We can dump data from pl/SQL block to flat file using UTL_FILE Package.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is SET-OF-BOOKS or SOB?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

Collection of Chat of Accounts and Currency and Calendars is called Set of Books or SOB.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the interface table?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

Interface Table is a table which is used as medium for transfer data between two systems.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is invoice?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

It is a document for request payment.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me what are the Base tables in the AR?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

hz_parties Name of Contents show 1 hz_parties 1.1 HZ_PARTIES stores information about parties such as organizations, people, and groups, including address information for the party. 2 hz_cust_accounts 2.1 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. 3 hz_cust_acct_sites_all 3.1 HZ_CUST_ACCT_SITES_ALL stores information about customer sites.One customer account can have multiple sites. The address is maintained in HZ_LOCATIONS. 4 hz_cust_site_uses_all 4.1 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. 5 hz_party_sites 5.1 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. 6 hz_locations 6.1 HZ_LOCATIONS stores information about physical locations. 7 hz_Person_Profiles 7.1 HZ_PERSON_PROFILES stores detail information about people. 8 hz_Organization_Profiles 8.1 HZ_ORGANIZATION_PROFILES stores credit rating, financial statistics, socio economic and corporate linkage information for business sites. 9 Ra_customers_interface_all 9.1 This table stores customer, address, and business purpose information. You do not have to enter values in this table if you do not want to import customers, addresses, or business purposes. 10 Ra_customer_profile_int_all 10.1 A customer level profile must exist in A_CUSTOMER_PROFILES_INTERFACE for new customers and each bill–to business purpose. 11 Ra_contact_phones_int_all 11.1 This table stores telephone numbers for customers, addresses and contacts. 12 Ra_customer_banks_int_all 12.1 This table stores bank information for a customer or for a specific Bill–To address, you must enter a bank account for this customer. 13 Ra_cust_paymethod_int_all 13.1 To import payment methods for customers and bill–to business purposes 13.2 · Ra_customers_stg 13.3 · Ra_customers_address_stg 13.4 · Ra_customers_point_stg 13.5 · Ra_customers_contact points_stg 13.6 · Ra_customers_relate_stg 13.7 · Ra_customer_error 14 Ra_customers_interface_all 14.1 · Orig_system_customer_ref 14.2 · insert_update_flag 14.3 · customer_number 14.4 · customer_status 14.5 · last_updated_by 14.6 · last_updated_date 14.7 · created_by 14.8 · creation_date. 15 Ra_customer_profile_int_all 15.1 · customer_profile_class_name 16 Ra_contact_phones_int_all 16.1 · orig_system_telephone_ref 16.2 · telephone 16.3 · telephone_type 17 Ra_customer_banks_int_all 17.1 · bank_a/c_name 17.2 · bank_a/c_no 17.3 · bank_a/c_currency_code 18 Ra_cust_paymethod_int_all 18.1 · payment_method_name 19 Receivables > Interface > Customers 19.1 · RA_SITE_USES_ALL 19.2 · RA_CUSTOMER_RELATIONSHIPS_ALL 19.3 · RA_CUST_RECEIPT_METHODS 19.4 · AP_BANK_BRANCHES 19.5 · AP_BANK_ACCOUNTS_ALL 19.6 · AP_BANK_ACCOUNT_USES_ALL 20 About 10,000 records per batch is ideal, it is suggested to keep the batch small.	HZ_PARTIES stores information about parties such as organizations, people, and groups, including address information for the party.
hz_cust_accounts	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	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	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	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	HZ_LOCATIONS stores information about physical locations.
hz_Person_Profiles	HZ_PERSON_PROFILES stores detail information about people.
hz_Organization_Profiles	HZ_ORGANIZATION_PROFILES stores credit rating, financial statistics, socio economic and corporate linkage information for business sites.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me about some customer interface tables and there uses?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

Ra_customers_interface_all	This table stores customer, address, and business purpose information. You do not have to enter values in this table if you do not want to import customers, addresses, or business purposes.
Ra_customer_profile_int_all	A customer level profile must exist in A_CUSTOMER_PROFILES_INTERFACE for new customers and each bill–to business purpose.
Ra_contact_phones_int_all	This table stores telephone numbers for customers, addresses and contacts.
Ra_customer_banks_int_all	This table stores bank information for a customer or for a specific Bill–To address, you must enter a bank account for this customer.
Ra_cust_paymethod_int_all	To import payment methods for customers and bill–to business purposes

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Write down the staging tables in the customer interface?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

·         Ra_customers_stg

·         Ra_customers_address_stg

·         Ra_customers_point_stg

·         Ra_customers_contact points_stg

·         Ra_customers_relate_stg

·         Ra_customer_error

 

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me some mandatory columns in the customer interface tables?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

Ra_customers_interface_all	·         Orig_system_customer_ref ·         insert_update_flag ·         customer_number ·         customer_status ·         last_updated_by ·         last_updated_date ·         created_by ·         creation_date.
Ra_customer_profile_int_all	·         customer_profile_class_name
Ra_contact_phones_int_all	·         orig_system_telephone_ref ·         telephone ·         telephone_type
Ra_customer_banks_int_all	·         bank_a/c_name ·         bank_a/c_no ·         bank_a/c_currency_code
Ra_cust_paymethod_int_all	·         payment_method_name

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Tell me the Navigation for customer interface?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

   Receivables > Interface > Customers

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Which tables we cannot be updated through customer interface?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

·         RA_SITE_USES_ALL

·         RA_CUSTOMER_RELATIONSHIPS_ALL

·         RA_CUST_RECEIPT_METHODS

·         AP_BANK_BRANCHES

·         AP_BANK_ACCOUNTS_ALL

·         AP_BANK_ACCOUNT_USES_ALL

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How to record additional customer and address information through customer interface?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

We Can use attributes columns for saving additional information in following tables:

• Additional Customer data can be populated in RA_CUSTOMERS_INTERFACE_ALL from customer_attribute1 to customer_attribute15 which will be populated in RA_CUSTOMERS from attribute1 to attribute15.

 

• Additional address information can be populated in RA_CUSTOMERS_INTERFACE_ALL from address_attribute1 to address_attribute15, which will be populated in RA_ADDRESSES_ALL from attribute1 to attribute15

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What should be the Ideal batch size (number of customer records) general guidelines for optimal performance?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

About 10,000 records per batch is ideal, it is suggested to keep the batch small.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”How do you send records at customer level profile and address/site level profile?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

For every customer record in RA_CUSTOMERS_INTERFACE_ALL  insert two records  in table RA_CUSTOMER_PROFILES_INT_ALL.

(Refer Note: 1070800.6 )

[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section]