1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Autoinvoice Master program detachment from Workflow Background Process

Discussion in 'Oracle CRM' started by Bharat, Apr 5, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Iam creating sales order using Order Management Super User, Vision Operations(USA) and trying to close the order. But it is closing and automatically invoice is created. Here Autoinvoice Master Program , and Autoinvoice Import Program these two are getting submitted automatically after workflow background process is completed. Can anyone tell me how to detach autoinvoice master program from workflow background process.
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Bharat,

    Check the programs scheduled to run and the intervals. I am curious to know what they do in the event of errors? If you do not have sysadmin check with the DBA team.
    Rgds
    Ramji

    Sorry Just saw it was vision Instance. Not sure what the setup is in there. But I was talking about Pdn environs.
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    There is no any scheduling done for them. Just when Iam running workflow background process those two programs(Autoinvoice Master Program, Autoinvoice Import Program) were running automatically. There is no scheduling exists for them and it is not a request set too. Iam submitting a single request as workflow background process.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Anyone please guide me on this issue.
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Anyone please guide me on this issue.
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Solution for the problem is : try to disable ADS_RA_INTERFACE_TRG1 trigger. Then invoice is not created when we run workflow background process program.
     
  7. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Thanks for the info.
    cheers
    Ramji
     
  8. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji bhai,

    In all Vision instances I have faced same kind of problem. I think who are using vision instance can get same kind of problem, so make below changes to overcome the problem.
     
  9. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharat,

    Pls Post a How To document with screenshots so everyone will benefit. Whenever you do something share m8.
    Ramji
     
  10. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Thanks ramji.. shortly I will add it. Weekend right so bit busy with other work. :D