Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Procurement - EBS (MOSC)

Create Content to download BPA details on a spreadsheet by using WebADI integrator

Jan 8, 2024 5:36AM edited Jan 8, 2024 8:02AM in Procurement - EBS (MOSC) 3 commentsAnswered

(1) I created a custom view OHIS_BNE_BPA_LINES to select all required BPA details to download

(2) I created a new integrator with Content Type=Query i.e. select * from OHIS_BNE_BPA_LINES by using the Desktop Integration Manager

The Content downloaded all the expected records.

However, when I tried to put in where clause it does not download any records

e.g. select * from OHIS_BNE_BPA_LINES where org_id=640

or, select * from OHIS_BNE_BPA_LINES where rownum<5 -- select only 4 records

and I ran the SQL on sql*Developer - it definitely returned rows but it does not return any records via WebADI content.

Tagged:

0

Howdy, Stranger!

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

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

Category Leaderboard

Top contributors this month