My Oracle Support Banner

Problem With Audit Action "DELETE INVOICE LINE ITEM" For Action Check Creation. (Doc ID 2645381.1)

Last updated on MARCH 10, 2020

Applies to:

Oracle Transportation Management - Version 6.4.2 and later
Information in this document applies to any platform.

Symptoms

Created an action check based on action "DELETE INVOICE LINE ITEM" in order to reject the deletion if a voucher line exists against the specific invoice line item. when the customer deleted an invoice line (a voucher line was attached) The deletion was accepted, both invoice line and voucher line were deleted.

STEPS
-------

1. Created an Action Check Action Check creation based on the Audit Action DELETE INVOICE LINE ITEM Allow Condition : VOUCHER_LINE DOES NOT EXIST FOR INVOICE_LINEITEM SQL: select 1 from invoice_lineitem ili where not exists (select invoice_gid from voucher_invoice_lineitem_join where lineitem_seq_no = ili.lineitem_seq_no and invoice_gid = ili.invoice_gid) and ili.invoice_gid=?and ili.LINEITEM_SEQ_NO=?

 Did not select the Post Action Check, since this check does not work with this audit action.

2. Added Accessorial Cost to invoice and Approved the invoice to generate vouchers

3. Deleted the accessorial with out any issues.

The action check should be triggered by the action (line item deletion) and an error message should be shown on the screen.But the system allows the deletion.The action check is not triggered.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.