Oracle Apps Interview Questions-10

Oracle Apps Interview Questions,Askhareeshblogspot.com

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  




*/