Payables and Cash Management - EBS (MOSC)

MOSC Banner

API to Fetch Hold Release Date for AP Invoice

Hi Team,

is there any standard api or function available to fetch the release date from AP_HOLDS_V ?

I see that view is using the logic to print release date as below

DECODE (AH.RELEASE_LOOKUP_CODE, NULL, NULL, AH.LAST_UPDATE_DATE)

I need to extract invoices which were on-hold a specific date. The date can be in past or present. Expectation is that whatever date user is providing, code should be able to fetch the invoice if the invoice was on hold on that date.

Regards,

Shareef.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center