141) What is the name of the column in CUSTOMER_INTERFACE_TABLE that indicates whether you
are inserting new or updating existing information
A: When importing data into the interface tables, the column INSERT_UPDATE_FLAG indicates whether you are inserting new or updating existing information. This column is required in RA_CUSTOMERS_INTERFACE. 46
142) If the INSERT_UPDATE_FLAG is not set correctly or the required column is missing the value, will CUSTOMER INTERFACE reject the entire record or just the attributes u want to update
A Reject the entire record.
143) List some of the required columns for the RA_CUSTOMERS_INTERFACE
A. ORIG_SYSTEM_CUSTOMER_REF
INSERT_UPDATE_FLAG
CUSTOMER_NAME
CUSTOMER_NUMBER (if you are not using Automatic Customer Numbering)
CUSTOMER_STATUS
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
If you are importing an address and a business purpose, you must also populate the following columns:
PRIMARY_SITE_USE_FLAG (if you are inserting an address)
LOCATION (if you are not using Automatic Site Numbering)
SITE_USE_CODE (if you are inserting an address)
ADDRESS1
144) List some of the production tables that Customer Interface transfers customer data from the interface tables into
A. AR_CUSTOMER_PROFILES
AR_CUSTOMER_PROFILE_AMOUNTS
RA_ADDRESSES
RA_CONTACTS
RA_CUSTOMERS
RA_CUSTOMER_RELATIONSHIPS
RA_CUST_RECEIPT_METHODS
RA_PHONES
RA_SITE_USES
AP_BANK_ACCOUNT_USES
AP_BANK_ACCOUNTS
AP_BANK_BRANCHES
145). What validation must be given on the customer_number
A Must be null if you are using Automatic Customer Numbering. Must exist if you are not using Automatic Customer Numbering. This value must be unique within RA_CUSTOMERS.
146) What validation must be given on the CUSTOMER_STATUS
A Must equal 'A' for Active or ?I? for Inactive.
147) Name some of the Oracle receivables Interfaces
A a) Auto Invoice
b) Auto Lockbox
c) Customer Interface 47
d) Sales Tax rate Interface
e) Tax Vendor Extension
148) Give some of the Oracle Payables interface
A. a) Credit Card Transaction Interface
b) Invoice Import Interface
c) Payables Open Interface
d) Purchase Order Matching
149). Name some of the oracle general ledger Interface
A a) Budget Upload
b) Importing Journals
c) Loading Daily rates
150). What are the names of the parameters u pass to the Procedure which u register in the apps
A. 1) retcode in varchar2
2) errbuf in varchar2
151). What is the use of Auto lock Box
A Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.
are inserting new or updating existing information
A: When importing data into the interface tables, the column INSERT_UPDATE_FLAG indicates whether you are inserting new or updating existing information. This column is required in RA_CUSTOMERS_INTERFACE. 46
142) If the INSERT_UPDATE_FLAG is not set correctly or the required column is missing the value, will CUSTOMER INTERFACE reject the entire record or just the attributes u want to update
A Reject the entire record.
143) List some of the required columns for the RA_CUSTOMERS_INTERFACE
A. ORIG_SYSTEM_CUSTOMER_REF
INSERT_UPDATE_FLAG
CUSTOMER_NAME
CUSTOMER_NUMBER (if you are not using Automatic Customer Numbering)
CUSTOMER_STATUS
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
If you are importing an address and a business purpose, you must also populate the following columns:
PRIMARY_SITE_USE_FLAG (if you are inserting an address)
LOCATION (if you are not using Automatic Site Numbering)
SITE_USE_CODE (if you are inserting an address)
ADDRESS1
144) List some of the production tables that Customer Interface transfers customer data from the interface tables into
A. AR_CUSTOMER_PROFILES
AR_CUSTOMER_PROFILE_AMOUNTS
RA_ADDRESSES
RA_CONTACTS
RA_CUSTOMERS
RA_CUSTOMER_RELATIONSHIPS
RA_CUST_RECEIPT_METHODS
RA_PHONES
RA_SITE_USES
AP_BANK_ACCOUNT_USES
AP_BANK_ACCOUNTS
AP_BANK_BRANCHES
145). What validation must be given on the customer_number
A Must be null if you are using Automatic Customer Numbering. Must exist if you are not using Automatic Customer Numbering. This value must be unique within RA_CUSTOMERS.
146) What validation must be given on the CUSTOMER_STATUS
A Must equal 'A' for Active or ?I? for Inactive.
147) Name some of the Oracle receivables Interfaces
A a) Auto Invoice
b) Auto Lockbox
c) Customer Interface 47
d) Sales Tax rate Interface
e) Tax Vendor Extension
148) Give some of the Oracle Payables interface
A. a) Credit Card Transaction Interface
b) Invoice Import Interface
c) Payables Open Interface
d) Purchase Order Matching
149). Name some of the oracle general ledger Interface
A a) Budget Upload
b) Importing Journals
c) Loading Daily rates
150). What are the names of the parameters u pass to the Procedure which u register in the apps
A. 1) retcode in varchar2
2) errbuf in varchar2
151). What is the use of Auto lock Box
A Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.
No comments:
Post a Comment