PO Interface

[sree]

Hi,

My requirement is to create PO using API. One of the application is sending me PO details as message queue which we need to dequeue and then need to create PO.

My question starts after dequeue, can I load data in PO interface table using any API and then call API to create PO (like Order Import in Sales Order).

Do we have any standard API to load and create PO in purchasing. Here we are not using EDI.

Any help. Thanks in advance.

Regards,
Sreejit

[anilpassi]

Hi Sree

You need to load data into the interface tables, following which you can call the API.
I dont have exact details of API.
But I do remember seeing this methodology work whereby Requisitions from iProcurment get converted into Purchase Orders.
Even standard functionality dumps data into po_header_interface when converting Requisitions into PO's

Thanks
Anil

[sree]

Hi Anil,

Actually my main requirement is to get the PO detail message from MQ series (another appliaction) to SOA and then create PO in oracle appliaction.

So what I am planning is to get the details and insert it into PO interface table and then call the standard program. I am also trying to use SOA apps adaptor if it can help me to import the data to interface table and call the conc program (if it is available as service), till now nothing got from soa apps adaptor.

Do u have any suggestion on this.

Thanks and Regards,
Sreejit

[anilpassi]

Hi Sree

In this case, you can configure BPELs JMS adapter to poll/read the Orders from MQSeries.
See this link http://download.oracle.com/otndocs/products/bpel/bpeltechadp.pdf
Hence you can use JMS[generic] adapter in BPEL to read IBM's MQSeries messages.


Once you read the payload from MQ, you can then have transform activity to convert that payload into a structure that matches PO Interface tables.
Next, use Database adapter to push that message to Oracle Apps via a stored procedure

Another option is to use apps adapter, as Standard PO interface is exposed in Integration Repository
See this URL
http://irep11i10.oracle.com/OA_HTML/OA.jsp?page=/oracle/apps/fnd/rep/webui/InterfaceListPG&BusinessEntity=PO_STANDARD_PURCHASE_ORDER&Title=Standard+Purchase+Order&retainAM=Y&_ti=50922882&oapc=5&selection=17_1_17_&oas=Nc53IrKrWKlOBq0JGTQlxQ..

Thanks,
Anil Passi

[sree]

Hi Anil,

thanks for reply.

The second url is not working for Integration Repository.

We have MQ adaptor in SOA, do u have any documnetation for it.

Thanks a lot once again.

Regards,
Sreejit

[anilpassi]

Simply login via http://irep.oracle.com/
And then expand the procurement section, you will see that Standard Purchase Order is exposed in iRep as Web service.
You should be able to create Partner link using apps adapter for this. Hence this will give you the schema that Oracle expects for Standard PO.

[sree]

Hi Anil,

I am sorry to disturb you once again, but when I am trying to find the concurrent program from jdev 10.1..3.1 I am not able to see it in module browser.

I am not able to see any concurrent program under standard purchase order tree. there are XML gateways and others and it doesn't have import standard purchase order conc prog.

Thanks and Regards,
Sreejit