Financials for India - EBS (MOSC)

MOSC Banner

Excise Invoice No and Date Mandatory in Receipt Localized Form

edited Jan 29, 2014 11:06PM in Financials for India - EBS (MOSC) 5 commentsAnswered
Hi Experts,

I want to make Excise invoice No and Date field mandatory in Receipt Localized form when excise taxes will be there. But It is not working.

I have applied below: Please correct me

Trigger Event: WHEN-NEW-BLOCK-INSTANCE

Trigger Object: JAI_RCV_HEADERS

Condition: EXISTS (
         SELECT 1
           FROM jai_rcv_line_taxes jrlt,JAI_RCV_HEADERS jch
          WHERE jrlt.shipment_header_id = jch.shipment_header_id
          and jch.shipment_header_id = :JAI_RCV_HEADERS.shipment_header_id
          and jrlt.vendor_id = jch.vendor_id
          and jch.vendor_id = :JAI_RCV_HEADERS.vendor_id
            AND UPPER (tax_type) IN
                   ('EXCISE', 'ADDITIONAL_CVD', 'CVD',

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