E1: ORCH: AIS REST Call Not Returning Associated Descriptions For Multiple Rows (Doc ID 2785142.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Symptoms

The issue is reported in TR 9.2.5.x

When rest request retrieves the multiple phone number info, it doesn't have the Alpha Name in the output.  The Alpha Name field is the associated description field.   

Navigation:  P01012:: Find and address book number::Row Exit "Who's Who":: select a Row:: Row Exist "Phones"



-------------
Request
------------

{
    "token": "xxx",
    "action": "open",
    "formRequest": {
        "maxPageSize": "5",
        "formName": "P01012_W01012B",
        "returnControlIDs": "1[19,20,50]",
        "version": "ZJDE0001",
        "findOnEntry": "FALSE",
        "formActions": [
            {
                "command": "SetControlValue",
                "controlID": "54",
                "value": "C"
            },
            {
                "command": "DoAction",
                "controlID": "15"
            }
        ]
    }
}

------------
Response
------------

{
    "fs_P01012_W01012B": {
        "title": "Work With Addresses",
        "data": {
            "gridData": {
                "id": 1,
                "fullGridId": "1",
                "columns": {
                    "z_AN8_19": "Address Number",
                    "z_ALPH_20": "Alpha Name",
                    "z_AT1_50": "Sch Typ"
                },
                "rowset": [
                    {
                        "z_AT1_50": "C",
                        "z_AN8_19": 500,
                        "z_ALPH_20": "Gas StationA"
                    },
                    {
                        "z_AT1_50": "C",
                        "z_AN8_19": 705,
                        "z_ALPH_20": "Consignment Agent - COP"
                    },
                    {
                        "z_AT1_50": "C",
                        "z_AN8_19": 1288,
                        "z_ALPH_20": "Hardware Supplies"
                    },
                    {
                        "z_AT1_50": "C",
                        "z_AN8_19": 3001,
                        "z_ALPH_20": "Global Enterprises"
                    },
                    {
                        "z_AT1_50": "C",
                        "z_AN8_19": 3002,
                        "z_ALPH_20": "Atlantic Corporation"
                    }
                ],
                "summary": {
                    "records": 5,
                    "moreRecords": true
                }
            }
        },
        "errors": [],
        "warnings": []
    }

---------------------------------
Request - Row exit to 'Phones'
----------------------------------

 {
    "token": "XXXXX",
    "stackId": 3,
    "stateId": 1,
    "rid": "5771c3f7234de512",
    "action": "execute",
    "actionRequest": {
        "returnControlIDs": "",
        "maxPageSize": "4",
        "formOID": "W01012B",
        "formActions": [
            {
                "command": "SelectRow",
                "controlID": "1.0"
            },
            {
                "command": "DoAction",
                "controlID": "65"
            }
        ]
    }
}

-------------------
Response----->  missing Associated Descriptions. 
-------------------

{
    "fs_P0115_W0115A": {
        "title": "Phone Numbers",
        "data": {
            "gridData": {
                "id": 1,
                "fullGridId": "1",
                "columns": {
                    "z_AR1_28": "Prefix",
                    "z_PH1_29": "Phone Number",
                    "z_PHTP_27": "Phone Type",
                    "z_DL01_66": "Phone Type Description",
                    "z_RCK7_26": "Line Number"
                },
                "rowset": [
                    {
                        "z_DL01_66": "Business",
                        "z_PH1_29": "111-1111",
                        "z_PHTP_27": " ",
                        "z_RCK7_26": 1,
                        "z_AR1_28": "111"
                    },
                    {
                        "z_DL01_66": "Car or Mobile",
                        "z_PH1_29": "111-1112",
                        "z_PHTP_27": "CAR",
                        "z_RCK7_26": 2,
                        "z_AR1_28": "111"
                    }
                ],
                "summary": {
                    "records": 2,
                    "moreRecords": false
                }
            },
            "z_AN8_7": {
                "title": "Address Number",
                "value": 500
            },
            "z_IDLN_32": {
                "title": "Who's Who Line Number - ID",
                "value": 0
            }
        },
        "errors": [],
        "warnings": []
    }

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.