Category 222-2
Discussion List
-
assign oic array to varchar2 field in DBSummary: Hello everyone, help with the following case. I have an integration in OIC that internally invokes a Rest service, this service has a response that contains an … -
BICC: How to Find Current Run ExtractsSummary: I an trying to submit BICC extracts through esswebservice. I see extracts are being submitted and completed without any issues. However, when I check UCM for th…
-
OIC Gen3: GenericSoapPort SOAP Connection Error [REST_AUTH_INIT_ERR]Summary: We are utilizing a SOAP connection to facilitate authentication between the OIC Gen3 application and the Oracle Cloud ERP application. We are using the same OAu…
-
XSLT to find elements whose total is equal to a target valueSummary: I have an xml in the following format and a target value. a 10 b 15 c 25 I need to find all the elements whose value is equal or less than the target va…
-
Fetch Distinct value from BI ReportSummary: Hi I am getting multiple customer data in BI report and I need to pass only distinct Customer to For loo( Highlighted in Yellow color) How to achieve this ? Con…
-
Getting 406 error while calling oracle pcs rest api for retriving attachment as streamSummary: Hi Everyone, Getting 406 error while calling oracle pcs rest api for retriving attachment as stream(response type is stream) Error: Not Acceptable.The 406 Not A… -
Java file issueSummary: hi I am trying to upload a JavaScript file to OIC Library, but it prompts: "Failed to create Library. Unable to parse function formatNumber(num,locale="en-US",d…
-
Bar Code IntegrationHi, What are the methods of bar code integration in Oracle FA can it be done through OIC and VBCS please provide your suggestions. Thanks -
How to Reset the BICC Extract To last run Date via APIHi Team, How to reset the BICC Extract to last run date using the Oracle API. Can some one please provide inputs as we are using the BICC in the integration and as part …
-
invalid_grant : The token has already been consumedSummary: invalid_grant : The token has already been consumed. Content (required): We set up trust between Identity domain and ERP and configured OAUTH. This is to call F…
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…
-
Correct REST Framework Version for Oracle API'sSummary: Hi Team, We see that Oracle provide different REST Framework Versions for invoking API's and some operations are not allowed in default versions. Can some pleas…
-
downloadESSJobExecutionDetails in ErpIntegrationService returns SocketTimeoutExceptionSummary: We are leveraging the downloadESSJobExecutionDetails in the ErpIntegrationService to download ESS job output files from Oracle Cloud ERP. Although the service u…
-
Oracle Object Storage Subfolder listing using REST APII have bucket (Dev-Buck01) which is hosting three folder and sub folders Dev-Buck01/GL/Jan24/ Dev-Buck01/GL/Feb24/ Dev-Buck01/AP/Jan24/ I want to download files from GL/…
-
Response of OTM DB Servlet API is not coming in valid xml formatI have tested the OTM DB Servlet API to retrieve transmission report data, but the response is not coming back in the correct XML format. As a result, we are facing diff…
-
need help to understand xpath error -OICSummary: Hi Guys. I am geting this xpath error, however I have no Idea how to "bebug" it. Content (required): Version (include the version you are using, if applicable):… -
I am trying to read a xml file which is UTF-8-BOM encoded and Stage Read fails in OICSummary: I am trying to read a xml file which is UTF-8-BOM encoded and Stage Read Activity fails in OIC stating that "SAX Exception raised while trying to SAX Parse Inpu…
-
ERP Cloud REST API timeout limitSummary: I would like to know the timeout limit for the ERP Cloud REST API and whether it can be configured. We are making requests using Postman.
-
How to integrate suppliers into oracle ERP cloud? is it REST API or FBDI?Summary: How to integrate suppliers into oracle ERP cloud? Which is the preferred method? is it REST API or FBDI? We may receive multiple creation scenarios like create … -
do we have any business event available for Create Cost Accounting Distributions ESS JOB?Summary: Transfer Transactions from Maintenance to Costing/ Transfer Transactions from Production to Costing Transfer Costs to Cost Management Transfer Transactions from…
-
/crmRestApi/resources/latest/resourceUsers API is giving error to pass the contract infoSummary: Hi Team, We are trying to create sales person, bu first creating resource using enpoint - "/crmRestApi/resources/latest/resourceUsers" Error Message You need to…
-
How to insert data in different REST response level to one ATP table in OIC?Hi All, As the following screenshot, I'd like to insert data the REST response data to a ATP table. For this example, the response payload with one parent level 'item' a…
-
Upload Document OPA REST API with Multipart/Form-DataSummary: I have made an Integration in OIC, which capture data from my PaaS Tables. Attachments are uploaded as BLOB, and my integration has extracted those BLOBS from P…
-
Unable to access 'Workers' business resource using the Oracle HCM Cloud adapter in OICSummary: We are configuring the Oracle HCM Cloud adapter in Oracle Integration Cloud (OIC) to use the "Workers" business resource. However, after selecting the correct s…
-
OIC Gen 3: Eloqua|Retrieve a sync REST API giving 404 Not FoundSummary: I am trying to invoke an Eloqua rest api through OIC gen3, it is giving 404 Not Found. Retrieve a sync | get | /api/bulk/2.0/syncs/{id} I am passing query param…Jigyasa Kamthan-Oracle 31 views 3 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration -
Is there any REST API to add and update items to the cycle count ?Summary: I see one API /fscmRestApi/resources/11.13.18.05/cycleCountTransactions . Is this for add items to cycle count ? Do we have PATCH operation supported for this f…
-
Extract fields from XML responseSummary: In OIC i'm receiving a BI Report that has xml data in it (i added a sample response as an attachment). I need to access the individual Columns out of the Row ar…
-
How to get the status of HCM Extract ESS job status in details using Webservice in OIC?Summary: Hi All, We have built an HCM Extract which is integrated to third party via OIC and third party system pass parameter values based on the requirement. Extract D…
-
Use round function to rounding to 2 decimal placesSummary: Use round function to rounding to 2 decimal places Content (please ensure you mask any confidential information): Hi experts, I working in data maping but I nee…
-
What Job role or Privilege is needed to view Supplier Registration Requests using REST APISummary: We have a requirement to view Supplier Registration Requests using REST API (/fscmRestApi/resources/11.13.18.05/supplierRegistrationRequests/). But we are getti…