Sunday, 8 July 2018

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)