what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
REFER Item Import open interface in mfgapi user guide
Is This Answer Correct ? | 1 Yes | 1 No |
Once the SO was booked, the line status changed to ‘Closed. What could be the cause?
If owner wants to self approve then what the set-ups required?
How to Raise SR to Oracle?
How move Order Number is generated? I know it is Displayed Automatically,But i want to know How it is generated&any SETUP is required??? Regards, Santhosh
what is the purpose of item master organisations? can we define more than one item master?
May i know some of the real time issues we face in oracle purchasing, inventory and Order Management.
in what case consultant will suggest for more than one operating unit, reasons?
If owner wants to self approve then what the set-ups required?
Oracle report builder 6i is view based then what about report builder 10g?
how do you change the control level for item attributes from master level to organization level for example?? when i try to change this in the attribute control form, I got the message :frm-40200: field protected against update..
how do i change an item's UOM????
WHAT ARE THE DIFF TYPES OF CALENDERS IN R12 ??? PLS EXPLAIN THEIR FEATURES ????