Thursday, April 28, 2011

Payables Hold Release Workflow

In R12 Oracle Payables integrates with Oracle Workflow to provide a resolution of user releasable holds through workflow. A new transaction type called “Payables Hold Resolution” (APHLD) in AME has been introduced in R12 for the same. There has been a business requirement to release the AP invoice holds, especially the matching holds based on an approval mechanism. In R12 of Payables, this feature has been provided so that, we can send the invoice lines on hold to approvers before the hold is released. As usual the seeded AME objects can be extended to accommodate different approval groups, rules and other business conditions before the hold is released.

Following setup needs to be done at Payables level: Setup > Invoice > Hold and Release Names.

The Initiate Workflow option is selected for the hold type in the Hold and Release Names window.

The hold is setup to be user releasable

Notify After X Days: The Notify After X days setup, will cause the notification to be sent to the approver after X days of the hold being placed.

Remind After X Days: The Remind after X days will cause a reminder to be sent to the appover after X days of the first notification, and subsequently, if no action is taken.

At AME setup Level, for the Transaction Type: Payables Holds Resolution setup Attribute, Condition, Action types, Approver groups and Rules

1. Choose the Default/seeded Attribute existed for Hold Look Up Code as shown below

2. E.g. Use the seeded Condition by assigning Hold Look Up Code with String values “Amt Ord, Amt Rec, Price, Qty Ord, Qty Rec” as below: 3. Create an Custom Approver group ‘Demo1’ by choosing “Serial” Voting method assign with Static to generate Invoice Hold notifications and send for release to approvers on basis of below logic 4 Assign this Approval group to the action type.
Create a Rule for this Hold notification and assign above Condition and Action type to the Rule as shown below:

Steps to Release the Hold:

1. Validate invoice on matching hold like “Amt Ord, Amt Rec, Price, Qty Ord, Qty Rec”

2. A notification will be sent to the approver for hold release

3. Once the Approver clicks on “Release Hold”, the hold gets released from the invoice.


Prateek said...

Hello Krishanu,

Your blog on Workflow is quite informative.

We're a reputed corporate learning solutions provider, with pan India presence. We might have an exciting corporate training assignment for you on Oracle Apps Technical.

Let me know should you be interested.


Prateek - prateek[at]ivyproschool[dot]com

ascencion rana said...

Thank you for sharing to us.there are many person searching about that now they will find enough resources by your post.I would like to join your blog anyway so please continue sharing with us.Oracle SQL

Le Mystique said...

Hi! I am a digital marketer. The previous seo guy working for my client has left a spammy comment at your blog with the username ascencion rana which links to my client's site.
Such comments are causing serious damage to my client's site with respect to SEO which is why I am request you here by to remove it asap.
If you don't remove it by 11:59 pm, Pacific Standard Time, 3rd January 2014, we will have use Google's Disavow Tool to get back-link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment.
Thanks in advance for your cooperation.

Sridevi Koduru said...

I am Sridevi Koduru, Senior Oracle Apps Trainer at With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at | | +91-9581017828 |

Linkedin profile -

Michelle Caringal said...

Hi Krishanu,
Good day!

I am currently enabling the workflow for AP Release Hold, is there a way to use this and disable the release hold under the user level? On the testing I have done after the setup as per your blog, the workflow is just parallel with the release hold of the user. Once the user release the hold, the approval is no longer needed from the approver.

Thanks and Best Regards,
Michelle Caringal

Oracle Fusion said...

you have clearly explained about the process thus it is very much interesting and i got more information from your blog.For additional information please visit our website. Oracle Fusion SCM Online Training

Erptree Oracle said...

Thanks for your Quality information the product developed by thecompany is perfect.Thanks for giving such a wonderful blog.Oracle Financials Training in Ameerpet

krish said...

HI Krishna,

i wanted to customise the Holds workflow to add new button to reject and the status should be updated in ap invoices table as REJECTED. to add button i have to customize ap_holds_pkg and ap_workflow package as i need to create new process and to make it work i have to add the new process over there.
is there any way to make it work other than customising standard


Pradeep Ogen said...

Lifestyle Magazine

Pradeep Ogen said...

Colored Packing Tape Manufacturer in Delhi

Pradeep Ogen said...

tile bonder manufacturer in delhi

Veav by nimisha priya said...

Nice..Thanks for sharing this post.
indo western designer outfits

Amandeep Kaur said...

Nice post.
SEO Company in Delhi

Y and H Cargo India said...

Thanks for sharing an amazing post.
Sea Freight Company in India

Mobile app development company in toronto said...

Visit here

sachindigitalplanner said...

fridge repair in faridabad
Bosch Fridge Repair in Faridabad
Godrej Fridge Repair in Faridabad

sachindigitalplanner said...

we have provide the best ppc service in Gurgaon.
ppc company in gurgaon
website designing company in Gurgaon

sachindigitalplanner said...

Rice Packaging Bags Manufacturers
Pouch Manufacturers

Digital Marketing Company in Delhi said...

I am always eager to catch hold of the new posts being published on your website, because of this i use to updated, thanks for sharing this wonderful article.
Digital Marketing Company in Delhi
SEO Company in Delhi
Mobile App Development Company in Lucknow

Peptide Synthesis said...

Thanks for providing such a great Information, you can see, we also provide
Peptide Synthesis

Digital Planner said...

iso certification in noida
iso certification in delhi
Halal Certification in Delhi
haccp certification in delhi

Digital Planner said...

pouch manufacturers
wall putty bag manufacturers

Mobile app development company in Mumbai said...

Mobile app development company in Navi mumbai

About Me

My photo
Krishanu's Oracle Applications Blog - Oracle Apps consulting services scenario in India. Also, an inside view of Oracle Apps outsource services in India. Also the blog features new developments in Oracle Apps and my learning's in this field. The views expressed are my own only and not of my employer Wipro Technologies. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.