| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| A: | An abstract class can have instance methods that implement a default behavior. An Interface can only declare constants and instance methods, but cannot implement default behavior and all methods are implicitly abstract. An interface has all public members and no implementation. An abstract class is a class which may have the usual flavors of class members (private, protected, etc.), but has some abstract methods. . | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Q: | What are pass by reference and passby value? |
| A: | Pass By Reference means the passing the address itself rather than passing the value. Passby Value means passing a copy of the value to be passed. |
| Q: | What is HashMap and Map? |
| A: | Map is Interface and Hashmap is class that implements that. |
| Q: | Difference between Vector and ArrayList? |
| A: | Vector is synchronized whereas arraylist is not. |
| Q: | Difference between Swing and Awt? |
| A: | AWT are heavy-weight componenets. Swings are light-weight components. Hence swing works faster than AWT. |
SAP FI FAQs
1. There is "company" field in the Company Code global settings. The R/3 help says that it is being used for consolidation. We can use Group Chart of account to do the same.
What is the significance of this field?
What is different between company & company code?
2. When we copy the COA, only one Fin Stat Version is being copied. A COA can have many Fin Stat Version. Why copying of COA allows only one Fin St Ver?
3. What are the information that are not copied to new company code when we copy company code?
4. Whether one group chart of account can be assigned to 2 Operational charts. For Eg. INTA and INTB is being used by group of company as OCA. Whether GCA GRP can be assigned to INTA and INTB?
1A). Company is an organizational unit which is generally used in the legal consolidation to roll up financial statements of several company codes. A company can include one or more company codes. If we are going for Consolidation , we need to enter the 6 character alphanumeric company identifier that relates to this company code.
Company Codes within a Company must use the same chart of accounts and fiscal year. And for consolidation purpose we use Group COA wherein we link the Operating COA thru entering the GL account no. of the Group COA in the GL Account of the Operating COA.
2A). A financial statement version corresponds to the chart of accounts and wherein Individual (operational) accounts are assigned to the corresponding FS item on the lowest level of this version. But as for the rollup of Accounts is not possible in all the FSV which can be copied, n rather can update manually n create multiple FSVs if necessary depending on the Financial Statements which are necessary for the Organisation.
3A). All the Organizational units (Global Data) for a company code will b copied to new company code upon using the copy function except for the transactional data.
4A). Yes, Group COA can be assigned i.e., the GL A/c.No. is linked to the GL Accounts of the both Operating COA . That means Group COA consists of Unique set of Accounts which can be linked to Op.COA –1 and Op.COA –2.
SAP FI/CO Tips by:kondammagari mallikarjun reddy, kasanur
Ans: Q.No.1. In the SAP system, consolidation functions in financial accounting are based on companies. A company can comprise one or more company codes. for example: Company A have 4 company codes which is existing in different state and / or country. When Company A wants to consolidated the accounts, it will give the common list of accounts which in turn called group chart of accounts. Group chart of account is used to define/ list the GL account uniformly for all company codes.
Ans: Q.No.2. In SAP R/3 system, will allow only one financial statement version for single COA which you need to assign the same while copying the COA. T.code OBY7
Ans: Q.No.3. When you want to create FYV, PPV, COA etc for new company code which is as same as existing company code, then you can copy all the information from the source company code to the target company else whatever is required as per the new company code requirement you can only copy the same, rest you can create as per the requirement. for example Fiscal year for new company code may be shortented fiscal year which is differ from the existing company code. In this case, fiscal year for new company code you have to create and assign it to company code.
Ans: Q.No.4. Operational chart of accounts is something differ from the Group chart of accounts but Group chart of account can be assigned to Operating chart of account 1 and 2 through GL account no.
Operating chart of accounts: The operating chart of accounts contains the GL accounts that you use for posting in your company code during daily activities. Financial accounting and controlling both use this chart of accounts. You have to assign an operating chart of account to a company code.
Group chart of accounts: The group chart of accounts contains the GL accounts that are used by the entire corporate group. This allows the company to provide reports for the entire corporate group.
What is the significance of this field?
What is different between company & company code?
2. When we copy the COA, only one Fin Stat Version is being copied. A COA can have many Fin Stat Version. Why copying of COA allows only one Fin St Ver?
3. What are the information that are not copied to new company code when we copy company code?
4. Whether one group chart of account can be assigned to 2 Operational charts. For Eg. INTA and INTB is being used by group of company as OCA. Whether GCA GRP can be assigned to INTA and INTB?
1A). Company is an organizational unit which is generally used in the legal consolidation to roll up financial statements of several company codes. A company can include one or more company codes. If we are going for Consolidation , we need to enter the 6 character alphanumeric company identifier that relates to this company code.
Company Codes within a Company must use the same chart of accounts and fiscal year. And for consolidation purpose we use Group COA wherein we link the Operating COA thru entering the GL account no. of the Group COA in the GL Account of the Operating COA.
2A). A financial statement version corresponds to the chart of accounts and wherein Individual (operational) accounts are assigned to the corresponding FS item on the lowest level of this version. But as for the rollup of Accounts is not possible in all the FSV which can be copied, n rather can update manually n create multiple FSVs if necessary depending on the Financial Statements which are necessary for the Organisation.
3A). All the Organizational units (Global Data) for a company code will b copied to new company code upon using the copy function except for the transactional data.
4A). Yes, Group COA can be assigned i.e., the GL A/c.No. is linked to the GL Accounts of the both Operating COA . That means Group COA consists of Unique set of Accounts which can be linked to Op.COA –1 and Op.COA –2.
SAP FI/CO Tips by:kondammagari mallikarjun reddy, kasanur
Ans: Q.No.1. In the SAP system, consolidation functions in financial accounting are based on companies. A company can comprise one or more company codes. for example: Company A have 4 company codes which is existing in different state and / or country. When Company A wants to consolidated the accounts, it will give the common list of accounts which in turn called group chart of accounts. Group chart of account is used to define/ list the GL account uniformly for all company codes.
Ans: Q.No.2. In SAP R/3 system, will allow only one financial statement version for single COA which you need to assign the same while copying the COA. T.code OBY7
Ans: Q.No.3. When you want to create FYV, PPV, COA etc for new company code which is as same as existing company code, then you can copy all the information from the source company code to the target company else whatever is required as per the new company code requirement you can only copy the same, rest you can create as per the requirement. for example Fiscal year for new company code may be shortented fiscal year which is differ from the existing company code. In this case, fiscal year for new company code you have to create and assign it to company code.
Ans: Q.No.4. Operational chart of accounts is something differ from the Group chart of accounts but Group chart of account can be assigned to Operating chart of account 1 and 2 through GL account no.
Operating chart of accounts: The operating chart of accounts contains the GL accounts that you use for posting in your company code during daily activities. Financial accounting and controlling both use this chart of accounts. You have to assign an operating chart of account to a company code.
Group chart of accounts: The group chart of accounts contains the GL accounts that are used by the entire corporate group. This allows the company to provide reports for the entire corporate group.
SAP BO Interview Questions
Business Objects Enterprise Certified
Professional XI Level Two Certification
Exam: Sane 301
Edition: 2.0
CERT MAGIC
1. What are the major components of Business Objects?
Business Objects is composed of various components that are
accessible through the Web or reside on your desktop computer. The
major components are InfoView, WebIntelligence, and Business
Objects Editor.
2. Define “the Universe” in context of Business Objects?
A universe is a database interface, which maps everyday business terms
to the data in a database. The universe simplifies the process of
creating reports by providing an easy way see and understand the
data. It also provides automatic joins between database tables based
on key values.
Universes consist of classes and objects. Objects represent fields in a
database table. An object’s name may have been changed from the
original EDW Oracle column name in order to make the object’s name
more meaningful to the user. Classes are logical groupings of objects.
For example, all address fields might be grouped together in one
class.
3. How many and what are the different types of business object types ?
There are three different types of objects:
•
Dimension•
Detail•
4. Explain Dimension Objects
Dimension objects are typically character-type data, such as Name,
City, UIN, and dates. Dimension objects usually will not contain
numeric data that can be used in calculations.
5. What is a Detail Object?
A detail object is always associated with a dimension object.
A detail object provides additional information about the dimension
object. For example, Telephone Type Description could be a detail
object associated with a dimension object called Telephone Type Code
6. Does universe require Detail objects?
Detail objects are not required in a universe. They are used as a way
to organize the data within the universe.
7. What are Measure Objects?
Measure2
Measure objects are numeric data that are the result of calculations.
Measure objects are used to provide dynamic numerical information in
query. A measure’s value will change depending on the context. For
example, the value of salary will be different when calculated for one
pay period or for one year.
8. What are the types of user rights Business Object users have? Each
Business Objects user is assigned certain rights by Decision
Support. The rights assigned to each user define the user’s profile
which define access to:
•
document lists•
document editors•
universes for creating and editing queries•
saving documents on the server•
sending documents to other users•
9. What do you understand regarding Enterprise XI Framework?
Enterprise XI provides a framework for information delivery. The
information can be in any form, from any place on the intranet or
Internet, without causing compatibility problems. The Enterprise XI
Framework has an open architecture that supports any kind of
information entity. In Enterprise XI, information entities are called
InfoObjects and are stored in the Central Management Server (CMS)
memory space, also known as the Infostore.
The Enterprise Framework is intended to be seamless to the Enterprise
XI administrator. In the Central Configuration Manager (CCM), the
CMS has an option in its properties to determine a port number. This
port information will set the listening port of the CMS service and
affect how the servers talk to one another.
10.What do you understand regarding eBusiness Framework?
The eBusiness Framework is an open framework that enables various
components to plug in to Enterprise XI framework.
11. What are the major components of Business objects Enterprise
Framework?
database connections•
XI)
Crystal Reports (opening or saving reports from/to Enterprise•
XI)
OLAP Intelligence (opening or saving reports from/to Enterprise3
•
Publishing Wizard (adding reports to Enterprise XI)•
versions of Enterprise XI)
Import Wizard (importing objects from previous and current•
from/to the System database)
Business View Manager (opening or saving Business Views•
Universe Designer (exporting universes to Enterprise XI)•
12. What are the various end to end Business object enterprise processing
tiers?
In Enterprise XI, there are five tiers:
CCM (enabling or disabling servers)•
The Client Tier•
The Application Tier•
The Intelligence Tier•
The Processing Tier•
13. Illustrate how the various enterprise components fits within the multitier
system?
The following diagram illustrates how each of the components fits
within the multi-tier system.
The Data Tier4
14. The various components showed in the above diagram can be
installed on one machine only or is it necessary to be installed in
different machines?
To provide flexibility, the components that make up each of these tiers
can be installed on one machine, or spread across many. Each tier is a
layer of the system that is responsible for a role in the overall
architecture. There are many servers involved in this architecture. Some
of these servers are only responsible for doing work, others only
responsible for managing the servers doing the work.
The services can be vertically scaled to take full advantage of the
hardware that they are running on, and they can be horizontally scaled
to take advantage of multiple computers over a network environment.
This means that the services can all run on the same machine, or they
can run on separate machines. The same service can also run in multiple
instances on a single machine.
15. Describe the client tier of the Business Objects enterprise system?
The client tier is the only part of the Enterprise XI system that
administrators and end users interact with directly. This tier is made
up of the applications that enable users to administer, publish, and
view reports and other objects.
16. What is the CMC of enterprise system?
Central Management Console
The Central Management Console (CMC) allows you to perform user
management tasks such as setting up authentication and adding users
and groups. It also allows you to publish, organize, and set security
levels for all of your Enterprise XI content.
Additionally, the CMC enables you to manage servers, create server
groups, monitor system metrics and control authentication and
licensing.
Because the CMC is a web-based application, you can perform all of
these administrative tasks remotely. The CMC also serves as a
demonstration of the ways in which you can use the administrative
objects and libraries in the Enterprise XI SDK to create custom web
applications for administering Enterprise XI
17. Explain “InfoView” of the Business Objects enterprise system?
InfoView
Enterprise XI comes with InfoView, a web-based interface that users
access to view, export, print, schedule and track published reports.
5
InfoView is the main user interface for working with reports through
Enterprise XI.
The web client (InfoView) makes a request to the web server, which
forwards the user request directly to an application server (on the
application tier) where the request is processed by components built on
the Enterprise XI Software Development Kit (SDK) – either Java or
.NET.
18. Can the Infoview of enterprise system be customized?
Recognized users of Enterprise XI can customize a personalized version
of InfoView. It also serves as a demonstration of the ways to use the
Enterprise XI SDK to create a custom web application for end users.
19. Shall the enterprise system supports viewing, printing, exporting
reports without installing crystal reports on the local machine?
Yes. Enterprise XI supports the viewing, printing, and exporting of
reports without the need for installing Crystal Reports on the local
machine. Report viewing is supported through different viewers
compatible with the features of ActiveX, Java, and DHTML.
20. What is the component that allows creating dashboards in the
Business Objects enterprise system?
Dashboard Manager, which provides the functionality to create
dashboards, can be accessed from InfoView. A dashboard contains
user-defined settings and can include web sites and objects, such as
reports or documents. One or more dashboards can be created and
displayed as needed.
For example, you can create a dashboard that contains web sites,
Crystal reports or Web Intelligence documents that you frequently
access. To view the dashboard, you can either make the dashboard your
default view, or you can click its link in the navigation panel. The default
name for a dashboard is My InfoView, and its default location is your
Favorites folder.
21. Describe the CCM the Business Objects enterprise system?
CCM stands for Central Configuration Manager,
6
The CCM is a server-management tool that allows you to configure
each of your Enterprise XI server components. This tool can start,
stop, enable, and disable servers. It allows you to view and to
configure advanced server settings. On Windows, these settings
include default port numbers, CMS database and clustering details,
SOCKS server connections and more. On Windows, the CCM allows
you to add or remove servers from your Enterprise XI system. On
UNIX, some of these functions are performed using scripts and other
tools.
22. How can the reports be added to the enterprise system by users and
administrators?
The reports can be added using the Publishing Wizard The Publishing
Wizard is a locally-installed Windows application that enables both
administrators and users to add reports to Enterprise XI. By assigning
object rights to Enterprise XI folders, you control who can publish
reports and where they can publish them.
The Publishing Wizard publishes reports from a Windows machine to
Enterprise XI servers running on Windows or UNIX.
23. How will the users, groups, reports be imported from an existing
Enterprise XI implementation?
The Import Wizard is a locally-installed Windows application that guides
administrators through the process of importing users, groups, reports,
and folders from an existing Enterprise XI implementation. The Import
Wizard runs on Windows, but you can use it to import
information into a new Enterprise XI system running on Windows or on
UNIX.
24. What is the Application Tier of Business Objects enterprise system?
Application Tier
The application tier hosts the server-side components that are needed
to process requests from the client tier as well as the components that
are needed to communicate these requests to the appropriate server in
the intelligence tier. The application tier includes support for report
viewing and logic to understand and direct web requests to the
appropriate Enterprise XI server in the intelligence tier. The
components included in your application tier will vary because
Enterprise XI is designed to support a variety of web development
platforms.
25. Does Business Objects enterprise framework supports integration with
J2EE and .NET services?
7
Yes. Business objects enterprise system supports integration with Java
and Microsoft bases platforms.
26. Explain how the integration can be done using Enterprise framework
for J2EE and .NET platforms?
Enterprise XI provides integration with Java and Microsoft-based
platforms through native J2EE, Microsoft .NET, and Web Services
SDKs.
These kits are made up of robust components, sample applications, and
documentation. Developers install these components on web application
platforms including BEA WebLogic, IBM WebSphere, Apache, Oracle 10g
Application Server, Sun One, or Microsoft IIS. The SDKs provide a highlevel
API to control every aspect of Enterprise XI using the developer
language of choice.
27. What is the role of the application tier in the Business Objects
enterprise framework?
The application tier acts as the translation layer between the user and
the Business Intelligence (BI) platform. The components process
requests from the users in the client tier and then communicate these
requests to the appropriate service in the intelligence tier. The
application tier includes support for document viewing, scheduling, and
logic to understand and direct web requests to the appropriate
Enterprise XI component.
28. What are the components the enterprise system uses to run the
system with a third-party applications server?
Enterprise XI systems use the Java SDK or the .NET SDK to run the
system with a third-party application server. The application server
acts as the gateway between the web server and the rest of the
Enterprise XI components. The application server is responsible for
processing requests from your browser, sending certain requests to
the Web Component Adapter (WCA), and using the SDK to interpret
components in Java Server Pages (JSP) or in Active Server pages
(ASP).
29. Does enterprise framework supports Crystal Server Pages inaddition
to JSP and ASP?
Enterprise XI continues to support Crystal Server Pages (CSP) for
legacy system support. However, developers are encouraged to use
industry standard JSP and ASP whenever possible when building web
applications.
8
30. Explain the Business Objects enterprise system integration for Java
Platform?
Enterprise XI systems that use the Enterprise XI Java SDK run the
SDK on a third-party web application server such as Apache TomCat or
WebSphere. The web application server acts as the gateway between
the web server and the rest of the components in Enterprise XI. The web
application server is responsible for processing requests from your
browser, through the WCA, and using the Java SDK to interpret
components in JSP files. The web application server also supports Java
versions of the Enterprise XI InfoView, other Enterprise XI applications
and uses the SDK to convert report pages (.epf files) to HTML format
when users view pages with a DHTML viewer.
31. Explain the Business Objects enterprise system integration for
Windows .NET Platform?
Enterprise XI installations that use the .NET Framework include
Primary Interop Assemblies (PIAs) that allow you to use the COM
Enterprise XI SDK with ASP.NET. Enterprise XI also includes a set of
.NET Server Components that you can optionally use to simplify the
development of custom applications. This configuration requires the
use of a Microsoft IIS web server.
A Web Connector, Web Component Server (WCS), or a WCA is not
needed for custom ASP.NET applications.
32. Explain the Business Objects enterprise system integration for Web
application environments?
Enterprise XI supports ASP, CSP, and JSP files. Enterprise XI includes
web applications developed in CSP and JSP such as the Enterprise XI
Web Desktop/InfoView and the sample applications available for
Enterprise XI Launchpads.
It also supports the development of custom web applications that use
ASP, CSP, JSP, and ASP.NET pages. CSP files provide functionality
similar to that provided by Microsoft’s ASP files.
JSP files allow you to develop cross-platform J2EE applications that use
Enterprise XI objects in conjunction with your own custom objects, or a
wide variety of objects from third parties.
33. Explain the Business Objects enterprise system integration for
Webservices?
Enterprise XI includes a comprehensive Web Services SDK that allows
developers to integrate documents directly into applications using
9
industry-standard technology. It consists of a series of web-based
functions that use .NET or J2EE platforms and developer
environments.
34. What are the benefits of using Webservices in context of Business
Objects enterprise system integration?
Web Services make it easier and faster to integrate Business Objects
technology with other web-based applications, and facilitate the
deployment of Business Objects with customized applications.
WebServices are available for document display, refresh, and providing
drill-down functionality to users. For developers, the Web Services
provider is deployed on the server side with an Enterprise XI server. The
API enables the creation of customized web sites, applications, or web
services that access the Enterprise XI services.
35. Explain the Business Objects enterprise system Web Component
Adapter?
Web Component Adapter
Enterprise XI provides a web application, the WCA, that allows your web
application server to run Enterprise XI applications and to host the CMC.
The web server communicates directly with the web application server
that hosts the Enterprise XI SDK. The WCA runs on the web application
server and provides all services that are not directly supported by the
Enterprise XI SDK. The web server passes requests directly to the web
application server, which then forwards the
requests on to the WCA. The WCA supports the CMC and OLAP
Intelligence document viewing and interaction.
36. What are the available versions of WCA in Business Objects enterprise
system integration?
There are two versions of the WCA:
.NET - The .NET WCA must be installed on an IIS web application
server.
Java - The Java WCA must be installed on a J2EE web application
server.
37. Explain the Intelligence tier of Business Objects enterprise system?
Intelligence Tier
The Intelligence tier manages the Enterprise XI system. It maintains
all of the security information, sends requests to the appropriate
servers, manages audit information, and stores report instances.
10
38. What are the various servers Intelligence tier consists of ?
The Intelligence tier of Enterprise XI consists of five servers:
•
Central Management Server (CMS)•
Cache Server•
Input and Output File Repository Servers (FRS)•
39. What is the role of the Processing tier?
The Processing tier accesses the data and generates the reports.
40. What are the various servers of the processing tier of Business
Objects enterprise system?
The Processing tier of Enterprise XI consists of eight servers:
Event Server•
Report Job Server•
Program Job Server•
Web Intelligence Job Server•
Web Intelligence Report Server•
Report Application Server (RAS)•
Destination Job Server•
List Of Values Job Server (LOV)•
41. Explain about the the Data Tier of Business Objects enterprise
system?
Data Tier
The data tier is made up of the databases that contain the data used in
the reports. Enterprise XI supports a wide range of corporate databases.
Page Server11
42. What is a Web client and Webserver in context of Business Objects
enterprise system?
Web Client
A web browser is a software application that enables a user to display
and interact with HTML documents hosted by web servers or held in a
file system. A web client is hosted within the web browser and presents
the user with a specific gateway to the main application.
The web clients, InfoView or the CMC make requests to the web
server, which forwards the user requests directly to a web application
server where the requests are processed by components built on the
Enterprise XI SDK – either Java or .NET.
Web Server
The web server manages communication between the web browser
and the Enterprise XI SDKs.
43. List the responsibilities of the webservices of Business Objects
enterprise system?
The primary responsibility of the web services is to receive and to
interpret user requests from user interfaces such as the InfoView or the
CMC. The web services then contact other Enterprise XI servers to
determine the response to the request and format the response so that
it can be returned to the web client.
When using the DHTML viewer or Advanced DHTML viewer, the web
services convert Encapsulated Page Format (EPF) files to DHTML. Report
viewing in Enterprise XI uses Page On Demand technology that sends
each page of a report as it is requested by the user. The EPF files hold
the individual report pages.
When viewing an OLAP Intelligence report using the DHTML OLAP
Intelligence viewer, the web services connect to the OLAP data source
to retrieve the views of data required for the report. When viewing an
OLAP Intelligence report using the ActiveX OLAP Intelligence viewer,
the web client makes a direct connection to the OLAP data source to
retrieve the views of data.
44. What is the role and importance of Web Application Server ?
Web Application Server WAS
Enterprise XI systems that use the Enterprise XI Java SDK or the
Enterprise XI .NET SDK run on a third-party web application server.
The web application server acts as the gateway between the web
server and the rest of the components in Enterprise XI. The web
application server is responsible for processing requests from your
12
browser. It also supports InfoView and other Business Objects
applications, and uses the SDK to convert EPF files to HTML format
when users view pages with a DHTML viewer.
45. What is the role and importance of Web Component Adapter ?
Web Component Adapter WCA
The web server communicates directly with the web application server
that hosts the Enterprise XI SDK. The WCA runs within the web
application server and provides all services that are not directly
supported by the Enterprise XI SDK. The web server passes requests
directly to the web application server, which then forwards the requests
on to the WCA.
The WCA has two primary roles:
•
It processes ASP.NET (.aspx) and JSP files.•
and Crystal Reports viewers that are implemented through
viewrpt.aspx requests.
46. What is a Java WCA?
The Java Web Component Adapter
The Java WCA is a Java web application that runs on your Java web
application server. The WCA hosts web components, including a CSP
plug-in that allows you to run CSP applications on your Java web
application server. You must deploy the WCA to run the CMC, and
other CSP applications in a Java Enterprise XI environment.
47. How to install and deploy the WCA ?
The Enterprise XI setup program configures the Web archive file that
implements the WCA webcompadapter.war file with the following
information:
It also supports Business Objects applications such as the CMC•
The name and location of your CMS.•
The default display name of the WCA.•
pplications.
The location of the directories where the WCA can find CSP•
To deploy the WCA, you must first configure your web application
server to use the cewcanative.jar file, typically by adding its path to
the CLASSPATH of the web application server. Then you must deploy
the WCA archive webcompadapter.war file as a web application.
The location it should use for log files.13
48. What is a .NET WCA ?
The .NET Web Component Adapter
The .NET WCA is a web application that runs on your web application
server. The WCA hosts web components, including a CSP plug-in that
allows you to run CSP applications. You must deploy the WCA to run
the CMC, and other CSP applications, in a .NET Enterprise XI
environment.
49. What is the component in the enterprise system that maintains the
database information?
The CMS (Central management server) maintains a database of
information that allows you to manage the Enterprise XI Framework.
The data stored by the CMS includes information about users and
groups, security levels, content, and servers. The CMS also maintains
the Repository, and a separate audit database of information about
user actions.
50. What is are the functions of CMS ?
The CMS has four main functions:
Maintaining security
By maintaining a database of users and their associated object rights,
the CMS enforces who has access to Enterprise XI and the types of
tasks they are able to perform. This also includes enforcing and
maintaining the licensing policy of your Enterprise XI system.
Managing objects
The CMS keeps track of the location of objects and maintains the
folder hierarchy. By communicating with the Report and Program Job
Servers, the CMS is able to ensure that scheduled jobs run at the
appropriate times.
Managing servers
By staying in frequent contact with each of the servers in the system,
the CMS is able to maintain a list of server status. The web client
(InfoView or CMC) accesses this list, through the SDK, to identify
which Cache Server is free to use for a report viewing request.
Managing auditing
By collecting information about user actions from each Enterprise XI
server, and then writing these records to a central audit database, the
CMS acts as the system auditor. This audit information allows system
administrators to better manage their deployment.Technical Interview Questions in Oracle Apps
Question: How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions fromone environment to another without reKeying? Will you use FNDLOAD?
Answer: FNDLOAD can not be used in the scenario. You can use migrator available in "Oracle iSetup" Responsibility
Question: This is a very tough one, almost impossible to answer, but yet I will ask. Which Form in Oracle Applications has most number of Form Functions?
Answer: "Run Reports". And why not, the Form Function for this screen has a parameter to which we pass name of the "Request Group", hence securing the list of Concurrent Programs that are visible in "Run Request" Form. Just so that you know, there are over 600 form functions for "Run Reports"
Question: Which responsibility do you need to extract Self Service Personalizations?
Answer:Functional Administrator
Question: Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10Answer: FNDLOAD can not be used in the scenario. You can use migrator available in "Oracle iSetup" Responsibility
Question: This is a very tough one, almost impossible to answer, but yet I will ask. Which Form in Oracle Applications has most number of Form Functions?
Answer: "Run Reports". And why not, the Form Function for this screen has a parameter to which we pass name of the "Request Group", hence securing the list of Concurrent Programs that are visible in "Run Request" Form. Just so that you know, there are over 600 form functions for "Run Reports"
Question: Which responsibility do you need to extract Self Service Personalizations?
Answer:Functional Administrator
Answer:You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.
Question: You have just created two concurrent programs namely "XX PO Prog1" & "XX PO Prog2". Now you wish to create a menu for Concurrent Request submission such that only these two Concurrent Programs are visible from that Run Request menu. Please explain the steps to implement this?
Answer: a) Define a request group, lets say with name "XX_PO_PROGS"
b) Add these two concurrent programs to the request group "XX_PO_PROGS"
c) Define a new Form Function that is attached to Form "Run Reports"
d) In the parameter field of Form Function screen, enter
REQUEST_GROUP_CODE="XX_PO_PROGS" REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS"
e) Attach this form function to the desired menu.
Question: Does Oracle 10g support rule based optimization?
Answer: The official stance is that RBO is no longer supported by 10g.
Question: Does oracle support partitioning of tables in Oracle Apps?
Answer: Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records can be archived.
Note: Before running the archival process the second time, you must clear down the archive table GL_ARCHIVE_BALANCES (don’t forget to export archive data to a tape).
Question: What will be your partitioning strategy on GL_BALANCES? Your views please?
Answer: This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, or on the status of the GL Period.
Question: Does Oracle support running of gather stats on SYS schema in Oracle Apps?
Answer: If your Oracle Applications instance is on 10g, then you can decide to run stats for SYS schema. This can be done by exec dbms_stats.gather_schema_stats('SYS');
Alternately using command dbms_stats.gather_schema_stats('SYS',cascade=>TRUE,degree=>20);
I will prefer the former with default values.
If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats('SYS');
You can schedule a dbms_job for running stats for SYS schema.
Question: Can you use concurrent program "Gather Schema Statistics" to gather stats on sys schema in oracle apps?
Answer: No, "Gather Schema Statistics" has no parameters for SYS schema. Please use dbms_job.
Question: Which table is used to provide drill down from Oracle GL into sub-ledger?
Answer: GL_IMPORT_REFERENCES
Question: What is the significance of profile option “Node Trust Level” in Oracle Apps.
Answer: If this profile option is set to a value of external against a server, then it signifies that the specific mid-tier is External i.e. it will be exposed to the www. In other words this server is not within the firewall of your client. The idea behind this profile option is to flag such middle-tier so that special restrictions can be applied against its security, which means a very restricted set of responsibilities will be available from such Middle-Tier.
Question: What is the significance of profile option “Responsibility Trust Level”.
Answer: In order to make a responsibility accessible from an external web tier, you must set profile option “Responsibility Trust Level” at responsibility level to “External”. Only those responsibilities that have this profile option against them will be accessible from External Middle tiers.
Question: What else can you suggest to restrict the access to screens from external web tiers?
Answer: You may use URL filtering within Apache.
Question: What is the role of Document Manager in Oracle Purchasing?
Answer: POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.
Question: How to debug a document manager in Oracle Apps?
Answer: Document manger runs within the concurrent manager in Oracle Applications. When an application uses a Document Manager, it sends a pipe signal which is picked up by the document manager.
There are two mechanisms by which to trace the document manager
1. Set the debugging on by using profile option
STEP 1. Set profile option "Concurrent:Debug Flags" to TCTM1
This profile should only generate debugs when set at Site level(I think, as I have only tried site), because Document Manager runs in a different session.
STEP 2. Bounce the Document Managers
STEP 3. Retry the Workflow to generate debugs.
STEP 4. Reset profile option "Concurrent:Debug Flags" to blank
STEP 5. have a look at debug information in table fnd_concurrent_debug_info
2. Enable tracing for the document managers
This can be done by setting profile option “Initialization SQL Statement – Custom” against your username before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12.
Question: You have written a Java Concurrent Program in Oracle Apps. You want to modify the CLASSPATH such that new class CLASSPATH is effective just for this program.
Answer: In the options field of the concurrent program you can enter something similar to below.
-cp <your custom lib pathused by Java Conc Prog> :/home/xxvisiondev/XXDEVDB/comn/java/appsborg.zip:/home/xxvisiondev/XXDEVDB/comn/java
Question: How will you open a bc4j package in jdeveloper?
Answer: Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).
Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework.
Question: In OA Framework Self-Service screen, you wish to disable a tab. How will you do it?
Answer: Generally speaking, the tabs on a OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from self service page.
Question: In self service, you wish to change the background color and the foreground text of the OA Framework screens to meet your corporate standards. How will you do it?
Answer: You will need to do the below steps
a….Go to Mid Tier, and open $OA_HTML/cabo/styles/custom.xss
b…Enter below text( change colours as needed)
<style name="DarkBackground">
<property name="background-color">#000066</property>
</style>
<style name="TextForeground">
<property name="color">#0000FF</property>
</style>
c… cd $OA_HTML/cabo/styles/cache
d…Take a backup of all the css files.
e…Delete all the files of following pattern oracle-desktop*.css
The idea here is to delete the cache. Next time when you logon to Oracle Apps Self Service, the Framework will rebuild the css file if found missing for your browser.
Question: Can you extend and substitue a root AM ( Application Module) in OA Framework using JDeveloper.
Answer: You can extend the AM in jDeveloper, but it doesn’t work( at least it didn’t work in 11.5.9). I am hopeful that Oracle will deliver a solution to this in the future.
Question: In a workflow notification, you have a free text response field where the user enters the Vendor Number for the new vendor. You want to validate the value entered in the notification response field upon the submission of a response. How will you do it?
Answer: You will need to attach a post notification function to the Workflow Notification.
The PL/SQL code will look similar to below:-
The below code will display an error in the notification when user attempts to create a Duplicate Vendor Number.
PROCEDURE validate_response_from_notif
(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
) IS
l_nid NUMBER;
l_activity_result_code VARCHAR2(200);
v_newly_entered_vendor_num VARCHAR2(50);
CURSOR c_get_response_for_new_vendor IS
SELECT wl.lookup_code
FROM wf_notification_attributes wna
,wf_notifications wn
,wf_message_attributes_vl wma
,wf_lookups wl
WHERE wna.notification_id = l_nid
AND wna.notification_id = wn.notification_id
AND wn.message_name = wma.message_name
AND wn.message_type = wma.message_type
AND wna.NAME = wma.NAME
AND wma.SUBTYPE = 'RESPOND'
AND wma.format = wl.lookup_type
AND wna.text_value = wl.lookup_code
AND wma.TYPE = 'LOOKUP'
AND decode(wma.NAME, 'RESULT', 'RESULT', 'NORESULT') = 'RESULT';
BEGIN
IF (funcmode IN ('RESPOND'))
THEN
l_nid := wf_engine.context_nid;
OPEN c_get_response_for_new_vendor;
FETCH c_get_response_for_new_vendor
INTO l_activity_result_code;
CLOSE c_get_response_for_new_vendor;
v_newly_entered_vendor_num := wf_notification.getattrtext(l_nid,'NEWLY_ENTERED_VENDOR_NUM_4_PO');
IF l_activity_result_code = 'NEW_VENDOR'
AND does_vendor_exist(p_vendor => v_newly_entered_vendor_num)
THEN
RESULT := 'ERROR: VendorNumber you entered already exists';
RETURN;
END IF;
END IF;
EXCEPTION
WHEN OTHERS THEN
RESULT := SQLERRM;
END validate_response_from_notif;
Question: How to make concurrent program end with warning?
Answer: If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.
For a Java Concurrent program, use the code similar to below
ReqCompletion lRC;
//get handle on request completion object for reporting status
lRC = pCpContext.getReqCompletion();
lRC.setCompletion(ReqCompletion.WARNING, "WARNING");
Question: How do you link a Host type concurrent program to Concurrent Manager?
Answer: Assuming your executable script is LOADPO.prog, then use the commands below
cd $XXPO_TOP/bin
ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO
Question: How do you know if a specific Oracle patch has been applied in apps to your environment.
Answer: Use table ad_bugs, in which column bug_number is the patch number.
SELECT bug_number
,to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS') dated
FROM apps.ad_bugs
WHERE bug_number = TRIM('&bug_number') ;
Question: How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode.
Answer: If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.
Question: What are the various ways to kick-off a workflow
Answer: You can eiter use wf_engine.start_process or you can attach a runnable process such ghat it subscribes to a workflow event.
Question: When starting (kicking off) an oracle workflow process, how do you ensure that it happens in a background mode?
--a)if initiating the process using start_process, do the below
wf_engine.threshold := -1;
wf_engine.createprocess(l_itemtype
,l_itemkey
,'<YOUR PROCESS NAME>');
wf_engine.startprocess(l_itemtype, l_itemkey)--B) When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.
Question: On 10g, how will you use awr?
Answer: By running below scripts. These are both the same scripts, but with differing parameters.
$ORACLE_HOME/rdbms/admin/awrrpt.sql
$ORACLE_HOME/rdbms/admin/awrrpti.sql
Question : How will you configure Apache to run in Debug mode, specifically usefull when debugging iProcurement ( prior to 11.5.10).
Answer: After 11.5.10, FND Logging can be used for debugging Oracle iProcurement.
Prior to 11.5.10
----STEPS IN A NUTSHELL-----
cd $ORACLE_HOME/../iAS/Apache
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
DebugOutput=/home/<<SID>>/ora9/iAS/Apache/Apache/logs/debug.log
DebugLevel=5
DebugSwitch=ON
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
ApJServLogLevel debug
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.properties
log=true
Question: How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?
Answer: Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps :-
a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
b) Substitute the base VO, by using jpximport [ similar to as explained in Link ]
c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.
Question: Can you do fnd_request.submit_request from SQL Plus in Oracle?
Answer: You will need to initialize the global variables first using fnd_global.initialize
DECLARE
v_session_id INTEGER := userenv('sessionid') ;
BEGIN
fnd_global.initialize
(
SESSION_ID => v_session_id
,USER_ID => <your user id from fnd_user.user_id>
,RESP_ID => <You may use Examine from the screen PROFILE/RESP_ID>
,RESP_APPL_ID => <You may use Examine from the screen PROFILE/RESP_APPL_ID>
,SECURITY_GROUP_ID => 0
,SITE_ID => NULL
,LOGIN_ID => 3115003--Any number here
,CONC_LOGIN_ID => NULL
,PROG_APPL_ID => NULL
,CONC_PROGRAM_ID => NULL
,CONC_REQUEST_ID => NULL
,CONC_PRIORITY_REQUEST => NULL
) ;
commit ;
END ;
/Optionally you may use fnd_global.apps_initialize, which internally calls fnd_global.initialize
fnd_global.apps_initialize(user_id => :user_id,
resp_id => :resp_id,
resp_appl_id => :resp_appl_id,
security_group_id => :security_group_id,
server_id => :server_id);By doing the above, your global variables upon which Concurrent Managers depend upon will be populated. This will be equivalent to logging into Oracle Apps and submitting the concurrent request from a responsibility.
Question: You are told that the certain steps in the Oracle Apps Form/Screen are running slow, and you are asked to tune it. How do you go about it.
Answer: First thing to do is to enable trace. Preferably, enable the trace with Bind Variables. This can be done by selecting menu Help/Diagnostics/Trace/”Trace With Binds and Wait”
Internally Oracle Forms issues a statement similar to below:-
alter session set events='10046 trace name context forever, level 12' ;
Enable Trace with Bind Variables in Apps
This will enable the trace with Bind Variable values being shown in the trace file.
The screen in Oracle Apps will also provide the name of the trace file which is located in directly identified by
select value from v$parameter where name like '%us%r%dump%'
Doing a tkprof with explain plan option, reviewing plans and stats in trace file can help identify the slow performing SQL.
Question: What is the difference between running Gather Stats and “Program – Optimizer[RGOPTM]” in Oracle General Ledger?
Answer: “Gather Stats” will simply gather the stats against existing tables, indexes etc. However Gather Stats does not create any new indexes. But “Program – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided accounting segment has the indexed flag enabled,
Question: You have written a piece of code in POR_CUSTOM_PKG for Oracle iProcurement, but its not taking any effect? What may be the reason?
Answer: Depending upon which procedure in POR_CUSTOM_PKG has been programmed, one or more of the below profile options must be set to Yes
POR: Enable Req Header Customization
POR: Enable Requisition Line Customization
POR: Enable Req Distribution Customization
Question: What is the key benefit of punching out to suppliers catalogs rather than loading their catalogs locally in Oracle iProcurement?
Answer: Punchout has several advantages like, Catalogs don’t need to be loaded locally saves space on your system. You can get up-to-date list of catalogs by punching out and also you get the benefit of up-to-date pricing information on vendor items.
Question: Does oracle have a test environment on exchange?
Answer: http://testexchange.oracle.com
Question: Does Oracle Grants use its own schema or does it uses Oracle Project Accounting schema?
Answer: Although Oracle Grants has its own schema i.e. GMS, it reuses many of the tables with in Oracle Projects Schema like PA_PROJECTS_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_TYPES etc.
Question: How to make an Oracle Report Type concurrent program produce an excel friendly output?
Answer: Comma can be concatenated between the column values, however a better option is to create tab delimited file, as it takes care of commas within the string.
For this, use SQL similar to below in the report
select 'a' || chr(9) || 'b' from dual;
Question: What are the settings needed for printing bitmap reports?
Answer: Get your DBA to configure two files i.e. uiprint.txt & default.ppd
For details, refer to Metalink Note 189708.1
Question: For a PL/SQL based concurrent program do you have to issue a commit at the end?
Answer: The concurrent program runs within its own new session. In APPS, the default database setting enforces a commit at the end of each session. Hence no explicit COMMIT is required.
Question: What is the best way to add debugging to the code in apps?
Answer: Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging uses autonomous transaction to insert records in a table named fnd_log_messages.
For example
DECLARE
BEGIN
fnd_log.STRING(log_level => fnd_log.level_statement
,module => 'xxxx ' || 'pkg/procedurename '
,message => 'your debug message here');
END ;Three profile options effecting FND Logging are
FND: Debug Log Mode
FND: Debug Log Enabled
FND: Debug Log Module
Question: If you wish to trigger of an update or insert in bespoke table or take some action in response to a TCA record being created or modified, how would you do it? Will you write a database triggers on TCA Tables?
Answer: There are various pre-defined Events that are invoked from the Oracle TCA API’s.
TCA was Oracle’s first initiative towards a fully API based approach, which means the screen and the processes all use the same set of APIs for doing same task.
In order to take an action when these events occur, you can subscribe a custom PL/SQL procedure or a Custom Workflow to these events. Some of the important TCA events are listed below:-
oracle.apps.ar.hz.ContactPoint.update
oracle.apps.ar.hz.CustAccount.create
oracle.apps.ar.hz.CustAccount.update
oracle.apps.ar.hz.CustAcctSite.create
oracle.apps.ar.hz.CustAcctSite.update
oracle.apps.ar.hz.CustAcctSiteUse.create
oracle.apps.ar.hz.CustAcctSiteUse.update
oracle.apps.ar.hz.Location.create
oracle.apps.ar.hz.Location.update
oracle.apps.ar.hz.Organization.create
oracle.apps.ar.hz.Organization.update
oracle.apps.ar.hz.PartySite.create
oracle.apps.ar.hz.PartySite.update
oracle.apps.ar.hz.PartySiteUse.create
oracle.apps.ar.hz.PartySiteUse.update
oracle.apps.ar.hz.Person.create
oracle.apps.ar.hz.Person.update
Question: In Oracle OA Framework, is the MDS page/document definition stored in database or in the file system?
Answer: The MDS document details are loaded into database, in the following sets of tables.
JDR_ATTRIBUTES
JDR_ATTRIBUTES_TRANS
JDR_COMPONENTS
JDR_PATHS
The Document is loaded via XMLImporter, as detailed in XMLImporter Article
Question: In a Oracle Report data group, you have a “data link” between two queries. How do you ensure that the data link is made Outer Joined?
Answer: The data link is an Outer Join by default.
Question: How does substitution work in OA Framework?
What are the benefits of using Substitution in OA Framework?
Answer: Based on the user that has logged into OA Framework, MDS defines the context of the logged in user. Based upon this logged in context, all applicable personalization are applied by MDS. Given that substitutions are loaded as site level personalizations, MDS applies the substituted BC4J objects along with the personalizations. The above listed steps occur as soon as Root Application module has been loaded.
The benefit of using Substitution is to extend the OA Framework without customization of the underlying code. This is of great help during Upgrades. Entity Objects and Validation Objects can be substituted. I think Root AM’s can’t be substituted given that substitution kicks off after Root AM gets loaded.
Question: In OA Framework, once your application has been extended by substitutions, is it possible to revert back to remove those substitutions?
Answer: yes, by setting profile option “Disable Self-Service Personal%” to Yes, keeping in mind that all your personalizations will get disabled by this profile option. This profile is also very useful when debugging your OA Framework based application in the event of some error. By disabling the personalization via profile, you can isolate the error, i.e. is being caused by your extension/substitution code or by Oracle’s standard functionality.
Question: How can you import invoices into Oracle Receivables?
Answer: You can either use AutoInvoice by populating tables RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL & RA_INTERFACE_SALESCREDITS_ALL.
Alternately you may decide to use API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.
Question: How do you setup a context sensitive flexfield
Answer: Note: I will publish a white paper to sho step by step approach.
But for the purpose of your interview, a brief explanation is…a)Create a reference field, b) Use that reference field in “Context Field” section of DFF Segment screen c) For each possible value of the context field, you will need to create one record in section “Context Field Value” ( beneath the global data elements).
Question: Does Oracle iProcurement use same tables as Oracle Purchasing?
Answer: Yes, iProcurement uses the same set of requisition tables as are used by Core Purchasing.
Question: What is the name of the schema for tables in tca
Answer: AR (at least till 11.5.10, not sure about 11.5.10).
Question: Are suppliers a part of TCA?
Answer: Unfortunately not yet. However, Release 12 will be merging Suppliers into TCA.
Question: What is the link between order management and purchasing
Answer: Internal Requisitions get translated into Internal Sales Orders.
Question: How would you know if the purchase order XML has been transmitted to vendor, looking at the tables.
Answer: The XML delivery status can be found from a table named ecx_oxta_logmsg. Use the query below
SELECT edoc.document_number
,decode(eol.result_code, 1000, 'Success', 'Failure') AS status
,eol.result_text
FROM ecx_oxta_logmsg eol
,ecx_doclogs edoc
,ecx_outbound_logs eog
WHERE edoc.msgid = eol.sender_message_id
AND eog.out_msgid = edoc.msgid
ORDER BY edoc.document_number
Question: You have done forms personalization, now how will you move it from one environment to another?
Answer: Use FNDLOAD. For examples visit FNDLOAD Article
Question: What are the key benefits of forms personalization over custom.pll?
Answer:
-->Multiple users can develop forms personalization at any given point in time.
-->It is fairly easy to enable and disable forms personalizations.
-->A programmer is not required to do simple things such as hide/disable fields or buttons.
-->Provides more visibility on customizations to the screen.
Question: Tell me some limitations of forms personalization when compared to CUSTOM.pll?
Answer:
-->Can't create record group queries, hence can’t implement LOV Query changes.
-->Can't make things interactive, i.e. can’t have a message box that gives multiple choices for example Proceed or Stop etc.
Question: Give me one example where apps uses partitioning?
Answer: WF_LOCAL_ROLES
Question: Give me one example of securing attributes in iProcurement.
Answer: You can define Realm to bundle suppliers into a Category. Such realm can then be assigned to the User using Define User Screen. Security Attribute ICX_POR_REALM_ID can be used. By doing so, the user will only be made visible those Punchout suppliers that belong to the realm against their securing attributes.
Question: Can you send blob attachments via workflow notifications?
Answer: Yes, you can send BLOB Attachments.
Order Management Interview Questions:
Yes, by creating the column as long raw datatype.
Insert the Vendor info into the interface tables and perform the required validations: AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT Run the below programs to load the data into the Base tables: Supplier Open Interface Import Supplier Sites Open Interface Import Supplier Site Contacts Open Interface Import
We can define the matching and tax tolerances i.e how much to allow for variances between invoice, purchase order, receipt, and tax information during matching. You can define both percentage¿based and amount¿based tolerances.
In the Financials Options window, you can set the Supplier Number entry option to either Autimoatic or Manual ¿ Automatic: The system automatically assigns a unique sequential number to each supplier when you enter a new supplier. ¿ Manual: You enter the supplier number when you enter a supplier
Contract PO is created when you agree with your suppliers on specific terms and conditions without indicating the goods and services that you will be purchasing.
A medium you use to instruct your bank to disburse funds from your bank account to the bank account or site location of a supplier.
PO_VENDORS
1)Create Invoice 2)Validate Invoice 3)Create Accounting entries using Payables Accounting Process 4)Submit the Payables Transfer to General Ledger program to send invoice and payment accounting entries to the General Ledger interface. 4)Journal Import (GL) 5)Journal Post (GL)
Standard, Credit Memo, Debit Memo, Expense Report,PrePayment, Mixed, PO Default
Go to Payables Manager for the appropriate Operating Unit. Navigation:Setup--->Set of Books--->choose.
pls check whether that particular supplier is available in Suppliers addition inforamtion or not.
Expenses and Liabilities
Payables lets you apply holds manually on an invoice, Payments etc to prevent the payment from being made or to prevent the accounting entries to be created etc. Some of the Payable holds are -- Invoice Hold, Accounts Hold, Funds Hold, Matching Hold, Variance Hold, Misc hold.
Purchasing
Payment Terms let you define the due date or the discount date , due amount or discount amount. Once the payment terms are defined, you can attach these to the suppliers and supplier sites and these terms will be automatically populated once the invoice is entered for a supplier site.
No Key Flexfields in AP
Item, Tax, Miscellaneous,Freight, Withholding Tax
Temporary and Permanent
Aging Periods window are the time periods for the Invoice Aging Report. The Invoice Aging Report provides information about invoice payments due during four periods you specify.
Payables Open Interface -- for importing regular invoices Payables Invoice Import -- for importing expense reports. In 11i renamed as Expense Report Import.
Prepayment is a type pf invoice that you enter to make an advance payment to a supplier or employee. To Apply it to an Invoice ,in the Invoices window, query either the prepayment or the invoice to which you want to apply it. Choose the Actions button and select the Apply/Unapply Prepayment check box. Click OK.
Yes. 1.Go to the Invoice window. Go to the scheduled payments tab. 2.Click "Split" to split the scheduled payment into as many payments as you wish. 3.Check "Hold" against the Payment line you wish to hold.
Create Accounting. Transfer the transactions to GL_Interface Import the Journals Post the Journals
Payables Transfer to General Ledger Program
In Payables accounting periods have to be defined to enter and account for transactions in these open periods. Payables does not allow transaction processing in a period that has never been opened. These periods are restricted to Payables only. The period statuses available in Payables are Never Opened, Future,Open, Closed, and Permanently Closed.
Payables Open Interface Import to load Invoices and other transactions. Supplier Open Interface Import to load Suppliers. Supplier Sites Open Interface Import to load Supplier sites. Supplier Site Contacts Open Interface Import to load Supplier Site contacts.
Credit Memo is a negative amount invoice you receive from a supplier representing a credit. Debit Memo is a negative amount invoice you send to notify a supplier of a credit you recorded for goods or services purchased.
Sales Tax Location, Territory
Transfer the transactions to GL_Interface Import the Journals Post the Journals
It is a unique number used to identify the Customers.
In the table hz_customer_profiles
To relate the Order Number (ONT) to the Invoice (AR) we use the LINE TRANSACTION FLEX FIELDS. In RA_CUSTOMER_TRX_ALL, INTERFACE_HEADER_ATTRIBUTE1 to INTERFACE_HEADER_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order (HEADER INFO). In RA_CUSTOMER_TRX_LINES_ALL, INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order.(LINE INFO)
Invoices, credit memos, debit memos, and on¿account credits can be imported using AutoInvoice.
Invoice, Credit Memo, Debit Memo,Charge back, commitments
Import, Validate, Post Quick Cash
2-way matching: 2-way matching verifies that Purchase order and invoice quantities must match within your tolerances 3-way matching: 3-way matching verifies that the receipt and invoice information match with the quantity tolerances 4-way matching: 4-way matching verifies that acceptance documents and invoice information match within the quantity tolerances
Interface tables: RA_INTERFACE_LINES_ALL Base tables: RA_CUSTOMER_TRX_ALL RA_BATCHES RA_CUSTOMER_TRX_LINES_ALL AR_PAYMENT_SCHEDULES_ALL RA_CUSTOMER_TRX_LINE_SALESREPS RA_CUST_TRX_GL_DIST_ALL AR_RECEIVABLES_APPLICATIONS AR_ADJUSTMENTS RA_CUSTOMER_TRX_TYPES_ALL Concurrent Program: Auto invoice master program Validations: check for amount, batch source name, conversion rate, conversion type. Validate orig_system_bill_customer_id, orig_system_bill_address_id, quantity. Validate if the amount includes tax flag.
TCA canbe used to import or modify Customers related data.
Standard, Blanket, Contract, Planned
An approval group is defined which is nothing but a set of authorization rules comprised of include/exclude and amount limit criteria for the following Object Types: Document Total, Account Range, Item Range, Item Category Range, and Location that are required to approve a PO. You can always change the rules by doing the below: Navigation: Purchasing Responsibility > Setup > Approvals > Approval Groups Query the Approval group and change teh rules accordingly.
CREATE REQUISTION, RAISE RFQ(REQUEST FOR QUOTATION),QUOTATIONS,PURCHASE ORDER,RECIEPTS
Creating a Receipt with "Receipt Date" less than sysdate or today's date is referred to as 'Backdated Receipt".
No. The receipt date has to be with in open GL period.
The buffer time during which receipts can be created with out warning/error prior or later to receipt due date.
Receipt Tolerance can be set in three different places. 1. Master Item Form (Item Level) 2. setup, organization form (Organization Level) 3. Purchase Order, Receiving controls. (shipment level).
No
PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL,PO_DISTRIBUTIONS_ALL
Create PO Submit it for Approval Receive Goods against the PO (when order is delivered by the vendor) Close the PO after the invoice is created in AP and teh payments have been made to the vendor.
Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships. If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it.
It Depends on the setup whether it is position based or supervisor based.
A Planned PO is a long¿term agreement committing to buy items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities, and estimated cost.
Create Requisition, Receive the goods.
If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it.
Iprocurement is a self service application with a web shopping interface. WE can only create and manage requisitions and receipts. Purchasing module is form based and also lets you create PO and many other functions are possible other than requisitions and receiving.
A Blanket PO is created when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not know the detail of your delivery schedules.
Not available
Purchase Order: The document which is created and sent to supplier when we need to purchase something. (Buying) Sales Order: The document which is created when customer places an order to buy something. (Selling)
Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems.
Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.
If the order is Pick Confirmed, it cannot be cancelled.
Order Management Responsibility >Orders, Returns : Import Orders> Corrections
A user-defined set of criteria to define the priorities Order Management uses when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory.
An unfulfilled customer order due to non-existence of the ordered items in the Inventory.
ORDER MANAGEMENT
When the order is pick released.
WSH_DELIVERY_DETAILS,WSH_NEW_DELIVERIES, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, MTL_SYTEM_ITEMS_B, MTL_MATERIAL_TRANSACTIONS
Price list contains information on items and its prices. The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order.
Book the order Pick Release Pick Confirm Ship Confirm Close the order
An external shipping document that is sent along with a shipment itemizing in detail the contents of that shipment.
A validation template names a condition and defines the semantics of how to validate that condition. Validation templates can be used in the processing constraints framework to specify the constraining conditions for a given constraint.
While creating the order,you can define defaulting rules so that the default values of the fields pop up automatically instead of typing all information.
A method of fulfilling sales orders by selling products without handling, stocking,or delivering them. The selling company buys a product from a supplier and has the supplier ship the product directly to customers.
Order cannot be delted if the Order is Pick Confirmed.
Drop Shipment is a process where the customer places a purchase order on a company and this company instructs its supplier to directly ship the items to the customer.
Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.
It can be done from Oracle Application Manager available in System administrator responsibility.
Using the standard functions available in WFSTD Item type we define start and end functions. They are standard to which we dont need to link any PL/SQL function and return any value to it.
WF_NOTIFICATIONS, WF_MESSAGES, WF_COMMENTS, WF_ROLES, WF_ATTRIBUTES e.t.c
Function is used perform some PL/SQL operation and finally received input from PL/SQL procedure or function. It can not send emails to users. where are Notification can be used to send email notification to users and also perform PL/SQL operations.
use AND fucntion from WFSTD item type.
Item Type is the boss in heirarchy or workflow components. Item type holds all sub components like functions, notifications, lookups, messages, attributes, events e.t.c Item Key is unique key which need to be provided for itemtype while running an instance or workflow. Combination of itemtype,itemkey should be always unique.
Roles are simillar to email distribution lists. Roles holds group of users to send email.
We can do in two ways 1. from command prompt using wfload 2. open workflow in standalone builder and then do save as and select database.
User OR Function from WFSTD(Standard) itemtype.
Use Conditional formatting
Use FND_SUBMIT.REQUEST() to call a concurrent program or a report. Use SRW.RUN_REPORT() to run a report directly without registering it as a concurrent program.
1. Use UTL_SMTP (refer to Scripts tab for more details) 2. Use MAILX called in a shell script registered as a concurrent program with parameters File name and path.
SRW.INIT
Anchors fasten an edge of one object to an edge of another object, ensuring that they maintain their positions relative to its parent.
1.Use TEXT_IO package 2.Use SPOOL in After Report trigger 3.Use UTL Package
The total printed at the bottom of first page has to be carried to the top of the next page.
Both provide the same functionality, used to format the output based on particular conditions. Format triggers provide a wide variety of options when compared to conditional formatting(GUI). In format Triggers we have the option to write PL/SQL code where as conditional formatting is GUI based which provide limited options.
Give Page Break in the Format trigger of the repeating frame.
By installing the Barcode Font and using the Chart field in the Layout.
Header, Main, Trailer
It is the standard reports package and it has many procedures like USER_EXITS, DO_SQL, RUN_REPORT, MESSAGE,TRACE, BREAK, SET_ATTR.
A bind reference replaces a single value or expression.To create a bind reference in a query, prefix the parameter name with a colon (:). A lexical reference is a text string and can replace any part of a SELECT statement, such as column names, the FROM clause, the WHERE clause, or the ORDER BY clause. To create a lexical reference in a query, prefix the parameter name with an ampersand (&).
User exits provided a way to pass control from Reports Builder to a program you have written, which performs some function, and then returns control to Reports Builder. Ex: SRW.DO_SQL, SRW.USER_EXIT
1. Before Parameter 2. After Parameter 3. Before Report 4. Between Pages 5. After Report
P_CONC_REQ_ID, P_ORG_ID
Yes.
Reports bursting offers you to deliver a single report to multiple destinations simultaneously. It offers you to create multiple reports out of one single report model. For example, you can create just one employee report for all your departments and send an email with a PDF-attachment containing the report to each manager. Each report would contain only the relevant department information for that particular manager. Using the reports bursting functionality will reduce the overhead since you will only have a single data fetch and report format.
why we use incompatability option in concurant program window? Explian with an example in real time.
TABLES are like Arrays, used for temporary storage. The declaration of TABLE involves 2 steps: Declare the table structure using TYPE statement and then declare the actual table.
By calling the standard fnd_profile procedure.
External tables can be used to load flat files into the database. Steps: First create a directory say ext_dir and place the flat file (file.csv) in it and grant read/write access to it. Then create the table as below: create table erp_ext_table ( i Number, n Varchar2(20), m Varchar2(20) ) organization external ( type oracle_loader default directory ext_dir access parameters ( records delimited by newline fields terminated by , missing field values are null ) location (file.csv) ) reject limit unlimited;
The RANK() and DENSE_RANK() functions can be used to determine the LAST N or BOTTOM N rows.
Declare ... Excep_name exception; procedure Excep_name is begin raise some_exc; end Excep_name; Begin .... end;
Updates done wouldn't be Rolled Back as CREATE statement which is a DDL would issue a COMMIT after the creation of the table.
When Trace option is Enabled, the .trc file is created in Udump folder which is not in readable format. Tkprof utility is used to convert this .trc file into a readable format. syntax: tkprof trcfilename outputfilename
select text from dba_source where name = 'Procedurename'
TRUNCATE will completely erase the data where as in DELETE you have the option to delete only few rows. TRUNCATE is DDL command where as DELETE is DML command
Yes but by defining an autonomous transaction.
Yes only INSTEAD OF trigger can be used to modify a view. CREATE OR REPLACE TRIGGER trigger_name INSTEAD OF INSERT ON view name begin ... end;
A ref cursor is a variable, defined as a cursor type, which will point to a cursor result. The advantage that a ref cursor has over a plain cursor is that is can be passed as a variable to a procedure or a function. Ref Cursors are of 2 types: Weak and Strong. In the case of Strong type, the data type of the returned cursor result is defined whereas in Weak type, it is not defined. Eg:type erp_cursor is ref cursor; -- weak type erp_cursor is ref cursor returning erp%rowtype; --strong declare 2 type erp_cursor is ref cursor; 3 c1 erp_cursor; 4 r_c1 articles%rowtype; 5 r2_c1 scripts%rowtype; 6 7 begin 8 open c1 for select * from articles; 9 fetch c1 into r_c1; 10 close c1; 11 open c1 for select * from scripts; 12 fetch c1 into r2_c1; 13 close c1; 14 end;
Yes
.log .bad .discard
System defined and user defined Exceptions
Function has to return a value where procedure may or maynot return values. Function can be used in SQL statements and procedures can not.
Dynamic SQL allows you to construct a query, a DELETE statement, a CREATE TABLE statement, or even a PL/SQL block as a string and then execute it at runtime.
FND_REQUEST.SUBMIT_REQUEST()
Materialized view will not be refreshed everytime you query the view so to have good performance when data is not changed so rapidly we use Materialized views rather than normal views which always fetches data from tables everytime you run a query on it.
The RAISE_APPLICATION_ERROR is a procedure defined by Oracle that allows to raise an exception and associate an error number and message with the procedure.
Triggers are simply stored procedures that are ran automatically by the database whenever some event happens. The general structure of triggers is: CREATE [OR REPLACE] TRIGGER trigger_name BEFORE (or AFTER) INSERT OR UPDATE [OF COLUMNS] OR DELETE ON tablename [FOR EACH ROW [WHEN (condition)]] BEGIN ... END;
An autonomous transaction is an independent transaction that is initiated by another transaction (the parent transaction). An autonomous transaction can modify data and commit or rollback independent of the state of the parent transaction.
Explicit Cursors, Implicit Cursors, Ref Cursors
TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE
ROWID is a pseudo column attached to each row of a table. It is 18 characters long, blockno, rownumber are the components of ROWID
To protect some of the columns of a table from other users. - To hide complexity of a query. - To hide complexity of calculations.
SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error that occurred in the code. These are especially useful for the WHEN OTHERS exception.
The tkprof tool is a tuning tool used to determine cpu and execution times for SQL statements. You use it by first setting timed_statistics to true in the initialization file and then turning on tracing for either the entire database via the sql_trace parameter or for the session using the ALTER SESSION command. Once the trace file is generated you run the tkprof tool against the trace file and then look at the output from the tkprof tool. This can also be used to generate explain plan output.
Global temporary tables are session specific, meaning the users in other sessions cannot see or manipulate the data in the temporary table you have created. Only you can access or insert or delete or perform anything with the data in the temporary table in your session and the other users cannot use or access this. Once you end your session, the data in the temporary table will be purged.
org_id refers to unique identifier for the Operating Units and organization_id reers to the unique identifier for Inventory Organizations.
Global variables are variables with more scope which is at the application level. They can be used in Form personalizations, PL/SQL procedures , reports e.t.c
Custom Events are used to track and see which trigger is fired at what point in oracle forms. This can be enabled by going to Help >> Diagnostics >> Custom Code >> Show custom events
Key Flexfield stores the key Information. They are stored in Segment columns in tables. Descriptive Flexfields are used to store additional inforamtion. They are stored in Attribute fields in tables. They can be context-sensitive.
Define the Executable Define the Program for the above Executable Attach the program to the required Responsibility
Multi-Org is an Oracle Financials feature that lets you identify specific data and financial transactions as belonging to a single organization - classified as an `Operating Unit' within your enterprise. This is essential for large customers with multiple lines of business or divisions where you want to secure access to information and simplify processing and reporting.
Concurrent program stores the definition of what needs to be run and what parameters it can accept where as concurrent request is submitting the concurrent program for output.
Oracle Alerts are used to monitor unusual or critical activity withina designated database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from tablespace sizingto activities associated with particular applications
Profile options can be used to restrict the access to the applications
To see the hidden data from application forms we use diagnostics. It can be enabled from Help >> Diagnostics >> select any sub function. You need to enter database password to enter diagnostics
Refer to the Order to Cash article: http://www.erpschools.com/Apps/oracle-applications/articles/General/Order-to-Cash-Cycle/index.aspx
Refer to Procure to Pay Article: http://www.erpschools.com/Apps/oracle-applications/articles/General/Procure-to-Pay-Cycle/index.aspx
Only once.
Forms Personalization is a standard feature provided by oracle and supported by oracle to customize the forms. With Forms personalization you can hide fiedls, make fields mandatory, create zoom functionality, change lov dynamically e.t.c
WHEN-NEW-FORM-INSTANCE WHEN-NEW-BLOCK-INSTANCE WHEN-NEW-RECORD-INSTANCE WHEN-NEW-ITEM-INSTANCE WHEN-VALIDATE-RECORD MENUS SPECIAL EVENTS
A Form can have multiple functions. Having the personalization at function level limits the scope of the personalization. For example in Inventory for both "Master Item form" and "Organization Item form" uses same form named INVIDITM where as both have different fucntions linked to them.
Yes.
Yes. In the actions set DISPLAYED property to false.
Yes. Using global Variables.
Form Personlizations can be moved easily through FNDLOAD from one instance to other. Refer to the Article FNDLOAD for more details: http://www.erpschools.com/Apps/oracle-applications/articles/General/FNDLOAD-to-transfer-the-menus-concurrent-programs-personalization-from-one-instance-to-other/index.aspx
Personalization gives us the ability to customize Forms in a very easy manner. The below customizations are possible through Personalization: Zoom from one form to another Pass data from one form to another through global variables Change LOV values dynamically Enable/Disable/Hide fields dynamically Display user friendly messages when required Launch URL directly from oracle form Execute PL/SQL programs through FORM_DDL package Call custom libraries dynamically
FORM level and FUNCTION level
The below can be done using PErsonalization: Zoom from one form to another Pass data from one form to another through global variables Change LOV values dynamically Enable/Disable/Hide fields dynamically Display user friendly messages when required Launch URL directly from oracle form Execute PL/SQL programs through FORM_DDL package Call custom libraries dynamically
Refer to the Forms Personalization Tutorial article: http://www.erpschools.com/Apps/oracle-applications/articles/Tools/Forms/Personalization/Forms-Personalization-Tutorial/index.aspx
Advantages: Personalizations are stored in tables rather than files Will not have a bigger impact when you upgrade or apply patches to the environment Can be moved easily through FNDLOAD from one instance to other Can be restricted at site/responsibility/user level Easy to disable/enable with click of a button. Personalization will store who columns with which we have the ability to track who created/modified it where as in CUSTOM.PLL we don¿t have that ability. Disadvantages: Not all can be customized using Personalization.
When you display a error message at WHEN-VALIDATE Trigger will the data will be saved into database?
No. If it is normal message or warning data will be saved but not for error message.
Please ignore this FAQ.
No comments:
Post a Comment