You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to retrieve Generic Lookup code using REST API

Received Response
132
Views
4
Comments
edited Mar 25, 2024 9:01PM in Financials – General 4 comments

Oracle provides 3 REST API types namely Common, generic and Standard lookups to retrieve respective lookup values. I need to search for lookup codes under lookup type "PAY GROUP". This is part of "Manage Payables Lookups". So I am trying to use below REST methods.

Below one provides lookup type information

https://XXXXXXXXX.fa.ocs.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/genericLookups?q=LookupType='PAY GROUP'&expand=lookupCodes

I used below child resource "lookupcodes" to get lookup codes under it but its giving count as 0.

https://XXXXXXXXX.fa.ocs.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/genericLookups/0002000000095041592047524F55500000000EACED0005770800000000000000C8/child/lookupCodes

Attached response files for lookup type and lookup codes.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!