Posted on June 30th, 2008 by Kamlesh Jethwa
Interview Questions - Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS
1.What are the Key Flex Fields in Oracle Receivables? Sales tax Flexfields
Territory Flexfields
2.What is the Payment Term in AR?
How You are going to Receive the Amount from Customers […]
1 Comment »
Filed under: 11i, ERP, Interfaces, Interview Questions(& answers), Oracle Apps
Posted on June 23rd, 2008 by Kamlesh Jethwa
USER EXITS: USER EXITS are the 3rd party programs (i.e. java,Pro*c, etc.) that we can link with our reports to perform a particular task.
We can link 3rd party programs with our reports with SRW.USER_EXIT ( Name_of_the_User_Exit)’. We can reference the input parameters in user exist with SRW.REFERENCE( input_parameters).
FND SRWINIT: This User Exit is used to […]
No Comments »
Filed under: AOL (Application Object Library ), ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, Reports, SQL
Posted on June 8th, 2008 by Kamlesh Jethwa
OPEN INTERFACE LOGIC
The data from source application is loaded into a database table (called Interface Table).
The provided program logic validates the records.
Any errors are transferred into another table (called Error Table).
The correct records are then transferred through a process into destination application table.
INTERFACE COMPONENTS
Picture not available
Source Application· You obtain data from a source application to […]
2 Comments »
Filed under: ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, SQL
Posted on June 8th, 2008 by Kamlesh Jethwa
INTERFACES
Interfaces are used to integrate external systems and data conversion in Oracle Applications.
These can be used to either transfer data from Oracle Applications to a flat file or data from legacy system to Oracle Applications.
Used extensively at the time of data conversion from legacy/old systems to a fresh implementation of Oracle Applications.
Used also at regular […]
2 Comments »
Filed under: AOL (Application Object Library ), ERP, Interfaces, Oracle Apps, PL/SQL, SQL
Posted on June 8th, 2008 by Kamlesh Jethwa
Here the sample code of Interface program is presented for training purpose only.
DAILY RATES INTERFACE (ORACLE GENERAL LEDGER)
USING UTL_FILE PACKAGE
DECLARE
FP UTL_FILE.FILE_TYPE;
FROM_CURR VARCHAR2(15);
TO_CURR VARCHAR2(15);
FROM_CON_DATE DATE;
TO_CONV_DATE DATE;
USER_CON_TYPE VARCHAR2(30);
CONV_RATE NUMBER;
MODE_FLG VARCHAR2(1);
MY_LINE VARCHAR2(150);
BEGIN
FP:=UTL_FILE.FOPEN(’D:\ORACLE\PRODDB\9.2.0\PLSQL\TEMP’,'dailyrates.dat’,'R’);
UTL_FILE.GET_LINE(FP,MY_LINE);
LOOP
UTL_FILE.GET_LINE(FP,MY_LINE);
FROM_CURR:=SUBSTR(MY_LINE,1,3);
TO_CURR:=SUBSTR(MY_LINE,6,3);
FROM_CON_DATE:=SUBSTR(MY_LINE,10,11);
TO_CONV_DATE:=RTRIM(SUBSTR(MY_LINE,24,11));
USER_CON_TYPE:=RTRIM(SUBSTR(MY_LINE,36,9));
CONV_RATE:=TO_NUMBER(RTRIM(SUBSTR(MY_LINE,50,2)));
MODE_FLG:=SUBSTR(MY_LINE,59,1);
DBMS_OUTPUT.PUT_LINE(FROM_CURR||’ ‘||TO_CURR||’ ‘ ||FROM_CON_DATE||’ ‘||TO_CONV_DATE||’ ‘||
USER_CON_TYPE||’ ‘||CONV_RATE||’ ‘||MODE_FLG);
INSERT INTO GL.GL_DAILY_RATES_INTERFACE(FROM_CURRENCY,TO_CURRENCY,FROM_CONVERSION_DATE,TO_CONVERSION_DATE,USER_CONVERSION_TYPE,CONVERSION_RATE,MODE_FLAG)
VALUES(FROM_CURR,TO_CURR,FROM_CON_DATE,TO_CONV_DATE,USER_CON_TYPE,CONV_RATE,MODE_FLG);
DBMS_OUTPUT.PUT_LINE(’One row successfully inserted’);
COMMIT;
END LOOP;
UTL_FILE.FCLOSE(FP);
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
END;
dailyrates.dat /* This file should be placed in D:\ORACLE\PRODDB\9.2.0\PLSQL\TEMP */
FROM TO FROM_CON_DATE […]
2 Comments »
Filed under: DBA (DataBase Administrator), ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, SQL