My Oracle Support Banner

Questions About Resource Transactions and Step Completion Process (Doc ID 2596719.1)

Last updated on OCTOBER 07, 2019

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.4 and later
Information in this document applies to any platform.


We want to know the relationship between Operation Step Completion and Resource Transaction. What happens when we complete the operation step? Below are our observation and the queries associated to those observations.
1. When we release a operation step, the actual start date gets stamped on the activities and the resources. Along with this, an incomplete resource transaction gets created. Where is this transaction stored? In gme_resource_txns_gtmp? If so, then when does this data go into the table gme_resource_txns.
2. The incomplete transaction is as per the planned dates. However if we enter any completed resource transactions manually and then complete the operation, we see that the incomplete transaction is removed and the completed transactions are moved to gme_resource_txns. How does the system understand which resource transactions to remove and which transactions to transfer to gme_resource_txns?
3. There are at times, we have seen that if we forget to enter resource transactions manually and close the operation, default completed resource transactions does not get passed by the system. For some organizations it does and for some it does not. Can you please explain what might influence such behavior?
4. Suppose we have 5 resources in an activity – 1 primary and other 4 auxiliary. We will always enter the resource transaction for the primary but for the other 4 resources; we may not enter the resource transactions for all the 4. From #3 above, we know that system allows closing operation without passing a resource transaction for a particular resource and neither the system passes one. Can you please suggest which configuration influences this behavior?
5. If we want to simulate the function of the standard operation completion using API, which are the API we should use.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.