APPS Technical Interview
[et_pb_section bb_built=”1″ _builder_version=”3.0.52″ background_image=”http://dev.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 |
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]