Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Custom Web Service for multiple records — Cloud Customer Connect
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

Custom Web Service for multiple records

Received Response
14
Views
5
Comments
edited Nov 12, 2019 3:31PM in API Management 5 comments

Summary

Custom Web Service for multiple records

Content

Hi Experts,

I am able to develop and deploy a web service which when we pass inventory item id give me one record details of that inventory item id in EBS R12.1.3.

Now My requirement is when i pass LAST_UPDATE_DATE it should give me all the items later than that last update date. I will use this web service in OIC to get EBS Items and POST in Engagement Cloud adapter.

Regards,

Zahid Rahim

 

 

Version

EBS R12.1.3

Code Snippet

FUNCTION getItemDetails(pLastUpdateDate DATE)
RETURN     invTabTyp
IS
    CURSOR c IS
        SELECT description
        from mtl_system_items msi   
        WHERE trunc(last_update_date) > pLastUpdateDate; 
        
        vInvTable invTabTyp;
        
        vIndex NUMBER := 1;
    

    BEGIN
    
    

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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