Oracle Workflow Background CP Process

-

Here I will provide some more insight on Oracle Workflow background process from the prospect of Order Management.


Workflow background process is very interesting concurrent program. This program is designed to process the workflow, which is in DEFERRED status.
Most of the time this concurrent program is executed in scheduled manner says 5 , 10, 15 and a required minutes. 
Customer should not stop executing this program if they have workflow which as DEFERRED activity in the workflow. Because doing will results in of hundred or thousands (depend on business 2 business) of records STUCK in deferred status and once you resume execution of this process again it will really take time to clear the backlog and that might really affect/impact your business.
In case there is some issue with this process you should act immediately.

Many a time this type of situation is unavoidable and you have to end up with killing this concurrent program and no running it for hours and days. Now how to handle the backlog once you start executing this process, best and safe option is to increase the # of threads of this concurrent program to 3-5 and be little patient. If you have large amount of inflow of the data which then clearing of backlog is really very painful, but you have to be patient, because there are only few shortcuts available and they are not safe.

Running multiple threads of this program may result in LOCKING issue, usually it happened if you have > 4 threads, so safe bet is 4 threads, but if required increase the threads.
# of threads doesn’t matter if you have only STANDARD item , in that case you can start 5-6 threads , but if you have Model/Fulfillment set then locking issue do occurred (please note that locking will be resolved very much by this process).if system will not be able to lock the model/fulfillment set then they mark the record as DEFERRED and start processing the next record

Comments

  1. Unknown15 July 2016 at 23:59

    This comment has been removed by the author.

    ReplyDelete
  2. Unknown30 March 2017 at 03:47

    I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle E-Business Functional Workflow for R12
    , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle 11g. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com



    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Purchasing Module Step by Step in R12

-
Image
PURCHASING  All the Purchasing related activity information will be declared in Purchasing              Procure 2 Pay Cycle : Requisition à RFQ à Quotation à Quotation Analysis à Purchasing à Receiving à Invoice  à  Payment à Reconciliation PO-Integration :  PO  is integrated by GL, AP, I Supplier, Procurement, and Project Accounting  PO  Responsibility             Step1: Define  PO  Responsibility                         Nav: System administrator à Security à Responsibility à Define             Step2: Assign  PO  options to the PO Responsibility                 ...
Read more

Sub Ledger Accounting SLA (Complete Functional Information)

-
Image
SubLegder Accounting in R12 SLA Part -1 In these article, we will explore the very basics of SLA and why it exists. Firstly, what exactly does SLA do? SLA is a module which now sits between the SubLedgers like AP/AR etc and the General Ledger. Have a look at this diagram below.  As you will notice, SLA can act as a mediator between the subledgers and Oracle General Ledger. Before we progress, some terminologies of R12 must be revisited. In 11i we had set of books, and in R12 we call them Ledgers. Likewise in R12 we also have secondary ledgers and reporting ledgers. Hence from 11i perspective think of Ledger as Set of Books. As for Subledger, a Subledger is nothing but a module like AP/AR/PO/Inventory etc. In the diagram below, the second scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is not customized, then the very same A.B.C.D ...
Read more

Difference between ATO and PTO in oracle apps

-
Difference between ATO and PTO in oracle apps 1) MAKE TO ORDER: This is based on Customer specification, you make the product and supply it to them. This is applicable for Engineering items or any Product which you can make based on Customer order Example: Engineering Items 2) ASSEMBLE TO ORDER: This is you have items in parts and it needs to be assembled according to customer requirements For example you have Laptop coming with standard configuration of 160GB Hard disk and 1 GB RAM. But there are customer orders coming in asking for 200GB Hard Disk and 2 GB RAM and if you can assemble them to suit Customer Requirement 3) CONFIGURE TO ORDER: This is Configuring the Product itself to suit Customer requirements Example. The Thread Manufacturing unit Machineries are configured. I have seen Laxmi Machine Works in INDIA which manufactures textile Machineries configure the machineries based on No.of spindles 4) PICK TO ORDER: This is same as Computer Example in ATO. But the  differenc...
Read more