Dear Friend ,    Lets Understand how to Configure an approval rule to route a notification using a supervisory hierarchy using Business Process Management(BPM)  Lets take an Business use case that The business requirement is that an invoice needs to be approved by managers based on the amount limits set for each approver.  Example  An invoice amount of more than $10,000 dollars needs the approval of two groups. The first group is made up of the Manager, Senior Manager, and Finance Manager. The invoice can be approved by the next group of approvers. That approval group consists of the CFO, COO, and CEO. If the invoice amount is less than $10,000 dollars it only needs to be approved by the Manager, Senior Manager, and Finance Manager depending on the invoice amount.  Lets consider Below Table The first three approvals are done by the managers of the invoice requestor using supervisory hierarchy.  Final approval has to be done by any one of the approver out of 3 approvers from appr

How to Customize Configure an approval rule to route a notification to a group of approvers using Business Process Management(BPM) The business requirement is that all invoices related to the operating expenditures incurred needs to be reviewed by two approvers. The invoice first needs to be reviewed and approved by the Payables Department head and then needs to be approved by the Finance Manager. The nature of the expenditure is based on the natural account entered on the invoice. Example: An invoice is received for the expenditure incurred related to a marketing event: If the account code combination entered on the invoice contains the natural accounts ranges from 512001 to 512099 then invoice requires the approval from the Payables Department head and the Finance Manager. If the account code combination entered on the invoice does not contain the natural accounts ranges from 512001 to 512099 then invoice requires the approval from the Payables Department head. Solution:

 Dear Friends , Here is some important query to Extract all BIP reports which are currently scheduled in ESS jobs in Oracle Application Cloud . You can create a BIP Report and get the details . SELECT r.requestid ,r.REQUESTEDSTART ,r.processstart ,r.processend ,r.executable_status ,v.name property_name ,vtwo.value report_params ,vthree.value report_url --,extractValue(xmlparse(content v.value), '/PARAMETER1') as param1 ,regexp_replace(regexp_substr(v.value, '<PARAMETER1>.*</PARAMETER1>'), '(<PARAMETER1>)(.*)(</PARAMETER1>)', '\2') to_email ,regexp_replace(regexp_substr(v.value, '<PARAMETER2>.*</PARAMETER2>'), '(<PARAMETER2>)(.*)(</PARAMETER2>)', '\2') cc ,regexp_replace(regexp_substr(v.value, '<PARAMETER5>.*</PARAMETER5>'), '(<PARAMETER5>)(.*)(</PARAMETER5>)', '\2') message ,regexp_replace(regexp_substr(v.value,