Order Management - EBS (MOSC)

MOSC Banner

Unable to invoke ISG custom Rest service with Record type input

edited Sep 7, 2021 9:10AM in Order Management - EBS (MOSC) 1 commentAnswered

Hi Team,


We have the rest api defined which will accept a record type as input.

Below is the DDL for the record type:

create or replace TYPE JSON_HEADER_REC_TYPE IS OBJECT

( ProgramName VARCHAR2(240),

OrderId VARCHAR2(240),

OrderType VARCHAR2(240),

OrderStatus NUMBER,

TransactionID NUMBER,

BillTo JSON_BILLTO_TAB_TYPE);

/

create or replace TYPE JSON_BILLTO_REC_TYPE IS OBJECT

( Action VARCHAR2(30),

BillToName VARCHAR2(240),

OBANumber VARCHAR2(240));

/

create or replace TYPE JSON_BILLTO_TAB_TYPE IS TABLE of JSON_BILLTO_REC_TYPE;

/

PLSQL PACKAGE BODY:

CREATE OR REPLACE PACKAGE body XXEFX_C2O_JSON_TEST_PKG AS

/* $Header: $ */

FUNCTION upload (p_json_data in Json_Header_Rec_Type

Tagged:

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