Interested to Buy Any Domain ? << Click Here >> for more details...
what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?
- 2 Answers
- 17962 Views
- I also Faced
- E-Mail Answers
Answer Posted / manish sharma
After creation of Master Item, Revision and Category
Item Catalog interfaced with reference to item.
Item catalog is defined on Master level only, which is
applicable for all assigned organizations.
For Catalog Interface, MTL_DESC_ELEM_VAL_INTERFACE
interface table is used then interface the data to Base
Table MTL_DESCR_ELEMENT_VALES with reference to Master Item.
Columns for Catalog Interfacing are :
INVENTORY_ITEM_ID, ELEMENT_NAME, ELEMENT_VALUE, REQUEST_ID,
PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
DEFAULT_ELEMENT_FLAG, ELEMENT_SEQUENCE, TRANSACTION_ID,
PROCESS_FLAG, ITEM_NUMBER, SET_PROCESS_ID including Who
columns.
Mandatory column is Set_Process_Id as per oracle standard.
The other Required columns are :
ELEMENT_NAME, ELEMENT_VALUE, , ELEMENT_SEQUENCE,
DEFAULT_ELEMENT_FLAG, PROCESS_FLAG,
ITEM_NUMBER ,INVENTORY_ITEM_ID.
Once data is populated in interface table then it moves in
Base table through API INVPPRCI.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Oracle report builder 6i is view based then what about report builder 10g?
Tell me is there a way to update schedule ship date for all lines of so in one go?
Where to find the ISO accounting entry details?
Hi Guys, I am looking for Oracle Apps SCM/Finance Functional Training in Bangalore. Please suggest me or Guide me
What is the use of ADD to RECEIPT FILED in receipt localized? Then how to performing in SOURCE TYPE INTERNAL AND EXTERNAL?
Navigation to change the serial numbers from Shipping Transaction form.
Can you pls provide the interview questions on oracle apps SCM.including ASCP module.
What is the use of LC? How is it useful in export sales?
In order management, how to reserve an item without booking?
In India Localization how are generating Excise and VAT Invoice number both shippable and non-shippable Sales Orders/Transactions.
What is the use of INV-Receipts and PO-Reciepts,Just give me the Differences&When,At what Instances to use Them...?
How do i generate Taxes when i'm doing Return To Vendor Transaction?
Explain difference between discrete mfg and process manufacturing?
What are the FAQ's asked Functional consultants in SCM ? If any one knows please send.
can u send me the supporting issues in oracle apps scm functional such as inventory,purchasing and order management
