Category 222
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 … -
OIC - Is there a way to check UTF-8 encoding while reading a file from SFTP?Summary: Hello, Is there a way to check if a file is UTF-8 encoded while reading a file in OIC? There is a requirement to process a file only if it is UTF-8 encoded Than…
-
Not getting the data in response after mapping the filed for rest adaptor in OICI have created a rest adaptor to get the transmission report data from OTM . I have tested it first via postman . below is the request and response : Request : Transmi…
-
How can I monitor intermittencies on an OIC instance within OCI?Summary: Hello community. I am looking for guidance on how to detect intermittency or outages on an Oracle Integration Cloud (OIC) instance created within Oracle Cloud I… -
OIC Outbound IP - Sufficient & Secure for whitelisting in OCI?Summary: Is OIC Outbound IP sufficient and secure for whitelisting in security rule for access within private subnet? Content (please ensure you mask any confidential in…
-
Oracle Fusion Business Events consumption in OIC Gen2Summary: Oracle Fusion Business Events consumption in OIC (Service Limits) in Gene Content (please ensure you mask any confidential information): Q) If we have 500k even…
-
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…
-
Unable to find private endpoint parameter in OIC terraform codeSummary: Hello Team, Our project requires us to set up a Private Oracle Integration Cloud (OIC) using Terraform, which involves creating OIC in a private subnet within a…
-
Issue with Read File adapter after Unzipping fileSummary: Issue with Read File after Unzipping Content (please ensure you mask any confidential information): I am modifying an existing OIC integration and adding a Stag…
-
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…
-
BI report Pdf Output in email notification attachmentSummary: Hi How to send BI report(pdf format) in OIC email notification attachment. Content (please ensure you mask any confidential information): Version (include the v…
-
Excel file generation using OIC 3 with BIP reportSummary: Hi Experts We have a requirement to generate an excel file with OIC 3. As our customer is not using OCI resources like functions, we are left with option to use…
-
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… -
Impact of huge Business Events volume in Oracle ERP Cloud and OICSummary: Impact of huge Business Events volume in Oracle ERP Cloud and OIC Content (required): We are planning on building multiple event based real time OIC integration…
-
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…
-
convert BI report Email address into stringSummary: Hi We are getting email address in BI report and we need to send email to these email address in one email. Please suggest how we can achieve this. Content (ple…
-
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…
-
Are the OIC Integration flow details stored in a table?Are the OIC Integration flow details stored in a table?
-
Is there any REST API that could capture the Fusion authentications through SSO?Summary: We want to track the number of authentications in the cloud fusion hcm that's going through SSO, we don't have the Chooser login enabled. There is a doc id - Fu…
-
How to update an existing integration using Project deployment in OIC 3.0Summary: Hello, I am using Project in OIC 3.0. I tried to update an existing integration in OIC target environment using project deployment. Here are the steps that I fo…
-
parameter value is not getting passed to DB adapter in OICgen3Summary: I am invoking an Oracle ATP connection in my integration. I want to fetch IDs from my database table for which I am writing a simple sql query. I have tried thi…Jigyasa Kamthan-Oracle 19 views 2 comments 0 points Most recent by Jigyasa Kamthan-Oracle Integration -
Delete Statement is not Working in Database Adapter In OIC?Summary: We are Tring to Delete Data From Table EX: DELETE FROM table_name Integration is Showing Success but Data is not Deleting From the Table. Content (please ensure…
-
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/…