Receivables - EBS (MOSC)

MOSC Banner

Need to re-initiate approvals using AME via PL-SQL

edited Jan 22, 2024 4:38PM in Receivables - EBS (MOSC) 4 commentsAnswered

EBS: r12.2.4

DB: 19.0.0.0

Hi All,

We have a requirement to re-initiate approvals of a rejected transaction (approvals using Oracle workflow and hierarchies derived from AME). I can successfully call approval hierarchies via below code. But when a transaction is rejected and we intend to re-initiate the approvals, we face challenges. Kindly help

Regards




ame_api2.getNextApprovers4(applicationIdIn       => l_application_id

             ,transactionTypeIn      => 'CMP_REP_APPR'

             ,transactionIdIn       => v_file_appr_hdr_id

             ,flagApproversAsNotifiedIn  => ame_util.booleanTrue

             ,approvalProcessCompleteYNOut => l_is_approval_complete

             ,nextApproversOut       => l_next_approvers);


ame_api2.updateapprovalstatus2(applicationidin  => l_application_id

               ,transactionidin  => v_file_appr_hdr_id

               ,approvalstatusin => ame_util.approvedstatus   --ame_util.rejectstatus

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