Oracle Apps Interview Questions-10

136. Describe the OPERATOR option of the FND FLEXSQL user exit?
Specify an operator to use in the WHERE clause.

137. Describe the OPERAND1 option of the FND FLEXSQL user exit?
Specify an operand to use in the WHERE clause

138. Describe the OPERAND2 option of the FND FLEXSQL user exit?
Specify a second operand to use with OPERATOR = “BETWEEN”

139. Where is FND FLEXIDVAL user exit used?
 Call this user exit to populate fields for display. You pass the key flex fields data retrieved by the query into this user exit from the formula column. With this exit you can display values, descriptions and prompts by passing appropriate token (any one of VALUE, DECRIPTION<APROMPT or LPROMPT).

140) Name the interface tables used for the customer interface?

• RA_CUSTOMERS_INTERFACE_ALL
• RA_CUSTOMER_BANKS_INT_ALL
• RA_CUST_PAY_METHOD_INT_ALL
• RA_CUSTOMER_PROFILES_INT_ALL
• RA_CONTACT_PHONES_INT_ALL

141) What is the name of the column in CUSTOMER_INTERFACE_TABLE that indicates whether you are inserting new or updating existing information?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.

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?Reject the entire record.

143) List some of the required columns for the RA_CUSTOMERS_INTERFACE?

• 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?

• 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?
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?
Must equal ‟A‟ for Active or ‟I‟ for Inactive.

147) Name some of the Oracle receivables Interfaces?

•  Auto Invoice
•  Auto Lockbox
•  Customer Interface 47
•  Sales Tax rate Interface
•  Tax Vendor Extension

148) Give some of the Oracle Payables interface?

• Credit Card Transaction Interface
• Invoice Import Interface
• Payables Open Interface
• Purchase Order Matching

149). Name some of the oracle general ledger Interface?

• Budget Upload
• Importing Journals
• Loading Daily rates

150). What are the names of the parameters u pass to the Procedure which u register in the apps?

retcode in varchar2
errbuf in varchar2  

<<<Previous     Continue>>>