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

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

7. In which table the subinventories are stored.

The subinventories are stored in the table
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,

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

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

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