While Creating A Transaction Using REST API , 500 Internal Status Error.

(Doc ID 2371000.1)

Last updated on MARCH 10, 2018

Applies to:

Oracle Fusion Loyalty - Version 11.13.17.09.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.17.09.0 version, Loyalty Transactions

When attempting to run a REST API - post method for Transaction object
the following error occurs.


URL : https://<POD>.fa.us6.oraclecloud.com:443/crmRestApi/resources/11.13.17.08/loyaltyTransactions

Request Payload :
{"MemberNumber":"300000000000002","TransactionDate":"2017-10-01","ProductNumber":"XXX","AmountValue":"1","TypeCodeName":"Accrual","SubTypeName":"Product","ProgramName":"XXXX"}

Response : Empty String
{
}
Headers :
Status Code - 500 Internal Server Error

A custom groovy script has been written in Transactions object > Object Triggers > Before Insert which is blocking this request from being executed successfully.


ERROR
-----------------------

Status Code: 500 Internal Server Error. Response : {} empty string

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to POST MAN
2. Execute the web service via REST API
3. Getting an error in the response.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the REST API using post method which is affecting their ability to process transactions in the system and not allowing them to complete their work promptly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms