Archive for the ‘Oracle’ Category

Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

Differences between where and having clause

WHERE: Where clause is used to filter the data based on condition. Only rows that meets conditions contribute data to the result set. Filters rows Where clause is executed before group by clause. Use where clause, if there is no aggregate function in condition.

Types of Documents in Oracle Apps

Types of Docs in Oracle Apps:   MD 050 -> Module design by the functional consultant.   MD 070 -> Technical Document designed by the technical consultant.   MD 020 -> Technical document designed by the functional document.   MD 0120 -> Migration and user training document by the technical consultant.   CV 040 -> Conversion of […]

Abstract Factory Pattern

The Abstract Factory pattern is one level of abstraction higher than the Factory Method pattern. You can use this pattern to return one of several related classes of objects, each of which can return several different objects on request. In other words, the Abstract Factory is a factory object that returns one of several groups […]

tca in oracle apps r12

The oracle E-Business Suite has a single repository called the “Trading Community Architecture”(TCA) to store information about your trading partners. TCA provides a single common definition that can be used to identify customers, supplier and organizations that provide you with goods or services and are in turn, a customer of your own products or services.  […]

oracle apps r12 inventory

What is the primary key in MTL_SYSTEMS_ITEMS_B ? Composite primary key (INVENTORY_ITEM_ID + ORGANIZATION_D) What is the column name and table name to get item? MTL_SYSTEMS_ITEMS_B.SEGMENT1 What are the tables get hit when we create item? MTL_SYSTEMS_ITEMS_B MTL_SYSTEMS_ITEMS_TL MTL_ITEM_CATEGORIES MTL_ITEM_REVISIONS What is the item category?   Logical grouping of inventory items based on similar properties […]

Relationship between HZ tables

Creating Request Group

System Administrator -> security -> Responsibility -> Request   After creating request group, attach concurrent programs, applications and request sets to request group  

Creating Responsibility

A responsibility is a level of authority in Oracle applications that lets you access only those oracle applications functions and data appropriate to fulfill your role an organization.   -> System Administrator -> security -> responsibility -> click on Define     Below screen / page will open after clicking the “define”   Enter Responsibility […]

User Creation

Only system administrators can create new user’s in oracle e-business suite.   1. Login to oracle e-business suite using system administrator responsibility 2. If you login with operations/welcome credentials, then click on System Administrator link     3. click on menu link security : User -> Define 4. Enter UserName in “User Name:” field   […]

Powered by k2schools