Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Accessing SDO entities

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
Best Answer
-
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
Answers
-
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.
-
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
-
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).
-
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
-
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