Questions tagged [responsys]
37 questions
10
votes
1 answer
Getting crash on JobIntentService onComplete
I am getting following crash reports for Android 8, but I could not find a reason or fix for this:
java.lang.IllegalArgumentException: Given work is not active: JobWorkItem{id=1 intent=Intent { act=com.google.android.c2dm.intent.RECEIVE…

Changdeo Jadhav
- 706
- 9
- 23
6
votes
4 answers
FirebaseInstallationsException on latest version
Every time I update my app's Firebase dependencies to anything more recent than the Feb. 27 2020 update, I start seeing this exception when I run my app:
04-29 18:21:58.170 3314 3541 E Firebase-Installations: Firebase Installations can not…

Big McLargeHuge
- 14,841
- 10
- 80
- 108
2
votes
2 answers
SQL to Select next available code from table
I would like to Select an available PROMO_CODE (table B) for the CUST_ID records (table A) that do not have one.
I think I have the base SQL for each table, but not sure how to combine these for an output.
-----Table A…

thatguydreams
- 21
- 2
2
votes
2 answers
Oracle Responsys - RPL to pull in data from supplemental tables (like FreeMarker as well)
I'm sure it's a stretch here seeing if anyone knows the answer to this, but I'm trying to come up with an RPL to pull in another RPL from a supplemental table. RPL is Responsys' programming language that is very similar to FreeMarker, so if you know…

Almost_Ashleigh
- 524
- 1
- 4
- 24
2
votes
1 answer
Oracle Responsys Link form in the main Campaign
I have created a Form in Oracle responsys which is linked to my current table and form works completely fine. I have issue with generating the link for the form using built-in oracle responsys function $prefilledform(crm_form_test)$.
I just want to…

Preetham Hegde
- 839
- 2
- 13
- 24
2
votes
1 answer
REST API to create profile list Oracle responsys
Could anyone let me know how can I create a profile list in Oracle responses via REST API call?
I could do it via UI but I need to do automation via javascript.

Shilpa
- 103
- 1
- 9
2
votes
1 answer
Oracle responsys - send record to table in warehouse on event
I'm trying to figure out how to send Responsys record/s to a table in our data warehouse (MS SQL) in real time, when triggered to do so from an interaction event.
Use case is-
- Mass email is sent
- Customer X interacts with email (e.g. open,…

Googleman
- 21
- 4
1
vote
1 answer
Oracle Responsys RPL: How do you create a fallback value when the supplemental table data fails?
so in Responsys we pull in the subject line via a supplemental table. We had an issue where the supplemental table failed last week and the campaign was sent out with no subject line. What we are trying to do is create a fallback value so when there…

Jenna
- 11
- 1
1
vote
3 answers
Can you have multiple select statemets on a single table then join them?
Please note that I'm not a developer, so any help here would be greatly appreciated.
My problem:
I have list in Oracle Responsys that contains all customers booked on a tour. I want to find all records that have missing values for FIRST_NAME (could…

Bently411
- 25
- 2
1
vote
2 answers
IF statement for one variable with multiple values
Is there a better way to write this IF statement for testing multiple options of a variable?
<#if PRINTER_PET.RETAILER_NAME = 'BEST BUY' || PRINTER_PET.RETAILER_NAME = 'Best Buy Purchasing LLC'>
document 1
<#elseif PRINTER_PET.RETAILER_NAME =…

Erica Behnke
- 11
- 4
1
vote
1 answer
Pivot in SQL: count not working as expected
I have in my Oracle Responsys Database a table that contains records with amongst other two variables:
status
location_id
I want to count the number of records grouped by status and location_id, and display it as a pivot table.
This seems to be…

WNG
- 3,705
- 2
- 22
- 31
1
vote
1 answer
How to use Oracle Responsys with Java Application
In my Java Application I want to use Oracle Responsys to trigger individual email in response to some activity detected by my web site
Oracle Responsys is completely new for me and not able find out where to start.
I got SOAP API Developer’s Guide…

Kharkooza Boche
- 63
- 1
- 7
0
votes
0 answers
Responsys block with list directive breaks browser view
Data is coming in through an API and the payload contains items as a field with multiple properties such as Name, Quantity, Size, color.
Here is the email block that uses the List directive:
Name: ${ship_firstname}
<#assign itemspayload =…
<#assign itemspayload =…

Amar S
- 1
- 1
0
votes
0 answers
[Oracle Responsys]Supplemental: Supplemental_table has no extraction key that matches fully to the list
My email is showing errors and the problems seems to be with my supplemental table.
This are the errors I get:
Supplemental data source: CA_3rd_email_2023 associated with: 2023_ma_vlmr_ca_3rd_email_DRAFT_test is invalid for the reason below:…

th0tminik
- 21
- 4
0
votes
0 answers
For a trigger program in oracle responsys how can we stop sending to creatives in program when we reach/send max of 500 records
For a trigger program in oracle responsys how can we stop sending to creatives in program when we reach/send max of 500 records.
I'm not sure if count switch with batch of 365 days works.