TRANSACTION MODE LOCK FLAG PROCESS FLAG TRANSACTION STATUS i

最新推荐文章于 2022-05-22 09:42:49 发布
原创 最新推荐文章于 2022-05-22 09:42:49 发布 · 211 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文深入解析Oracle应用中交易管理的内部工作原理，包括在线、并发和后台处理模式，以及锁定和进程标志的作用。通过理解不同交易状态的意义，读者将能更有效地管理和解决交易处理中的常见问题。

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)

* For transactions stuck in MMTT
update mtl_material_transactions_temp
set process_flag = 'Y',
lock_flag = NULL ,
Transaction_mode = 3  ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;
 
*For transactions stuck in MTI
update mtl_transactions_interface
set process_flag =  1,
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;


TRANSACTION_MODEMeaningDescription    
NULL or 1Online ProcessingOnline processing is used by the Oracle Applications to immediately process records. This does not require that a concurrent program be run. The Transaction Manager does not process transactions marked for online processing. 
2Concurrent ProcessingTransactions marked as concurrent transaction mode are processed by a dedicated transaction worker to explicitly process a set of transactions. The Transaction Manager does not process transactions marked for concurrent processing. 
3Background ProcessingInterface transactions marked for Background processing will be picked up by the transaction manager polling process and assigned to a transaction worker. These transactions will not be processed unless the transaction manager is running. 
8Internal Processing (Not visible in the pending transactions form)Transaction mode 8 is not a mode normally visible to the user as it is used for internal processing.  Transactions with this mode are not visible in the Pending transactions form. Transaction_mode of 8 is used internally to identify if records came from the interface table to the pending table or came directly into the pending table. 
 
LOCK_FLAGMeaningDescription 
1LockedFlag indicating whether the transaction is locked by the Transaction Manager or Workers.this prevents two different Workers from processing the same transaction; You should always specify ’2’ 
2 or NULL or 'N'NOT Locked 
 
PROCESS_FLAGMeaningDescription 
1 or YReadyTransaction is ready to be processed by the Transaction Manager or Worker (’1’ for ready, ’2’ for not ready); if the transaction fails for some reason, the Transaction Worker sets the value of PROCESS_FLAG to ’3’. 
2 or NULLNOT Ready 
EError     
 


       
TRANSACTION_STATUSMeaning
1 or NullDefault  behavior
2Save  only
3Ready  to process
For Move Order case, As soon as a move order is allocated, a record is inserted into the MTL_MATERIAL_TRANSACTIONS_TEMP table.  The column TRANSACTION_STATUS keeps track of the progress of the move order.

These are the current values for TRANSACTION_STATUS:

STATUS 1 = PENDING
STATUS 2 = ALLOCATED
STATUS 3 = TRANSACTED / This is where went into internal processing and waiting for transaction manager to run if transaction_mode is 3 / background.


转载请注明出处:http://blog.youkuaiyun.com/pan_tian/article/details/7899178

