Wednesday, November 23, 2011

OE_PROCESSING_MSGS

Order Management
Table Or View: Table

Important columns: 
  1. TRANSACTION_ID : System Generated Id 
  2. HEADER_ID NUMBER : This holds the header id against which the message is logged 
  3. LINE_ID NUMBER :  This holds the Line id against which the message is logged 
  4. ORIGINAL_SYS_DOCUMENT_REF :  This holds the order header source. Will be used for Order Import
  5. ORIGINAL_SYS_DOCUMENT_LINE_REF : This holds the order Line source. Will be used for Order Import
  6. SOURCE_DOCUMENT_ID :  This holds the source header id. Can be used to join OE_HEADERS_IFACE_ALL with column org_sys_document_ref
  7. SOURCE_DOCUMENT_LINE_ID : This holds the source Line id
  8. ORDER_SOURCE_ID : This holds the order source. Will be used for Order Import
Description: 
This table stores the context information of the processing messages that will be generated during Order Entry concurrent program execution or UI process.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect