Home » Applications » Oracle Fusion Apps & E-Business Suite » Sample script to import releases for a blanket PO
Sample script to import releases for a blanket PO [message #253308] Mon, 23 July 2007 07:55 Go to next message
s_karthik215
Messages: 4
Registered: April 2007
Location: Chennai
Junior Member
Hi,
I want to import releases against a blanket Purchase order
which is created by oracle Purchasing.
can i know the mandatory columns in PO interface tables with Lookup values.

is there any API's to do this?

Rgds,
Karthik
Re: need Sample script to import releases for a blanket PO? [message #253441 is a reply to message #253308] Tue, 24 July 2007 00:03 Go to previous messageGo to next message
s_karthik215
Messages: 4
Registered: April 2007
Location: Chennai
Junior Member
Hi,
1.how can i import blanket purchase agreements?
what is the interface program to do this?

2.how can in import only releases for a blanket PO?
what is the interface program to do this?

guys help me out in solving this..


Karthik.
Re: Sample script to import releases for a blanket PO [message #253659 is a reply to message #253308] Tue, 24 July 2007 09:39 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi Karthik,
i have tried in other way to relase the blanket.
load all the data in requitision interface table with approved status then u run the create release program it will release by refering the blanket agreement.
but before running create release
your
1. approved supplier list
2. sourcing rule
3. Assign sourcing rule,
4. MRP Default assifnment set(Profile option) should be assigned
then only your release will happen automaticaly

Regards,
Ananth
Re: Sample script to import releases for a blanket PO [message #253699 is a reply to message #253659] Tue, 24 July 2007 11:28 Go to previous messageGo to next message
s_karthik215
Messages: 4
Registered: April 2007
Location: Chennai
Junior Member
Hi,

thank u Ananth.

My requirement is, from a 3rd party system i am importing time data(i.e., quantity for a service PO). And we will be having a
blanket purchase order and each time this data comes we have to create releases using this time data.

Rgds,
Karthik
Re: Sample script to import releases for a blanket PO [message #254627 is a reply to message #253699] Fri, 27 July 2007 05:24 Go to previous message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi Karthick,

I understod ur process wel,
the better way is load the release information in requisition interface.
then import the requistion by fixing the group by itemwise.
and for releasing u have to difine asl, sourching rule and assign sourcing rule then ur release will happen automaticaly one u import the requisition



Regards,
B.T.S.Ananth
Previous Topic: Question on Purchasing
Next Topic: who can help me
Goto Forum:
  


Current Time: Wed Jul 03 02:33:19 CDT 2024