Error Message 3146 Commit Happened In Activity/function
Contents |
» Understanding Workflow Errors - Part 1 By Vijay Shanmugam-Oracle on Apr 12, 2013 Workflow Engine and other public APIs throw a wfeng_commit_inside variety of user-defined exceptions to indicate specific Engine conditions. It is important
Oracle Support
that Workflow Developers and Administrators understand the meaning of these errors and know how to deal with them. In this post, we will cover some of the important Workflow Engine related errors and understand how to deal with them. Engine Errors 3122: Duplicate item 'ITEM_TYPE/ITEM_KEY' could not be created Error Code: WFENG_ITEM_UNIQUE Cause: This error may be thrown from WF_ENGINE.CreateProcess when you attempt to create a new instance of a workflow item. This error indicates that the Item Type and Item Key combination you have used to launch a new workflow instance already exists. Fix: Use an unique item key for that item type 3136: Item 'ITEM_TYPE/ITEM_KEY' cannot be accessed while synchronous process in progress. Error Code: WFENG_SYNCH_ITEM Cause: This error may be thrown from WF_ENGINE.CreateProcess when attempt to create a new synchronous workflow instance while another synchronous workflow instance is already running in the same session. All synchronous workflow instances are created with item key #SYNCH to make sure the workflow instances starts and completes in the same session. Fix: Wait till the existing synchronous workflow instance completes before creating another one. 3146: Commit happened in activity/function 'ACTIVITY/FUNCTION' Error Code: WFENG_COMMIT_INSIDE Cause: While a workflow instance was executing, a commit was issued inside a PLSQL procedure associated to a workflow function activity before or after an error occurred in that PLSQL procedure. The Workflow Engine traps errors produced by function activities by setting a savepoint before each function activity. If an activity produces an unhandled exception, the engine performs a rollback to the savepoint, and sets the activity to the ERROR status. Fix: You should never commit wit
to friend (WF )- Error Name = WFENG_COMMIT_INSIDE [message #536777] Thu, 22 December 2011 19:07 mazenmohye Messages: 1Registered: December 2011 Location: EGYPT Junior Member I HAVE ERROR IN WORK FLOW (Oracle APPS ERB11I) An Error occurred in the following Workflow. Item Type = XX_MOZA Item Key = 58 User Key = Error Name = WFENG_COMMIT_INSIDE https://blogs.oracle.com/oracleworkflow/entry/understanding_workflow_errors_part_1 Error Message = 3146: Commit happened in activity/function 'VAC_PROCESS:XX_MMM/WFVACWH.UPDATE_ABSC' What is the solution for this problem ?? I hope to help me Report message to a moderator Previous Topic: Reset SYSADMIN password Next Topic: SSHR Issue Goto Forum: - http://www.orafaq.com/forum/t/177526/ SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current Time: Thu Oct 13 20:59:30 CDT 2016 Total time taken to generate the page: 0.16840 seconds .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.
"APPS.HR_TRANSACTION_WEB" ORA-06508: PL/SQL: could not find program unit being called.Resolution:The cause for this is the SGA (memory that is allocated by an http://arunrathod.blogspot.com/2008/06/workflow.html Oracle Instance and is shared among Oracle processes). Any object in http://zahidrahimocp.blogspot.com/2014/12/work-flow-builder-error-messages.html?m=0 SGA referencing an object that is compiled become invalid during this compilation. So in this case the process accessing the compiled object needs to be restarted. For example, in case of Oracle Workflows, this error can be rectified by restarting the Workflow error message Mailer ( or a Retry also helps). One more way is to bounce the database itself which ofcourse will be a last resort.WorkaroundThe invalid object needs to be recompiled to become valid again. Oracle 10g includes a mechanism to recompile some invalid objects when they are accessed for the first time. However, error message 3146 this mechanism does not always work and errors of this sort can occur. If this error is encountered, the invalid packages and any invalid type bodies can be maually recompiled. Be sure to start a new Oracle session after recompiling before verifying the recompiling solved the problem. To find invalid objects owned by the user SDE, connect to Oracle with SQL*PLus and execute the following statement: SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('PACKAGE', 'PACKAGE BODY', 'TYPE', 'TYPE BODY') AND STATUS = 'INVALID';To recompile a type body, use the following command: ALTER TYPE object_name COMPILE BODY;To recompile a package body, use the following command: ALTER PACKAGE object_name COMPILE BODY;Once the above process is completed and still the issue is not resolved then we need to bounce the instance and restart the workflow process. Error:3146: Commit happened in activity/function 'HR_HRSSA_APPROVED_PRC:HR_COMMIT_TRANSACTION_FCT/HR_TRANSACTION_WEB.COMMIT_TRANSACTION' Resolution:Once we have updated the package we need to bounce the instance and restart the workflo
existing state of has been invalidated ORA-04061: existing state of package Resolution: Tags: Work Flow Builder Error Message Posted by Zahid Rahim at 03:56 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home View mobile version Subscribe to: Post Comments (Atom) About Me Zahid Rahim View my complete profile Blog Archive ► 2016 (14) ► August (1) ► April (2) ► March (7) ► February (3) ► January (1) ► 2015 (19) ► October (1) ► September (4) ► August (1) ► July (1) ► June (1) ► May (2) ► March (4) ► February (1) ► January (4) ▼ 2014 (29) ▼ December (6) Oracle Cash Management Configuration oci_connect() ora-06413 Deploy Oracle EBS OAF Page on Server Error: JSP files must reside in the server root di... Oracle EBusiness Suite script commands Work Flow Builder Error Messages ► November (7) ► September (1) ► August (2) ► July (13) Simple template. Powered by Blogger.