Financials for India - EBS (MOSC)

MOSC Banner

in oracle version 12.1.3 versoin attribute1 column is blank for all invoices including TDS which is

( SELECT   sum( aia4.invoice_amount) tds_amount  

          from ap_invoices_all aia3,

          ap_invoices_all aia4

          WHERE TO_CHAR (aia3.invoice_id) = aia4.attribute1  -- here attribute1 of ap_invoices_all table does not have any value in 12.1.3 new version

          and aia3.invoice_id = aia1.invoice_id 

          and aia3.attribute1 is null

          and aia3.vendor_id = aia4.vendor_id

         AND aia3.org_id = '2341' -- '2339'(blr)

         and aia3.org_id = aia4.org_id

          AND aia3.vendor_site_id = aia4.vendor_site_id

             group by     aia4.attribute1   ) net_tds,

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