How to create Sourcing Rule & ASL Automatically

For your Info...

Ref : Oracle Support Document 1533918.1 (Vision Demo - How To Create ASL and Sourcing Rules from Blanket Agreements) can be found at: -https://support.oracle.com/epmos/faces/DocumentDisplay?id=1533918.1
---------------------

If Update Existing Sourcing Rule/Assignment is checked and if Sourcing Rule is assigned to only one item, new lines will be added to an existing ASL Entry or Sourcing Rule as per the Rules defined in the Business Rules section.

When a new blanket agreement is approved, or when an existing blanket has new lines added that causes the blanket to be re-approved, the Approval workflow, based on the options selected on the Approval Window, will spawn a background workflow process called Create Sourcing Rules Workflow that will automate the following :

When new lines are added to an existing blanket - only the new lines will be considered for the automated updates below. These new lines will be determined as lines created since the last archive event. New lines will NOT be added to an existing ASL if the document number is already referenced on the ASL. Also Sourcing Rule Creation options will be enabled only if Archive mode is set to Archive on Approve.

Solution

There was a limitation to the Create and Update Existing Sourcing Rule/Assignment in the approval process. Oracle provided an enhanced mechanism to create and update sourcing rules which is a concurrent program called "Generate Sourcing Rules and ASLs from Blanket Agreements".

The sourcing rule will be updated only if all the four conditions are true

• The effective start date of the Blanket Agreement is not before the from date of the sourcing rule. 
• The effective start date of the Blanket Agreement is greater or equal to the from date of sourcing rule and  the effective end date of the Blanket Agreement is after the end date of the sourcing rule. 
• There is only one Vendor / Vendor Site for that effectivity date range for  the sourcing rule and it is the same as the Blanket Agreement.
• The effective end date of the Blanket Agreement does not overlap in another effectivity date range for the same sourcing rule.