Oracle Global Trade Management (MOSC)

MOSC Banner

excludePublic property appears to throw exception

edited Jan 22, 2025 5:44PM in Oracle Global Trade Management (MOSC) Question

Request sent with proper authorization

data_body = {        "schema": "PRIMARY",        "contentType": "text/plain",        "contentCompression": "GZIP",        "excludePublic": False,        "targetSystem": {            "appendName": True,            "externalSystem": "externalsystemname",        },        "tables": {            "items": [                {                    "tableName": table_name,                }            ]        },    }

Error when attempting to use excludePublic, I checked

https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=84bv5j2qp_4&_afrLoop=301322077313484

My boolean is not sent as a string.

otmgtm url response status -- 202

Error seen in External System Log Files:

2025-01-22 16:59:14.593  67451  Debug  DataReplicationDetails  Executing query for total count [dataReplicationItem - 3]
2025-01-22 16:59:14.595  67451  Error  Exception  [933541] [SQL_STATEMENT] select count(*) from ITEM t1 where 
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

However, previous to attempting to use excludePublic = false we were receiving data back without specific select clause provided.

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