My Oracle Support Banner

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

Last updated on MARCH 01, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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