EBS Customizations (MOSC)

MOSC Banner

ORA-40441: JSON syntax error When response exceeds 70 records

I am using EBS 12.1.3 with DB 12.1.0.2.0 I have integrated external HRIS system with EBS using a web service. Procedure works fine when http reponse contains 70 or less records. When it exceeds, procedure completes with error stating ORA-40441: JSON syntax error

For example, below json response procedure works fine when 2 records exist in http response. I am providing sample script for review. Any suggestion will be highly appreciated.

[

 {

  "Location": "Dealer Department",

  "Position": "Channel Sales Manager",

  "First Name": "Sanjeewa",

  "Hire Date": "17/09/2019 00:00:00",

  "CREATE DATE": "",

  "EPF Number": "04506",

  "UPDATE DATE": "27/11/2020 09:40:24",

  "NIC": "700230180v",

  "Title": "Mr.",

  "middle name": "",

  "Gender": "Male",

  "emp_resign_date": "15/10/2020 00:00:00",

  "Last Name": "Perera",

  "Company": "Royal Ceramics Lanka PLC"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center