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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Blanket Purchase Agreement Start and End Dates in OTBI

Summary:

Looking for table that provides the same start/end dates as the Manage Agreements screen's in application

Content (please ensure you mask any confidential information):

Through some Googling and searching through the community, I've found that the code below pulls the purchase orders where the PO is on a PO Line that was created from a BPA. I was concerned that the start_date and end_date fields in the PO_HEADERS_ALL table were related to the PO and not necessarily the BPA, but I was surprised to find that these 2 fields are blank. What am I doing wrong and where should I be looking for the Blanket Purchase Agreement start/end dates?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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