Home » Applications » Oracle Fusion Apps & E-Business Suite » Custom Report creation for Invoices on hold (Oracle R12)
Custom Report creation for Invoices on hold [message #407132] Mon, 08 June 2009 11:15 Go to next message
jayaharan76
Messages: 62
Registered: June 2006
Location: BANGALORE
Member

Hi,

I have an requirement to create a custom report which provides the info abt invoices which are on hold in Accounts Payables.


Invoices are placed on hold by the workflow by the condition " No Purchase Order = No Pay ".

Could anyone has worked on the above custom report, please share some insights.

Reg,
Jay

Re: Custom Report creation for Invoices on hold [message #407141 is a reply to message #407132] Mon, 08 June 2009 11:52 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
Invoices are placed on hold by the workflow by the condition " No Purchase Order = No Pay ".
I'm not sure about this one.

But you can get the invoices, which are on hold by looking at the following tables.
ap_invoices_all
ap_holds_all

By
Vamsi
Re: Custom Report creation for Invoices on hold [message #407190 is a reply to message #407141] Tue, 09 June 2009 00:53 Go to previous message
jayaharan76
Messages: 62
Registered: June 2006
Location: BANGALORE
Member

Thanks for your Reply ..

First of all wanted to know about the following setups
1) setting up of Hold for AP Invoices
Have done through (N) AP > Setup > Invoice > Hold and
Release Names & checked the "Initiate WF" options in Hold
Workflow options.

-- Is this setup enough to get the notification for Hold WF ?

2) Once the Hold applied to the invoice. Notification need to be sent to Buyer / whoever it is .. what are all the concurrent programs need to schedulded ?

Thanks, Jay
Previous Topic: Oracle EAM Changes in R12+
Next Topic: As of Inventory Reporting
Goto Forum:
  


Current Time: Tue Dec 06 10:26:46 CST 2016

Total time taken to generate the page: 0.09645 seconds