Posted on July 11th, 2008 by admin
Data Conversion for Oracle Applications
This topic is shared to provide an overview of Data Conversion for Oracle ERP.
Approach used for Data Conversion
1. Conversion Data Mapping ( map to specify the data of legacy system –> data of oracle ERP system )The data mapping process provides detailed lists of the data sets and data elements that […]
2 Comments »
Filed under: ERP, Interview Questions(& answers), Oracle Apps
Posted on July 3rd, 2008 by admin
ERP tables - WF (Work Flow)
brief ( and important ) details of WorkFlow tables.
lets first learn some definations.
A process activity is a modelled workflow process, which can be included as an activity in
other processes to represent a sub–process.
A notification activity sends a message to a performer.
A functions activity performs an automated function that is […]
No Comments »
Filed under: 11i, ERP, Glossary, Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
AIM (Application Implementation Method )
Every Oracle apps consultant will be and should be aware of the documents related to his/her work profile depending if they are Functional or Technical consultant.
Business Process Architecture (BP)
BP.010 Define Business and Process Strategy
BP.020 Catalog and Analyze Potential Changes
BP.030 Determine Data Gathering Requirements
BP.040 Develop Current Process Model
BP.050 Review Leading Practices
BP.060 Develop […]
No Comments »
Filed under: AOL (Application Object Library ), ERP, Interview Questions(& answers)
Posted on June 30th, 2008 by admin
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 […]
No Comments »
Filed under: Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
Interview Questions - Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS
Continued from http://www.infopurple.com/interview-questions-oracle-ar-functional-accounts-receivables-01
11.What are the Quick-codes in Oracle Receivables? Describe? Freight Carriers, Demand Class, Customer Category, Customer Class
12.How will you send the Information about Invoices? Describe the Frequency?Through Statement Cycles, The Interval between dates like Weekly, Monthly, Quarterly
13.What is used to notify customers […]
1 Comment »
Filed under: ERP, Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
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 26th, 2008 by admin
Life cycle of a DW ( Data Warehouse ) project
After many requests ,I am compiling everything in one page for easy page navigation and easy learning.hope you like it.
1 )Requirement Gathering
Requirements Gathering is started by directly discussing or with JAD sessions (Joint Application Development) with the End users .The help of Business leader or Business […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps, Reports, SQL
Posted on June 23rd, 2008 by admin
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
Posted on June 23rd, 2008 by admin
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 20th, 2008 by admin
create JAVA_HOME quickly with following steps on Windows XP (Home Basic)
The goal is to create a new variable called JAVA_HOME in Windows Operating system,so get access to System Properties window and create new variable called ‘JAVA_HOME’ and insert value where your BIN folder of JDK within your system.
more detailed steps as below.
1)Right Click on “computer”
2)Select […]
1 Comment »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Oracle Apps, Software
Posted on June 17th, 2008 by admin
How to find a column in database
Once, at a client site I was asked to do a drill through report from Purchasing to Fixed Assets. I don’t remember the exact details but it had something to do with Purchase orders. I knew little bit about Oracle Purchasing but had not worked enough on Fixed Assets. […]
1 Comment »
Filed under: 11i, Business Intelligence, DataWarehousing, Discoverer, ERP, Oracle Apps, PL/SQL, SQL
Posted on June 16th, 2008 by admin
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
Posted on June 16th, 2008 by admin
Rollout To Production
After the QA team completes the testing ,they will give thumbs up(signoff document) to go to Production servers. It will take less then a week to go to live once everything is tested and approved.
Deliverables
· Delivery of the data warehousing system to the end users.
Next >> Production Maintenance
[…]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
Front End Development of Reports
In this phase of DW project if the reports are not bringing any value to the end user or executive, then the efforts to build the OLAP cube is wasted. so its very important to think about the end reports and timely delivery of reports to the end user. It is […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), Oracle Apps, Reports
Posted on June 16th, 2008 by admin
what is OLAP Cube Design ?
OLAP databases provide aggregated summary information quickly using a schema that is easily understood by end users.
In the OLAP design it is not required to join tables together the way it is done in relational database. It contains all the relationships required to enable a specific sets of queries for […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps
Posted on June 12th, 2008 by admin
What two program responsible for creating events in R12 CM
They are
bank account transfers
bank statement cash flows
Once events created and the accounting program is run, the journal entry setup and the accounting configurations are referenced to produce journal entries. The journal entries are then transferred to GL which had visibility upto source transactions. This way […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
We already aware for changes for new Bank Account Model feature of R12.
Lets investigate how bank model drive some changes in Bank statement Reconciliation.
1….R12, Bank Transaction Codes is linked to multiple sources.
In 11i each bank transaction code had to be linked to a single source, such as Accounts Payable. This could create an issue if […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
This is not Oracle acquisition news, rather yet another Big news this morning locally in Singapore for partnership with global bank Citibank Japan and Oracle for enhancing the Oracle Global Cash Management System,that provide a integrated solution for managing Cash Management for global manufacturing operations, retail, transportation, financial services sector of Japanese clients.
“Oracle Global Cash […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
One of reader from Mid-east region asked one question “does Oracle support XML based Bank statement?”
It was/is really a new area , just brought attention this afternoon and I did manage to run through Oracle user guide as well as some of the release note of 11i Financial Family pack D(ce minipack H).
What I understood […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
Companies to Banking partner connectivity and online information exchange has long been an issue for many reasons for so many years. Driven by tighter regulation and the need for better cash management and effective working capital management prompt Treasures to explore more areas so that they can get better insight into their cash positions and […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12