OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to unapply AR Receipt partially ( Which API to use)

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to unapply AR Receipt partially ( Which API to use)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to unapply AR Receipt partially ( Which API to use) [message #329056]

Mon, 23 June 2008 23:27

surfraz
Messages: 8
Registered: December 2005
Location: KOLKATA

Junior Member

Hi All,

how to unapply a AR receipt against invoice partially .
Say Invoice has only one line and invoice amount = 100 Rs and this invoice has receipt for 100 Rs.
Now i want to unapply this receipt for amount say Rs.50( Partially ).

I can very well do this from Front end by just going to Receipt and update the amount field.Can you please tell me which API i need to use to do the samething.

I tried of using api ar_receipt_api_pub.unapply ...but this API is fully unapplying the amount.but i want partial unapply.

Thanks in Advance
Surfraz

[Updated on: Tue, 24 June 2008 01:36]

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #329206 is a reply to message #329056]

Tue, 24 June 2008 09:04

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

there is no public api to do that (which means that your code will not be supported). But you can use the procedures in ARP_PROCESS_APPLICATION.

Regards,

Arian

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463080 is a reply to message #329206]

Tue, 29 June 2010 11:32

OracleAPPS001
Messages: 5
Registered: June 2010
Location: TEXAS

Junior Member

Which procedure in the ARP_PROCESS_APPLICATION package can be used to achieve this?Thanks for any help on this?
Surfraz would you acomplish this?

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463476 is a reply to message #463080]

Thu, 01 July 2010 08:53

SSGKK
Messages: 19
Registered: March 2009

Junior Member

Other option would be unapply fully using ar_receipt_api_pub.unapply and the re-apply using ar_receipt_api_pub.apply for partial amount.

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463490 is a reply to message #329056]

Thu, 01 July 2010 09:28

OracleAPPS001
Messages: 5
Registered: June 2010
Location: TEXAS

Junior Member

Thank you for responding.If the api_process_application package does not work, then I was in the assumption to implement the one you mentioned.

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463550 is a reply to message #463490]

Thu, 01 July 2010 15:41

Alien
Messages: 292
Registered: June 1999

Senior Member

Wow. This is a very old post.
When I wrote the reply it was either an 11.0 or 11.5 system. In either of those versions, a procedure in arp_process_application accepted the amount.
Now I only have a 12i database, and I see the parameters have changed.

If you have an 11i system, you'll have to desc the package to see which procedure you need.

I think the safest option is to go with SSGKK's solution.

Regards,

Arian

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463554 is a reply to message #463550]

Thu, 01 July 2010 15:58

OracleAPPS001
Messages: 5
Registered: June 2010
Location: TEXAS

Junior Member

Thanks Arian for responding.

I attached a copy of the 11i pkg.Can you check and let me know if possible.Thanks for any help on this.

Attachment: arp_process_application_pkg_spec.sql
(Size: 385.78KB, Downloaded 2766 times)

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463555 is a reply to message #329056]

Thu, 01 July 2010 15:59

OracleAPPS001
Messages: 5
Registered: June 2010
Location: TEXAS

Junior Member

Here is the Body of the pkg.

Attachment: arp_process_application_pkg.sql
(Size: 385.78KB, Downloaded 3266 times)

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463557 is a reply to message #463555]

Thu, 01 July 2010 16:22

Alien
Messages: 292
Registered: June 1999

Senior Member

Ok. I remember the package again.

I'm sorry, but you have a later version already. The version that I used had an amount parameter in the reverse procedure and a different opposition procedure.

With this version, only the full amount can be reversed.

Regards,

Arian

Report message to a moderator

Re: how to unapply AR Receipt partially ( Which API to use) [message #463558 is a reply to message #463557]

Thu, 01 July 2010 16:27

OracleAPPS001
Messages: 5
Registered: June 2010
Location: TEXAS

Junior Member

Thanks Arain.

Report message to a moderator

Previous Topic:	Migration Help from 32-bit to 64 bit EBS
Next Topic:	Cost Rollup- No Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:43:31 CDT 2024