Query to Retrive Purchasing mapping set in oracle fusion

 select
XMST.name,
DeliverLoc.LOCATION_NAME,
gcc.segment1||'.'||
gcc.segment2||'.'||
gcc.segment3||'.'||
gcc.segment4||'.'||
gcc.segment5||'.'||
gcc.segment6||'.'||
gcc.segment7 code_combination,
from XLA_MAPPING_SETS_TL  XMST,
XLA_MAPPING_SET_VALUES xmSV,
gl_code_combinations gcc,
HR_LOCATIONS_ALL DeliverLoc
where XMST.application_id =201  -- Application id for purchasing
and XMST.name ='XX Procure Purchaseing CC MP' -- Name of Mapping Set
and XMST.application_id= xmSV.application_id
and XMST.language ='US'
and xmSV.mapping_set_code=XMST.mapping_set_code
and xmSV.VALUE_CODE_COMBINATION_ID=gcc.CODE_COMBINATION_ID
and xmSV.INPUT_VALUE_CONSTANT1=DeliverLoc.location_id

Res API to create a Party, Party site and Party Site Usage In Oracle Fusion

 URL:   https://host/crmRestApi/resources/11.13.18.05/hubOrganizations/

Method: POST

JSON payload

{
    "PartyNumber": "TEST_Party_001",
    "OrganizationName": "Testing Organization Creation",
    "PartyUsageCode": "PARTY_OF_INTEREST",
    "SourceSystemReference": [
        {
            "SourceSystem": "CRM",
            "SourceSystemReferenceValue": "1234567"
        }
    ],
    "Address": [
        {
            "AddressType": "BILL_TO",
            "Address1": "200 Hill Top Building",
            "City": "hillington",
            "Country": "US",
            "PostalCode": "44023",
            "State": "OH"
        },
  {
            "AddressType": "SHIP_TO",
         "Address1": "200 Hill Top Building",
            "City": "hillington",
            "Country": "US",
            "PostalCode": "44023",
            "State": "OH"
        }
    ]
}