Lookup Values REST API

Oracle fusion Application Lookup Value Screens:

---------------------------------------------------------------

Lookup Type: ANC_ABS_CERT_AUTO_COMPLETE

Lookup Type: ORA_GPY_CUST_INSTANCE_NAME

Request Name : GET

[Link]
Get a child lookup codes for lookup type: 

-------------------------------------------------------
[Link]
ANC_ABS_CERT_AUTO_COMPLETE/child/lookupCodes
Response:

{
    "items": [
        {
            "LookupCode": "YES",
            "Meaning": "Yes",
            "Description": "Certification Auto Complete",
            "EnabledFlag": "Y",
            "StartDateActive": "0001-01-01",
            "EndDateActive": "4712-12-31",
            "DisplaySequence": 1,
            "Tag": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2017-04-21T17:15:42.383+00:00",
            "LastUpdateDate": "2022-09-03T03:41:21.653+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "links": [
                {
                    "rel": "self",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/YES",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/YES",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "parent",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE",
                    "name": "commonLookups",
                    "kind": "item"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/YES/child/lookupsDFF",
                    "name": "lookupsDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/YES/child/translations",
                    "name": "translations",
                    "kind": "collection"
                }
            ]
        },
        {
            "LookupCode": "NO",
            "Meaning": "No",
            "Description": "No Certification",
            "EnabledFlag": "Y",
            "StartDateActive": "0001-01-01",
            "EndDateActive": "4712-12-31",
            "DisplaySequence": 2,
            "Tag": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2017-04-21T17:15:42.379+00:00",
            "LastUpdateDate": "2022-09-03T03:41:21.653+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "links": [
                {
                    "rel": "self",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/NO",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/NO",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "parent",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE",
                    "name": "commonLookups",
                    "kind": "item"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/NO/child/lookupsDFF",
                    "name": "lookupsDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/
lookupCodes/NO/child/translations",
                    "name": "translations",
                    "kind": "collection"
                }
            ]
        }
    ],
    "count": 2,
    "hasMore": false,
    "limit": 25,
    "offset": 0,
    "links": [
        {
            "rel": "self",
            "href": "[Link]
resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/lookupCodes",
            "name": "lookupCodes",
            "kind": "collection"
        }
    ]
}

Get a specific child lookup codes for lookup type:

------------------------------------------------------------------

/fscmRestApi/resources/[Link]/standardLookups/{LookupType}/child/lookupCodes/
{LookupCode}

{
    "LookupCode": "YES",
    "Meaning": "Yes",
    "Description": "Certification Auto Complete",
    "EnabledFlag": "Y",
    "StartDateActive": "0001-01-01",
    "EndDateActive": "4712-12-31",
    "DisplaySequence": 1,
    "Tag": null,
    "CreatedBy": "SEED_DATA_FROM_APPLICATION",
    "CreationDate": "2017-04-21T17:15:42.383+00:00",
    "LastUpdateDate": "2022-09-03T03:41:21.653+00:00",
    "LastUpdateLogin": "-1",
    "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
    "links": [
        {
            "rel": "self",
            "href": "[Link]
resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/lookupCodes/
YES",
            "name": "lookupCodes",
            "kind": "item"
        },
        {
            "rel": "canonical",
            "href": "[Link]
resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/lookupCodes/
YES",
            "name": "lookupCodes",
            "kind": "item"
        },
        {
            "rel": "parent",
            "href": "[Link]
resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE",
            "name": "commonLookups",
            "kind": "item"
        },
        {
            "rel": "child",
            "href": "[Link]
resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/lookupCodes/
YES/child/lookupsDFF",
            "name": "lookupsDFF",
            "kind": "collection"
        },
        {
            "rel": "child",
            "href": "[Link]
resources/[Link]/commonLookups/ANC_ABS_CERT_AUTO_COMPLETE/child/lookupCodes/
YES/child/translations",
            "name": "translations",
            "kind": "collection"
        }
    ]
}

Lookup Type : ORA_GPY_CUST_INSTANCE_NAME

Response:
{
    "items": [
        {
            "LookupCode": "P",
            "Meaning": "Production",
            "Description": "Production instance",
            "EnabledFlag": "Y",
            "StartDateActive": "0001-01-01",
            "EndDateActive": "4712-12-31",
            "DisplaySequence": 1,
            "Tag": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2018-03-17T06:18:34.145+00:00",
            "LastUpdateDate": "2022-09-03T03:41:21.653+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "links": [
                {
                    "rel": "self",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/P",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/P",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "parent",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME",
                    "name": "commonLookups",
                    "kind": "item"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/P/child/lookupsDFF",
                    "name": "lookupsDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/P/child/translations",
                    "name": "translations",
                    "kind": "collection"
                }
            ]
        },
        {
            "LookupCode": "D",
            "Meaning": "Development",
            "Description": "Development instance",
            "EnabledFlag": "Y",
            "StartDateActive": "0001-01-01",
            "EndDateActive": "4712-12-31",
            "DisplaySequence": 2,
            "Tag": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2018-03-17T06:18:34.129+00:00",
            "LastUpdateDate": "2022-09-03T03:41:21.653+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "links": [
                {
                    "rel": "self",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/D",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/D",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "parent",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME",
                    "name": "commonLookups",
                    "kind": "item"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/D/child/lookupsDFF",
                    "name": "lookupsDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/D/child/translations",
                    "name": "translations",
                    "kind": "collection"
                }
            ]
        },
        {
            "LookupCode": "Q",
            "Meaning": "QA Test",
            "Description": "QA Test instance",
            "EnabledFlag": "Y",
            "StartDateActive": "0001-01-01",
            "EndDateActive": "4712-12-31",
            "DisplaySequence": 3,
            "Tag": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2018-03-17T06:18:34.157+00:00",
            "LastUpdateDate": "2022-09-03T03:41:21.653+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "links": [
                {
                    "rel": "self",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/Q",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/Q",
                    "name": "lookupCodes",
                    "kind": "item"
                },
                {
                    "rel": "parent",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME",
                    "name": "commonLookups",
                    "kind": "item"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/Q/child/lookupsDFF",
                    "name": "lookupsDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "[Link]
fscmRestApi/resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/
lookupCodes/Q/child/translations",
                    "name": "translations",
                    "kind": "collection"
                }
            ]
        }
    ],
    "count": 3,
    "hasMore": false,
    "limit": 25,
    "offset": 0,
    "links": [
        {
            "rel": "self",
            "href": "[Link]
resources/[Link]/commonLookups/ORA_GPY_CUST_INSTANCE_NAME/child/lookupCodes",
            "name": "lookupCodes",
            "kind": "collection"
        }
    ]
}