Total Pageviews

August 7, 2015

8/07/2015 12:40:00 AM
1. How data will be loaded into interface tables from the external system?
2. The  data from the external systems can be uploaded into interface tables by using the sql loader
The interface tables.
3. How will you establish the connection between two same oracle databases?

The two databases can be connected by using the database link.

4. What are the Inventory material transactions interface tables?

The material transactions interface tables are
MTL_TRANSACTIONS_INTERFACE,  MTL_TRANSACTIONS_LOTS_INTERFACE, MTL_SERIAL_NUMBERS_INTERFACE, MTL_INTERFACE_ERRORS.

5. In which table the inventory material transactions history data is maintained

After running the interface program?
The material transactions data is maintained in MTL_MATERIAL_TRANSACTIONS.

6. In which table the onhand quantities of the items exist?

The quantities of the items are stored in MTL_ONHAND_QUANTITIES
       table.

7. In which table the subinventories are stored.

The subinventories are stored in the table
                   MTL_SECONDARY_INVENTORIES.
8. In which table the locators are stored?

The location information is stored in the table MTL_ITEM_LOCATIONS

9. In MTL_ONHAND_QUANTITIES table the quantities of the items are available in which combination?

The items quantities are stored in the combination of ORGANIZATION,
SUBINVENTORY and LOCATOR.

10. What is nettable property in Inventory?

Nettable indicates whether the items in the subinventory is available for planning purposes

11. In which table item categories are stored.

The categories are stored in the table MTL_CATEGORIES.

12. In which table the AR invoices will be stored/?

The invoices are stored in the table RA_CUSTOMER_TRX_ALL and
RA_CUSTOMER_TRX_LINES_ALL.

13. What are the interface tables for storing the AR invoices while importing

The invoices using interface program?
The interface tables are RA_INTERFACE_LINES_ALL and
RA_INTERFACE_DISTRIBUTIONS_ALL.

14. Can we import the cost for an item using item interface?
The cost of an item can be imported using item interface.