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
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 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 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
Performance Tuning
The Performance tuning of 3 areas to look for are as below. These tasks can easily take around a week.
1) ETL - Since Loading data is very time consuming ,its best to put that activity in a night load job.The ETL process needs to be tuned more and more as possible,since some problems are […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP
Posted on June 16th, 2008 by admin
Physical Environment Setup
After the Requirements are gathered, its necessary to set physical Envioronment by installing database and maintaining the Physical servers.The usual set of servers include 3 sets of instances.
Development servers: where the developers work on the database and roll it for testing.
Testing Servers: the objects developed by the developers are tested on this server […]
2 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Hardware
Posted on June 16th, 2008 by admin
Data Modeling
Data modeling is the process of identifying the data sources.Its observed that many a times this step is often delayed.
The data identification step is important and is better to be done by an experienced person and in this phase, else it might become tough to solve it in the later stages,until the ETL process.It […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Software
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
Posted on June 12th, 2008 by admin
In last couple of years, IT and Internet open the new door not only to IT Finance Managers but also Corporate Treasurers .The role of treasurers is more demanded and expectation with their banking partner have been greatly increased Changing Banking Relationships, Single Bank Model ,globalization , SWIFT corporate access and XML and end to […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
Read this
Managing Cash , EBS and SWIFT
Whenever the Bank Intergation is required , the very first term would come in mind is SWIFT , a very similar way as EDI sort of messaging servics that Financial sectors are using .So let explore what is SWIFT and how many of these can be potenially targetted for […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12