Business Intelligence (BI) - ERP - Dashboards

STEPS REQUIRED TO CREATE A SIMPLE FLEX FIELD REPORT (continued to FLEX Field Reports )
1. Open the Report in Report Builder.
2. Create User defined parameters as per our requirement.

3. Call FND SRWINIT User Exit in Before Report Trigger.
BEGIN
SRW.USER_EXIT (’FND SRWINIT’);
RETURN (TRUE);
END;
4. Call FND SRWEXIT User Exit in After Report trigger.
BEGIN
SRW.USER_EXIT (’FND SRWEXIT’);
RETURN (TRUE);
END;
5. Call FND […]

1 Comment »
Filed under: AOL (Application Object Library ), DBA (DataBase Administrator), ERP, Forms, Interview Questions(& answers), Oracle Apps, PL/SQL, Reports, SQL

Development life cycle of a DW ( Data Warehouse ) project.
The DW project follows following different stages.
1. Requirement Gathering
2. Physical Environment Setup
3. Data Modeling
4. ETL
5. OLAP Cube Design
6. Front End Development (Reports )
7. Performance Tuning
8. Quality Assurance
9. Rollout To Production
10. Production Maintenance
11. Incremental Enhancements

google.load(”visualization”, […]

No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DBA (DataBase Administrator), DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps

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

Q: What is the maximum tablespace size?
A: The limitation is dependant on the limit the operating system places on
the filesize and the limitation of the number of datafiles the database
allows. For example some Unix boxes have a limit of 2 GIGA per Datafile,
then the largest file you can create for a tablespace on this operating […]

No Comments »
Filed under: DBA (DataBase Administrator), ERP, Interview Questions(& answers), Oracle Apps, PL/SQL, SQL

Each server and background process can write to an associated trace
file. When a process detects an internal error, it dumps information
about the error to its trace file. If an internal error occurs and
information is written to a trace file, the administrator should
contact Oracle support.
Each database also has an Alert log. The ALERT file of a […]

No Comments »
Filed under: DBA (DataBase Administrator), DataWarehousing, ERP, PL/SQL, SQL

SGA contains the following data Structures
* Database buffer cache
* Redo log buffer
* Shared pool
* Java pool
* Large pool (optional)
* Data dictionary cache
* Other miscellaneous information

Oracle9i can change its SGA configuration while the instance is running.
With the dynamic SGA infrastructure, the sizes of the buffer cache,
the shared pool, and the large pool can be changed without […]

No Comments »
Filed under: DBA (DataBase Administrator), ERP, PL/SQL, SQL