Dashboards, Reporting & Business Intelligence

Database Normalization and Table structures

Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database.
There are 3 or 4 major steps involved known as
1NF (First Normal Form),
2NF (Second Normal Form),
3NF (Third Normal Form) and
BCNF (Boyce-Codd Normal Form).
There are others but they are […]

http://www.infopurple.com/database-normalization-and-table-structures

Interview Questions – Oracle AR (Functional) -Accounts Receivables 03

Interview Questions – Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS

some of the questions and answers listed here might repeat .from
http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-02
http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-01
1. How do you create a Chargeback Invoice ?
A. Using Receipts window
2. How do you adjust the amount of advance already received against an Invoice ?A. Create an Invoice for Deposit and receive an […]

http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-03

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 […]

create-flex-field-report