How to mark an AP invoice failing in accounting as Accounted without actually posting the accounting enteries in Oracle cloud?

Please follow the following steps to account a problematic invoice:

Please make sure invoice is cancelled before following this steps:

Step 1 – create/enable the following profile options at site level:

AP_SHBYIV_ENABLE
AP_SHBYIV_MARK_UNACCT_INVOICE_EVENTS2_NU

Setup and Maintenance -> Manage Profile Options -> New ->

Create Profile Option as :

– Profile Option Code: AP_SHBYIV_ENABLE
– Profile Display Name: AP_SHBYIV_ENABLE
– Application: Payables
– Module: Invoices
– Description: Self Healing Profile
– Start Date: <Enter the date like MM/DD/YY>

Save and Close

Create Profile Option as

– Profile Option Code: AP_SHBYIV_MARK_UNACCT_INVOICE_EVENTS2_NU
– Profile Display Name: AP_SHBYIV_MARK_UNACCT_INVOICE_EVENTS2_NU
– Application Payables
– Module: Invoices
– Description: Self Healing Profile NU
– Start Date: <Enter the date like MM/DD/YY>

Save and close.

Step 2 – Profile Option Levels for both profile options:

– Site level: Enable and Updateable

Step 3- Save and close.

Step 4- Navigate to: Setup and Maintenance -> Manage Administrator Profile Values, to set the profile option values

Search for Profile Option Code: AP_SHBYIV_ENABLE

Set Profile Values at:

* Profile Level = Site
* Profile Value = Y

Search for Profile Option Code: AP_SHBYIV_MARK_UNACCT_INVOICE_EVENTS2_NU

Set Profile Values at:

* Profile Level = Site
* Profile Value = <Invoice_id>

Step 5 – Then Navigate to ESS process scheduler UI and submit program “Validate Payable invoice” with invoice number parameter value set to <Enter invoice number>

Step 6 – Run accounting for the invoice and the accounting events will be marked as P/P without posting accounting entries.

Step 7 – Disable(End Date) two profiles, profile ‘AP_SHBYIV_ENABLE’ and profile ‘AP_SHBYIV_MARK_UNACCT_INVOICE_EVENTS2_NU’.

The invoice will be set as Accounted but actually will not post any accounted entries.

If Payment is created for such an invoice then follow the below steps to mark it as accounted as well.

1. Create profile option with code and name as AP_SHBYIV_ENABLE.
2. Set profile option value as Y for User
3. Create profile option with code and name as AP_SHBYIV_MARK_UNACCT_PAYMENT_EVENTS2_NU and Set profile option value as check_id for User
4. Login with same user and Run Invoice Validation ESS Job by passing Invoice Number as input parameter.
5. Run Create Accounting to complete the fix. The Create Accounting process will update the event status to P/P and posted_flags to Y
6. Delete the Profile option AP_SHBYIV_ENABLE and AP_SHBYIV_MARK_UNACCT_PAYMENT_EVENTS2_NU after transaction is corrected.

Leave a Reply

Your email address will not be published. Required fields are marked *