DTXQL Rest API Service Request Failing For Gift Card/Certificate Transactions (Doc ID 2707559.1)

Last updated on MARCH 07, 2023

Applies to:

Symptoms

DTXQL Rest API service request failing for Gift Card/Certificate transactions.

Developing an interface for fetching transactions from Xstore Office Cloud (XOC) using DTXQL Rest API service and persisting them in On-Prem DB.

QA testing found that DTXQL services quite often gives 400 BAD REQUEST error even though all the transactions are replicated properly to XOC.

Below are the observations:

• The service will fire DTXQL query every hour and will fetch all transactions from XOC done during the hour.
• Issue is DTXQL is failing for certain individual transactions and then it fails to retrieve any transactions for that time period.
• On analyzing transaction by transaction it can be seen that certain transactions like Gift Certificate Issued/Redeem, Returns with Store Credit Issue/Redeem get a Bad request error and due to which the entire set of transactions is not retrieved for that time period.
• It has been confirmed that the transactions were replicated successfully to XOC and can be retrieved in EJournal.
  
  

When this occurs, a "400 bad request" error is shown which fails the entire batch of transactions, not just the single transaction.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.