Oracle Supplier Based On Organization Profile Query

   SELECT DISTINCT a.Vendor_name,
                   a.segment1,
                   a.vendor_id,
                   b.vendor_site_id,
                   b.vendor_site_code,
                   c.name
     FROM ap_suppliers a, ap_supplier_sites_all b, hr_operating_units c
    WHERE a.vendor_id = b.vendor_id AND b.org_id = c.organization_id
    AND c.organization_id=fnd_profile.VALUE('ORG_ID');

Oracle Web ADI Defaulting Flagged Row Issue

Web ADI Defaulting Flagged Row Issue

Requirement: Sometimes the client wants to default selection of flagged rows option, instead of select all rows.

Navigation: Application Developer Responsibility > Application > Function

Query Custom Function which you define for web ADI

Goto Form Tab

Parameter: bne:page=BneCreateDoc&bne:integrator= XXAPINV6_XINTG&bne:rows=FLAGGED

Add defaulting parameter like shown above.

Oracle Web ADI Invalid Integrator Key Issue

Web ADI Invalid Integrator Key Issue

Following Error Comes When User try to open Web ADI from Different EBS User Login.

Solution:

Navigation : Desktop Integrator Manager > Select Integrator > Goto Integrator Tab

Step 1: Select Check Box: Display in Create document Page

Step 2: Add Function under Security Rules

1)      BNE_ADI_CREATE_DOCUMENT (Many Time Required to add ‘BNE_CREATE_DOCUMENT’)

2)      XXAPINVFN1 (Function which is used for assign Web ADI to Specific responsibility)