若Receiving Transaction 在處理過程中有任何異常現象的話, 會將資料寫入 RCV_TRANSACTIONS_INTERFACE table 中, 且顯示在 Transaction Status Summary Form 中, 其狀況有: (A). Status = 'PENDING': 其原因不明,可能是在做收料交易時,系統較為繁忙所致,此部分 Oracle 亦無法提出較明確的 Problem Define,當其發...
Object type: TABLE Tablespace: INTERFACE Primary Key NameColumns CMR_I_RCV_TRANSACTIONS_PK EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID Columns EXTERNAL_SYSTEM_REFERENCEVARCHAR260YesIdentifies the external source system. FISCAL_DOC_ACCESS_KNUMVARCHAR264Fiscal document access key number. ...
Object type: TABLE Tablespace: Default Primary Key NameColumns CMR_RCV_TRANSACTIONS_I_GT_PK CMR_RCV_TRANSACTION_ID Columns CMR_RCV_TRANSACTION_IDNUMBER18YesSurrogate key - Internal Receiving Transaction Unique Identifier EXTERNAL_SYSTEM_REFERENCEVARCHAR260YesIdentifies the external source system. ...
the following error occurs The Quantity entered for receipt is greater than the available Quantity. The sum of quantity to be received and already received, 1, is greater than the sum of ordered quantity and over receipt tolerance, 0. Steps 1. Record in RCV_TRANSACTIONS_INTERFACE table has I...
ERROR---The value specified XXXXXX is invalid. (COLUMN=ITEM_NUM) on column ITEM_NUMSTEPS---a. Use Receiving Open Interface ROI features to populate ROI interface tables RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE. make sure ITEM_NUM is populated.b. Run Receiving Transaction Processor....
EVENT_TXN_TABLE_NAME VARCHAR2 30 Stores transaction event creation source transaction table name. EVENT_TRANSACTION_ID NUMBER 18 This column identifies Transaction Event ID. TRANSACTION_REVERSAL_FLAG VARCHAR2 1 Transaction reversal flag for period end accrual transactions. PJC_TXN_STATUS_CODE VARCHAR2 ...
RCV_PARAMETERS stores receiving options for each organization in which you want to be able to receive items. The table contains one row for each organization.
RCV_HEADERS_INTERFACE HEADER_INTERFACE_ID 469044GROUP_ID 100PROCESSING_STATUS_CODE ERRORRECEIPT_SOURCE_CODE VENDORASN_TYPETRANSACTION_TYPE NEWRECEIPT_NUM NullRECEIPT_HEADER_ID NullVENDOR_ID 57062SHIP_TO_ORGANIZATION_ID 572 VALIDATION_FLAG YORG_ID 428RCV_TRANSACTIONS_INTERFACE INTERFACE_TRANSACTION_ID ...
The SQL error is User-Defined Exception. Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.ERROR_MESSAGE_NAME PO_ALL_SQL_ERRORTABLE_NAME RCV_TRANSACTIONS_INTERFACEBATCH_ID 186919INTERFACE_HEADER_ID 24120...
6.1.1.3Application Table Update When you run Inbound Edit/Update for request for quotation documents, the program copies the data from the EDI inbound interface tables and updates these application tables in the JD Edwards EnterpriseOne Sales Order Management system: ...