5) Tell me what is the procedure to develop an interface?
a. First we will get the Requirement document.
b. We will create control file based on that plot file.
c. Then the control files which loads the data into staging tables.
Ra_customers_stg
Ra_customers_address_stg
Ra_customers_point_stg
Ra_customers_contact points_stg
Ra_customers_relate_stg
Ra_customer_error.
6) Tell me some mandatory columns in the customer interface tables?
a) Ra_customers_interface_all
1) Orig_system_customer_ref
2) insert_update_flag
3) customer_number
4) customer_status
5)last_updated_by
6) last_updated_date
7)created_by
8) creation_date.
b) Ra_customer_profile_int_all
1) customer_profile_class_name
c) Ra_contact_phones_int_all
1)orig_system_telephone_ref
2)telephone
3) telephone_type
d) Ra_customer_banks_int_all
1) bank_a/c_name
2)bank_a/c_no
3)bank_a/c_currency_code
e) Ra_cust_paymethod_int_all
1) payment_method_name
7) Tell me the Navigation for customer interface?
Receivables à Interface à Customers
a. Through pl/sql programs we will mapping and validate the data and then dump into the interface tables.
b. Through the standard programs we will push the data from interface tables to Base tables.
8) What validations u did in the customer interface?
a. customer name : the same customer reference can’t have different customer names with in this table
HZ_PARTIES.PARTY_NAME
b. customer number : must be null if your r using automatic customer numbering, must exit if you are not using automatic customer numbering. This value much be unique with in HZ_PARTIES
c. customer status : must be ‘A’ for active or ‘I’ for inactive
HZ_PARTIES_STATUS
d. bank account num or bank account currency code :
if the bank a/c already exist do not enter a value
if the bank a/c does not exist you must enter a value
e. bank a/c name : it must exist in AP_BANK_ACCOUNTS or if it does not exist values must exist for BANK_A/C_CURRENCY_CODE
BANK_A/C_NUM
BANK_NAME
BANK_BRANCH_NAME
Note : every interface table has two error msg
1) Error code.
2) Error msg.
9) How can u call a standard interface program from sql or pl/sql code?
FND_REQUEST.SUBMIT_REQUEST (‘PO’,’EXECUTABLE NAME’,,,,PARAMETERS)
10) API’s FOR CUSTOMER INTERFACE?
HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C
HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C
FND_PROFILES
FND_APPLICATIONS
FND_GLOBAL
FND-FILE
FND_CONCSUB(can submit conc program in host invironment)
11) Tell me some API?
FND_FILE.PUTLINE(FND_FILE.LOG)
FND_FILE.PUTLINE(FND_FILE.OUTPUT)
Is the Program exits, delete conc program and its executables.
IF FND_PROGRAM.PROGRAM_EXITS(‘EMP’,APPLICATION_NAME_IN) THEN
FND_PROGRAM.DELETE_PROGRAM(‘EMP’,APPLICATION_NAME_IN)
FND_PROGRAM.DELETE_EXECUTABLE(‘EMP’,APPLICATION_NAME_IN)
END;
12) What are profile options?
Is the Functional and Technical behavior of Oracle Applications Package.
EX: - I want to assign the user3 responsibility to p4 printer then
System Administrator àProfile àSystem
(FND_PROFILE_OPTIONS)
13) Oracle E-Business suite?
Oracle apps + analytical components software.
(Oracle discover)
(Oracle sales analyzer)
(Oracle financial analyzer)
(Oracle marketing analyzer)
24) What is multi org?
“Legal entity has more than one operating unit is called as multi org”
a) Business group --- Human resources information is secured by
Business group
b) Legal entity. --- inter-company and fiscal/tax reporting.
Security à responsibility à operating unit.
c) Operating unit --- secures AR, OE, AP, PA and PO Information.
d) Organizations --- is a specialize unit of work at particular locations
No comments:
Post a Comment