Payables and Cash Management - EBS (MOSC)

MOSC Banner

Expense Audit Reasons API - "AP_WEB_AUDIT_HOOK" not working

edited Dec 16, 2015 2:23AM in Payables and Cash Management - EBS (MOSC) 8 commentsAnswered ✓

I am using 'AP_WEB_AUDIT_HOOK' to define additional audit rule in iExpense (r12).

But custom audit reason is not populated into expense report headers table due to which the expense report is not selected for audit.

The code used in the hook is as below:

=============================================================

PROCEDURE audit_expense_report(p_expense_report_id IN NUMBER,

p_audit_reason_code OUT NOCOPY VARCHAR2,

p_audit_report OUT NOCOPY BOOLEAN,

p_override_default_processing OUT NOCOPY BOOLEAN) IS

V_CASH_AMOUNT number;

BEGIN

p_override_default_processing := TRUE;

p_audit_report := FALSE;

p_audit_reason_code := 'CUSTOM';

BEGIN

select sum(submitted_amount)

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