===EOF===

           

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow
这里写图片描述
i.MX6ULL驱动开发 | 13 - Linux SPI 驱动框架
Mculover666的博客（嵌入式）
04-11 1596
Linux SPI 驱动框架分为两部分： SPI总线控制器驱动：SOC的 SPI 控制器外设驱动 SPI设备驱动：基于SPI总线控制器驱动编写，针对具体的SPI从机设备 一、SPI总线控制器驱动 基于platform平台驱动框架，Linux内核将SOC的SPI外设主机功能抽象为 spi_master 结构体。 spi_master 结构体定义在include/linux/spi/spi.h文件中，如下： /** * struct spi_master - interface to SPI master
Linux 设备驱动篇 - I2c设备驱动
热门推荐
fulinux的博客
06-02 1万+
Linux设备驱动篇之I2c设备驱动 fulinux 一、I2C驱动体系 虽然I2C硬件体系结构和协议都很容易理解，但是LinuxI2C驱动体系结构却有相当的复杂度，它主要由3部分组成，即I2C设备驱动、I2C总线驱动和I2C核心。 1．I2C核心 I2C核心是I2c总线和I2c设备驱动的中间枢纽，它以通用的、与平台无关的接口实现了I2C中设备与适配器的沟通，提供了I2C总线驱动和设
mtl_transactions_interface接口表错误代码
weixin_34380948的博客
02-25 513
错误信息1：mtl_transactions_interface,货位段无效 原因：mtl_transactions_interface.locator_id值不正确或为空，或其他异常情况   错误信息2：mtl_transactions_interface,|物料挑库发放和挑库确认流程完成时出现错误，|程序包 INV_Trolin_Util 过程 Query_Rows 中出现错...
TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT
数据库天地
08-23 311
TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP) * For transactions stuck in MMTTupdate mtl_material_transactions_tempset process_flag...
关于mtl_transactions_interface表序列
weixin_33881050的博客
10-16 195
mtl_transactions_interface表的序列正确应该是mtl_material_transactions_s，而不是mtl_transactions_interface_s,前一个是标准的，后一个可能是客制添加的
TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT
kikiwhq的专栏
06-30 667
转载:http://blog.youkuaiyun.com/pan_tian/article/details/7899178 TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP) * For transactions s
/** * @brief Transmit an amount of data in blocking mode. * @param hspi pointer to a SPI_HandleTypeDef structure that contains * the configuration information for SPI module. * @param pData pointer to data buffer * @param Size amount of data to be sent * @param Timeout Timeout duration * @retval HAL status */ HAL_StatusTypeDef HAL_SPI_Transmit(SPI_HandleTypeDef *hspi, uint8_t *pData, uint16_t Size, uint32_t Timeout) { uint32_t tickstart; HAL_StatusTypeDef errorcode = HAL_OK; uint16_t initial_TxXferCount; /* Check Direction parameter */ assert_param(IS_SPI_DIRECTION_2LINES_OR_1LINE(hspi->Init.Direction)); /* Process Locked */ __HAL_LOCK(hspi); /* Init tickstart for timeout management*/ tickstart = HAL_GetTick(); initial_TxXferCount = Size; if (hspi->State != HAL_SPI_STATE_READY) { errorcode = HAL_BUSY; goto error; } if ((pData == NULL) || (Size == 0U)) { errorcode = HAL_ERROR; goto error; } /* Set the transaction information */ hspi->State = HAL_SPI_STATE_BUSY_TX; hspi->ErrorCode = HAL_SPI_ERROR_NONE; hspi->pTxBuffPtr = (uint8_t *)pData; hspi->TxXferSize = Size; hspi->TxXferCount = Size; /*Init field not used in handle to zero */ hspi->pRxBuffPtr = (uint8_t *)NULL; hspi->RxXferSize = 0U; hspi->RxXferCount = 0U; hspi->TxISR = NULL; hspi->RxISR = NULL; /* Configure communication direction : 1Line */ if (hspi->Init.Direction == SPI_DIRECTION_1LINE) { /* Disable SPI Peripheral before set 1Line direction (BIDIOE bit) */ __HAL_SPI_DISABLE(hspi); SPI_1LINE_TX(hspi); } #if (USE_SPI_CRC != 0U) /* Reset CRC Calculation */ if (hspi->Init.CRCCalculation == SPI_CRCCALCULATION_ENABLE) { SPI_RESET_CRC(hspi); } #endif /* USE_SPI_CRC */ /* Check if the SPI is already enabled */ if ((hspi->Instance->CR1 & SPI_CR1_SPE) != SPI_CR1_SPE) { /* Enable SPI peripheral */ __HAL_SPI_ENABLE(hspi); } /* Transmit data in 16 Bit mode */ if (hspi->Init.DataSize == SPI_DATASIZE_16BIT) { if ((hspi->Init.Mode == SPI_MODE_SLAVE) || (initial_TxXferCount == 0x01U)) { hspi->Instance->DR = *((uint16_t *)hspi->pTxBuffPtr); hspi->pTxBuffPtr += sizeof(uint16_t); hspi->TxXferCount--; } /* Transmit data in 16 Bit mode */ while (hspi->TxXferCount > 0U) { /* Wait until TXE flag is set to send data */ if (__HAL_SPI_GET_FLAG(hspi, SPI_FLAG_TXE)) { hspi->Instance->DR = *((uint16_t *)hspi->pTxBuffPtr); hspi->pTxBuffPtr += sizeof(uint16_t); hspi->TxXferCount--; } else { /* Timeout management */ if ((((HAL_GetTick() - tickstart) >= Timeout) && (Timeout != HAL_MAX_DELAY)) || (Timeout == 0U)) { errorcode = HAL_TIMEOUT; goto error; } } } } /* Transmit data in 8 Bit mode */ else { if ((hspi->Init.Mode == SPI_MODE_SLAVE) || (initial_TxXferCount == 0x01U)) { *((__IO uint8_t *)&hspi->Instance->DR) = (*hspi->pTxBuffPtr); hspi->pTxBuffPtr += sizeof(uint8_t); hspi->TxXferCount--; } while (hspi->TxXferCount > 0U) { /* Wait until TXE flag is set to send data */ if (__HAL_SPI_GET_FLAG(hspi, SPI_FLAG_TXE)) { *((__IO uint8_t *)&hspi->Instance->DR) = (*hspi->pTxBuffPtr); hspi->pTxBuffPtr += sizeof(uint8_t); hspi->TxXferCount--; } else { /* Timeout management */ if ((((HAL_GetTick() - tickstart) >= Timeout) && (Timeout != HAL_MAX_DELAY)) || (Timeout == 0U)) { errorcode = HAL_TIMEOUT; goto error; } } } } #if (USE_SPI_CRC != 0U) /* Enable CRC Transmission */ if (hspi->Init.CRCCalculation == SPI_CRCCALCULATION_ENABLE) { SET_BIT(hspi->Instance->CR1, SPI_CR1_CRCNEXT); } #endif /* USE_SPI_CRC */ /* Check the end of the transaction */ if (SPI_EndRxTxTransaction(hspi, Timeout, tickstart) != HAL_OK) { hspi->ErrorCode = HAL_SPI_ERROR_FLAG; } /* Clear overrun flag in 2 Lines communication mode because received is not read */ if (hspi->Init.Direction == SPI_DIRECTION_2LINES) { __HAL_SPI_CLEAR_OVRFLAG(hspi); } if (hspi->ErrorCode != HAL_SPI_ERROR_NONE) { errorcode = HAL_ERROR; } error: hspi->State = HAL_SPI_STATE_READY; /* Process Unlocked */ __HAL_UNLOCK(hspi); return errorcode; }怎么将这段代码改写成标准库函数，同时我只需要其中8位数据传输的功能
06-17
while (SPI_I2S_GetFlagStatus(SPI1, SPI_I2S_FLAG_TXE) == RESET); // 发送数据 SPI_I2S_SendData(SPI1, data); // 等待直到传输完成 while (SPI_I2S_GetFlagStatus(SPI1, SPI_I2S_FLAG_TXE) == RESET); } `...
跟原力一起玩转EOS源码-Push Transaction机制
weixin_43458313的博客
11-13 1174
EOS源码备忘-Push Transaction机制 这里我们讨论EOS Push Transaction 的逻辑，这块EOS与Eosforce实现有一些区别，我们会着重点出。 关于wasm相关的内容我们会有一片专门的文档分析。 我们这里通常将Transaction译做交易，其实这里应该是事务的意思。 Transaction与Action 在EOS中Transaction与Action是最重要的...
INV-TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT
kikiwhq的专栏
10-31 1256
转载请注明出处:http://blog.youkuaiyun.com/pan_tian/article/details/7899178 TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP) * For tra
mtl_transactions_interface接口表错误代码[转]
AlexLiu_2019的博客
05-22 1175
mtl_transactions_interface接口表错误代码[转] 错误信息1：mtl_transactions_interface,货位段无效 原因：mtl_transactions_interface.locator_id值不正确或为空，或其他异常情况 错误信息2：mtl_transactions_interface,|物料挑库发放和挑库确认流程完成时出现错误，|程序包 INV_Trolin_Util 过程 Query_Rows 中出现错误 Pending Transaction.
EBS 表 Mtl_Material_Transactions及相关表说明
biqidaoer的专栏
02-12 6287
事务处理类型Transaction type：“事务处理来源transaction source”、“事务处理动作transaction action”的组合 SELECT Mmt.Transaction_Type_Id ,Mtt.Transaction_Type_Name ,Mmt.Transaction_Source_Type_Id ,Mts.Transaction_Source_Type_Name ,Mmt.Transaction_Action_Id ...
物料事务处理interface与temp解析
weixin_30352645的博客
07-24 345
MTL_TRANSACTIONS_INTERFACE MTL_TRANSACTIONS_INTERFACE is the interface point between non– Inventory applications and the Inventory transaction module. Transaction Manager concurrent pro...
物料事务处理接口表 MTL_TRANSACTIONS_INTERFACE 账户别名使用 及 提示无效的分配账户字段...
weixin_34414196的博客
01-12 756
实例： PROCEDURE MAIN(P_ORGANIZATION_ID NUMBER, P_PERIOD_NAME VARCHAR2, XV_STATUS OUT VARCHAR, XV_MESG OUT VARCHAR2) IS CURSOR L...
Metalink Notes Collection
数据库天地
06-30 689
INV Note 123456.1 Latest 11i Applications Recommended Patch List Note 568012.1:FAQ: Inventory Standard Datafixes Note 438787.1: What are the events passed using Custom library and when do they fir...
HOW TO LINK THE TRANSACTION_SOURCE_ID TO TRANSACTION_SOURCE_TYPE_ID
weixin_34293059的博客
06-01 236
HOW TO LINK THE TRANSACTION_SOURCE_ID TO TRANSACTION_SOURCE_TYPE_ID [ID 987471.1]   修改时间 23-SEP-2010     类型 HOWTO     状态 PUBLISHED   In this Document  Goal  Solution  References ...
Oracle R12采购接收流程(PR-PO-RCV-AP-Payment)
duoerbasilu
07-21 1033
1.Requisitions 路径：Purchasing > Requisitions > Requisitions 请购单的类型只有两种，一种类型是Internal Requisition，用于内部组织间的物料申请；另外一种类型是Purchase Requisition，用于产生PO，对外部供应商的采购申请。 Tables 采购申请主要涉及以下三张表PO_R...
【嵌入式AIoT】系统架构与轻量化模型部署：面向智能家居与工业监测的边缘智能终端实战设计
最新发布
12-21
内容概要：本文系统介绍了嵌入式AIoT应用场景的实战方法与实践路径，涵盖从场景选择、系统架构设计到AI模型部署、通信与数据管理的全流程。重点阐述了嵌入式系统与人工智能、物联网技术的融合，强调在资源受限环境下实现感知、分析与决策一体化的智能终端系统。文章详细解析了感知层、边缘计算层和云端服务层的协同机制，突出边缘侧数据处理与轻量化AI模型优化的重要性，并倡导以实际需求为导向，避免“为AI而AI”的设计误区。同时，强调系统稳定性、远程维护和长期运行能力的建设。; 适合人群：具备嵌入式系统基础、物联网或AI相关背景，有一定开发经验的工程师或工作1-3年的技术研发人员；适用于希望深入理解AIoT系统集成与实战落地的学习者。; 使用场景及目标：①智能家居、工业监测、智慧农业等分布式智能系统开发；②在算力、功耗受限的嵌入式设备上实现AI推理与边缘智能；③构建高效、可靠、可维护的端云协同AIoT系统。; 阅读建议：建议结合实际硬件平台进行项目化学习，边学边练，重点关注系统架构设计、模型优化与通信协议选型，注重整体系统思维的培养，而非仅关注单一技术点。
达梦数据库查看Transaction - trxid lock wait
11-30
达梦数据库中的"Transaction - trxid lock wait"通常是指事务ID (trxid) 相关的锁等待...SELECT transaction_id, status, request_status, mode, lock_info FROM dm81.transaction_log WHERE lock_wait = true; ```
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值