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"