Accessing SDO entities

Juan S.

Hi all,

I'm trying to create a WS client in order to get Receivables Invoices from Financials ERP Cloud. The information I need to get relies on the following SDO: http://docs.oracle.com/cloud/latest/financialscs_gs/OESWF/Receivables_Invoice_Header_SDO_Invoice_svcDataObj_77.htm#oracle.apps.financials.receivables.transactions.invoices.invoiceService.Invoice

The WS operation which handles this SDO is the following one: http://docs.oracle.com/cloud/latest/financialscs_gs/OESWF/Receivables_Invoice_InvoiceService_svc_32.htm#oracle.apps.financials.receivables.transactions.invoices.invoiceService.InvoiceService

But the operations contained in the above service doesn't allow to get an Invoice given an id, or get a list of invoices given a seach criteria.

The questions are:

1) Is there a way to access an SDO directly? By directly I mean, whithout using a web service.

2) If (1) is not possible, is there any way to create a new operation in order to expose a specific SDO type?

Thanks in advance

Juan

Bhuwanesh

Hi Juan

These SDO's are consumed by Oracle Fusion Applications via webservices which are publicly exposed. Hence you can not access the SDO's directly. They need to be consumed

via webservices only. I suggest you log an SR with oracle and ask them if they have a webservice publicly exposed, to cater to your use case.

Thanks

Bhuwanesh

Jiri.Machotka-Oracle

I'm afraid, these questions are about the Oracle Financials Cloud, not JCS. One forum I was able to find is here: https://cloud.oracle.com/forums

As for JCS, WS - SOAP or REST, if available might be the preferred way of consuming services. It might also be wise to have some integration layer - e.g. SOACS, if more apps are to be integrated.

Juan S.

Hi Jiri,

Thanks for your answer.

Besides this is a Financials question, from the JCS point-of-view, is there any way to access the SDOs directly?

Kind regards,

Juan

Jiri.Machotka-Oracle

I cannot speak about this particular object, but here: https://docs.oracle.com/cloud/latest/javacs_gs/CSJSU/GUID-7BD0CE4E-86CB-4537-BB0A-B0BB7A6BEE2B.htm#CSJSU7057 is an overview of supported interfaces to JCS. JCS SX is an edition which has SSO with some of apps (CX for sure, nut sure about Financials).

Bhuwanesh

Hi Juan

These SDO's are consumed by Oracle Fusion Applications via webservices which are publicly exposed. Hence you can not access the SDO's directly. They need to be consumed

via webservices only. I suggest you log an SR with oracle and ask them if they have a webservice publicly exposed, to cater to your use case.

Thanks

Bhuwanesh

Juan S.

Hi Bhuwanesh,

I arrived to the same conclusion (after reading a lot of documentation). Thanks for the answer anyway, it's great to validate conclusions with someone else.

Regards

Juan