08/04/2013 Monday
1.WHAT IS THE DIFFERENCE BETWEEM APPS SCHEMA AND OTHER SCHEMAS?
ANS: APPS SCHEMA DOESN'T CONTAIN DATABASE OBJECTS, IT CONTAINS ONLY SYNONYMS AND THESE SCHEMA WILL HAVE THE RIGHTS TO ACCESS OTHER SCHEMA DATABASE OBJECTS.
2.WHAT IS MEANT BY CUSTOM TOP? WHATS THE PUPOSE?
ANS: CUSTOM TOP WILL BE CREATED OR DEVELOPED BY CLIENT FOR CUSTOMER DEVELOPMENT AND CUSTOMIZATION.
IF WE DONT HAVE CUSTOM TOP, WE CAN ALSO USE THE PRODUCT TOP FOR DEVELOPMENT AND CUSTOMIZATION.
EVERY CLIENT WILL HAVE ATLEAST ONE CUSTOM TOP OR MULTIPLE CUSTOM TOPS...
3.WHAT THE SIGNIFICANCE OF US FOLDER?
ANS: THIS IS LANGUAGE SPECIFIC FOLDER. WHEN WE ARE USING MULTIPLE LANGUAGES FOR THE CLIENT, WE WILL USE THIS US FOLDER.BY DEFAULT AMERICAN LANGUAGE. US FOLDER IS AVAILABLE ONLY FOR FORMS AND REPORTS, BECAUSE BOTH ARE GUI(GRAPHICAL USER INTERFACE)'S.
4.WHAT ARE THE FOLDERS WE WILL FIND BELOW 11.5.0 FOLDER?
ANS: AVAILABLE FOLDERS
ADMIN,BIN,FORMS,REPORTS,LOG,OUT,SQL........
5.CAN WE CREATE THE TABLES IN APPS SCHEMA?
ANS:
6.CAN WE HAVE CUSTOMS SCHEMA?WHEN IT REQUIRED?
ANS:
7.WHAT IS MEANT BY CONCURRENT PROGRAM?
ANS: THIS IS AN INSTANCE OF EXECUTION FILE ALONG WITH PARAMETERS AND INCOMPATABLE PROGRAMS.
WE CAN REGISTER 11 TYPES OF EXECUTABLE AS CONCURRENT PROGRAMS..
LIKE FORMS,REPORTS,PL/SQL STORED PROCEDURE,SQL *LODER,SQL *PLUS....
8.WHAT ARE THE STEPS WILL FOLLOW TO REGISTER REPORTS AS CONCURRENT PROGRAM?
ANS: 1)DEVELOP THE REPORT(.RDF) AS PER CLIENT REQUIREMENT BY USING REPORTS 6I BUILDER.
2)MOVE THE REPORT FROM LOCAL MACHINE INTO SERVER.
3)SELECT SYSTEM ADMINSTRATOR AND CREATE EXECUTABLE
4)CREATE CONCURRENT PROGRAM AND ATTACH
A)EXECUTABLE
B)PARAMETERS
C)INCOMPATIBILITIES
5)CREATE REQUEST GROUP AND ATTACH CONCURRENT PROGRAM
6)CREATE RESPONSIBILITY AND ATTACH REQUEST GROUP.
7)CREATE USER, ATTACH RESPONSIBILITY TO USER.
8)USER SELECT THE RESPONSIBILITY AND GOTO SRS WINDOW,SUBMIT THE REQUEST
9)WHAT IS MEANT BY REQUEST GROUP?
ANS: GROUPS OF CONCURRENT PROGRAMS..
10)WHAT IS USER EXIT?
ANS: THIS ONE OF BUILT-IN PROGRAM IN REPORT 6I, IT WILL BE USED TO TRANSFER THE REPORT BUILDER CONTROL TO SOME OTHER 3RD GENERATION LANGUAGE GET SOME INFORMATION COMPLETE THE REMAING EXECUTION PROCESS.
11)TYPES OF USER EXITS?
ANS: TYPES OF USER EXISTS ARE
FND SRWINIT
FND SRWEXIT
FND FLEXSQL
FND FLEXIDVAL
FND FORMATCURRENCY
12)WHAT ARE MANDITORY STEPS WE HAVE TO FOLLOW WHILE REGISTERING THE REPORT?
ANS: 1)DEVELOP THE REPORT(.RDF) AS PER CLIENT REQUIREMENT BY USING REPORTS 6I BUILDER.
2)MOVE THE REPORT FROM LOCAL MACHINE INTO SERVER.
3)SELECT SYSTEM ADMINSTRATOR AND CREATE EXECUTABLE
4)CREATE CONCURRENT PROGRAM AND ATTACH
A)EXECUTABLE
5)CREATE REQUEST GROUP AND ATTACH CONCURRENT PROGRAM
6)USER SELECT THE RESPONSIBILITY AND GOTO SRS WINDOW,SUBMIT THE REQUEST
13)HOW TO PRINT REQUEST_ID IN THE OUTPUT?
ANS: P_CONC_REQUEST_ID CAPTURES CONCURRENT PROGRAM REQUEST ID WHEN EVER WE SUBMIT AT SRS WINDOW.
14)WHAT IS MEANT BY RESPONSIBILITY?
ANS: THIS IS GROUP OF FORMS,CONCURRENT PROGRAMS,USERS. THIS IS USED FOR POSITION REQUIREMENTS.
15)WHAT ARE THE THINGS ARE MANDITORY AT THE TIME CREATING RESPONSIBILITY?
ANS: MANDITORY FIELDS ARE RESPONSIBILITY NAME,APPLICATION,RESPONSIBILITY KEY, DATA GROUP,REQUEST GROUP,MENU
16)WHAT IS MEANT BY DATA GROUP?
ANS: GROUPS OF USERS.
17)CAN WE DELETE THE RESPONSIBILITY?
ANS: NO WE CANN'T DELETE..WE CAN DISABLE AND ENABLE THE RESPONSIBILITY USING EFFECTIVE DATES(FROM AND TO)
18)WHAT IS ERRBUF AND RETCODE?
ANS: ERRBUF:THIS IS ONE OF THE OUT PARAMETER WILL BE USED TO GET ERROR MESSEGES INTO LOG FILE
RETCODE: THIS PARAMETER RETURNS STATUS OF CONCURRENT PROGRAM
'0' FOR NORMAL
'1' FOR WARNING AND '2' FOR ERROR.
19)HOW TO WRITE THE MESSEGE INTO THE OUT PUT FILE FROM PL/SQL PROCEDURE?
ANS:FND_FILE.PUT_LINE()
20)WHAT IS CONTROL FILE? SYNTAX?
ANS: IT IS SQL LOADER PROGRAM,WE WILL DEVELOP AND EXECUTE AT THE TIME OF DEVELOPMENT, WE WILL SPECIFY DATA FILE PATH, DATABASE ABLE NAME AND COLUMN MAPPING, WHEN WE EXECUTE THE CONTROL FILE FOLLOWING 3 FILES WILL BE CREATED AUTOMATICALLY.
3 FILES ARE 1. BAD FILE
DISCARD FILE
LOG FILE
EXTENSION OF CONTROL FILE IS .CTL.
SYNTAX: LOAD DATA
INFILE 'DATA FILE PATH'
INSERT INTO TABLE <DATABASE TABLE NAME>
FIELDS TERMINATED BY ',' (COLUMN1,COLUMN2....)
21)WHAT IS THE DIFFERENCE BETWEEN BAD FILE AND DISCARD FILE?
ANS: BAD FILE IT CONTAINS RECORDS WHICH ARE REJECTED BY THE SQL LOADER, SQL LOADER WILL REJECT RECORDS IF THERE IS ANY DATA TYPE ISMATCH OR ANY BAD FORMAT. EXTENSION OF BAD FILE IS .BAD
DISCARD FILE CONTAINS THE RECORDS WHICH ARE REJECTED BY CONTROL FILES, CONTROL FILE WILL REJECT THE RECORD IF IT CONTAINS ANY CONDITIONS. EXTENSION OF DISCARD FILE IS .DIS .
22)HOW TO ISSUE COMMIT IN CONTROL FILE?
ANS: WE CANN'T ISSUE THE COMMIT INSIDE OF THE CONTROL FILE, INSTEAD OF THAT WE WILL USE AUTO COMMIT BY USING 'ROWS COMMAND'.
IF WE SPECIFY ROWS=10 FOR EVERY 10 RECORDS COMMIT WILL BE EXECUTED.
23)HOW TO INSERT DATA INTO MULTIPLE TABLES AT A TIME?
ANS: WE ARE CREATING THE TWO OR MORE TABLES.
BASED ON THE POSITIONS WE HAVE TO WRITE THE PROGRAM.
24)HOW TO PASS THE PARAMETERS TO THE CONTROL FILE?
ANS: BY USING THE '&' EX: &1,&2.....UPTO 100. WE CANN'T SKIP THE SEQUENCE, WE CANN'T USE ANOTHER USER DEFINED PARAMETERS. SOME PARAMER VALUES WE CAN USE IN THE MULTIPLE LOCATIONS
25)WHAT IS THE VALUE SET? TYPES OF VALUE SETS?
ANS: LIST OF VALUES WITH VALIDATION WILL BE USED TO RESTRICT THE USER WITHOUT ENTERING INVALID VALUES.
THERE ARE 8 SET OF VALUES
NONE
INDEPENDENT
DEPENDENT
TABLE
TRANSLATED INDEPENDENT
TRANSLATED DEPENDENT
SPECIAL
PAIR
26)WHAT IS TOKEN?
ANS: CONCURRENT PROGRAM PARAMETERS MAPPING WITH REPORT BUILDER BIND VARIABLES
27)IS TOKEN IS REQUIRED FOR PROCEDURE PARAMETERS?
ANS: NOT REQUIRED. IT IS ONLY USED IN REPORT BUILDER BIND VARIABLES MAPPING. REPORT BUILDER BIND VARIABLE MAY OR MAYNOT BE IN SEQUENCE. WHERE AS IN PROCEDURE PARAMETERS WILL BE IN THE SEQUENCE ORDER, FIRST PARAMETER VALUE WILL BE PASSED TO THE FIRST VARIABLE...
28)CAN WE DEFINE PARAMETERS FOR LEXICAL PARAMETERS?
ANS:
29)WHAT ARE THE DEFAULT TYPES WE HAVE?
ANS: DEFAULT TYPES: CONSTANT,SQL STATEMENT,SEGMENT,CURRENT DATE, CURRENT TIME.
30)HOW TO MAKE THE PARAMETERS AS MANDITORY OR OPTIONAL?
ANS: WHEN WE ARE DEFINING THE PARAMETERS AT THE TIME WE HAVE TO CHECK THE CHECK BOX CALLED 'REQUIRED' FOR MANDITORY, OTHERWISE OPTIONAL.
31)HOW TO DISPLAY THE ONE COLUMN DATA TO THE USER AND PASSWORD OTHER COLUMN DATA INTERNALLY?
ANS:
32)HOW TO REGISTER PROGRAM FROM BACKEND?
ANS: FOR EXECUTABLE
BEGIN
FND_PROGRAM.EXECUTABLE('EXECUTABLE NAME','APPLICATION NAME','SHORT NAME','DESCRIPTION','EXECUTION METHOD','EXECUTION FILE NAME','','','US','');
COMMIT;
END;
33)HOW TO SUBMIT CONCURRENT PROGRAM FORM BACKEND?
ANS: DECLARE
L_REQUEST_ID NUMBER(8);
BEGIN
FND_GLOBAL.APPS_INITIALIZE(USER_ID,RESP_ID,RESP_APPL_ID);
L_REQUEST_ID:=FND_REQUEST.SUBMIT_REQUEST('APPLICATION NAME',
'CONCURRENT PROGRAM NAME'
'DESCRIPTION'
'STARTING TIME DEFAULT NULL',
'SUB REQUEST DEFAULT FALSE'
PARAMETER1,PARAMETER2......);
COMMIT;
IF L_REQUEST_ID!=0 THEN
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'PROGRAM SUCCESSFULLY COMPLETED');
ELSE
FND_FILE.PUT_LINE(FND_FILE.LOG,'PROGRAM NOT SUCCESSFULLY COMPLETED');
END IF;
EXCEPTION
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR OCCURED AT THE TIME OF SUBMISSION');
END;
34)DO U NEED TO ISSUE THE COMMIT STATEMENT AFTER CALLING CONCURRENT PROGRAM?
ANS:
35)WHAT ARE THE TYPES OF PO'S WE HAVE?
ANS: 1.BLANKET PUCHASE AGREEMENT
2.CONTRACT PURCHASE AGREEMENT
3.PLANNED PURCHASE ORDER
4.STANDARD PURCHASE ORDER
36)WHAT ARE THE MATCH APPROVALS WE HAVE?
ANS: AT THE TIME OF CREATING PURCHASE ORDER WE WILL SPECIFY THE MATCH APPROVAL AT SHIPPMENT LEVEL IN THE MORE TAB.
THE MATCH APPORVALS ARE:
2-WAY---PO, INVOICE
3-WAY---PO, RECEIPT,INVOICE
4-WAY---PO, RECEIPT,INSPECTION,INVOICE
37)WHERE THE ITEM NAME WILL BE STORED?
ANS: CREATED ITEM CAN BE AVAILABLE IN THE TABLE 'MTL_SYSTEM_ITEMS_B'.. ITEM NAME WILL BE STORED IN 'SEGMENT1' COLUMN.
38)WHAT ARE THE LEVELS WE HAVE IN PURCHASE ORDERS FORM?
ANS: THERE ARE 4 LEVELS
HEADERS
LINES
SHIPPMENTS
DISTRIBUTIONS
39)WHAT ARE THE PO MAIN TABLES? LIKE REQUISITION,RFQ,PO,RECEIPT,SUPPLIER TABLES?
ANS: PO MAIN TABLES ARE
PO_HEADERS_ALL
PO_VENDORS
PO_VENDOR_SITES_ALL
PO_VENDOR_CONTACTS
REQUISITION,RFQ,PO THESE ROWS WILL APPEARED IN 'SELECT TYPE_LOOKUP_CODE FROM PO_HEADERS_ALL'
SUPPLIERS WILL BE AVAILABLE IN 'SELECT VENDOR_NAME FROM PO_VENDORS'
RECEIPT WILL BE AVILABLE IN 'SELECT RECEIPT_NUM FROMRCV_SHIPMENT_HEADERS'
40)WHAT IS AUTO CREATE?
ANS: THIS IS ONE OF THE PURCHASING APPLICATION FEATURE WILL BE USED TO CREATE RFQ DOCUMENTS AUTOMATICALLY BASED ON REQUISATION NUMBER.
41)WHAT ARE THINGS WE HAVE TO SPECIFY IN TERMS AND CONDITIONS?
ANS: TERMS & CONDITIONS ARE
PAYMENT,FREIGHT,CARRIER,FOB(FOOT ON BOARD),PAY ON
42)WHAT IS THE DIFFERENCE BETWEEN STANDARD AND BLANKET PO?
ANS: STANDARD PURCHASE ORDER TYPE WILL BE CREATED FOR THE MOST OF THE ITEMS.
IT INCLUDES TERMS&CONDITIONS, ITEMS,PRICE AND QUANTITY...
BLANKET AGREEMENT CONTAINS TERMS& CONDITIONS AND GOODS PRICE MAY OR MAYNOT BE AVAILABLE AT THE TIME OF RELEASING THE AGREEMENT WE WILL SPECIFY THE QUANTITY & PRICE OTHER DETAILS.
43)WHERE THE BLANKET PO DATA WILL BE STORED?
ANS: EG: SELECT *FROM PO_HEADERS_ALL WHERE SEGMENT1=501
SELECT *FROM PO_HEADERS_ALL WHERE PO_HEADER_ID=61
44)HOW TO FIND THE PO DETAILS, IF WE GIVE THE REQUISITION NUMBER?
ANS:
45)HOW TO FIND THE RECEIPT NUMBER, WE GIVE PO NUMBER?
ANS: SELECT RECEIPT_NUM
FROM RCV_SHIPMENT_HEADERS
WHERE SHIPMENT_HEADER_ID
IN
(SELECT SHIPMENT_HEADER_ID
FROM RCV_SHIPMENT_LINES
WHERE PO_HEADER_ID
IN
(SELECT PO_HEADER_ID
FROM PO_HEADERS_ALL
WHERE SEGMENT1='3482'))
46)WHAT ARE THE RECEIPT TABLES AND AS WELL AS RECEIPT TYPES?
ANS: RECEIPT TABLES ARE
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS
47)IN THE SAME TABLE RFQ,QUOTATIONS,PO DATA WILL BE STORED.THEN HOW TO IDENTIFY THE INFORMATION WETHER IT IS RFQ DATA OR QUOTAION DATA OR PO DATA?
ANS: WE HAVE TO FIND THE ABOVE DATA THROUGH 'TYPE_LOOKUP_CODE' COLUMN IN PO_HEADERS_ALL TABLE.
48)WHAT IS THE FLOW OF ORACLE PURCHASING APPLICATION?
ANS:
49)IS ITEM FIELD IS MANDITORY IN PO FORM?
ANS: MANDITARY...WITH OUT ITEM NAME WE WILL NOT SPECIFY THE CATEGORY...
50)WHERE SHIPTO BILL TO DATA WILL BE STORED?
ANS: HR_LOCATIONS
51)WHY WHILE CREATION OF EXECUTABLE,WE ARE GIVEN THE APPLICATION NAME AND ALSO AT THE TIME OF CREATING THE CONCURRENT PROGRAM, WE ARE GIVING APPLICATION NAME, WHAT IS THE DIFFERENCE BETWEEN THESE TWO?
ANS: AT THE TIME OF CREATING CONCURRENT PROGRAM, WE HAVE COPY THE EXECUTABLE FILE INTO THE APPLICATION TOP LIKE PO,INV. THATS WHY WE HAVE TO GIVE APPLICATION NAME IN EXECUTABLE,CONCURRENT PROGRAM CREATION.
If this notes is useful for any one please submit your comments
thank you
thank you
DILLI
No comments:
Post a Comment