Sep 10, 2016

on Leave a Comment

AP Create Accounting Error after Patching


The application accounting definition Accrual Basis owned by Oracle is not validated.  Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Standard Accrual. 


The AP staff told our DBA that the test instance gave the above error when they ran "Create Accounting".  Since the DBA just put some patches to this instance, it seemed that a new AAD definition was added but somehow it's not working well.
Within a few seconds, the DBA forwarded the email to me and said he had no clue about it.
Okay.  Here were the steps I did --

Run Import Application Accounting Definitions

AMB Context          - Default
Source File Pathname - @SQLAP:/patch/115/import/US/APXLAAAD.ldt
Merge Analysis: No
Batch Name:
Import Option: Overwrite
Validate: No
Force Overwrite: Yes

Run adadmin -> compile APPS schema

Run "Validate Application Accounting Definitions"

Subledger Accounting Application                Report Date:    10-SEP-16
                                    Application Accounting Definition Validation Report       Page:           1
    Application                  Application Accounting Definition        Owner     Event Class           Status
    ---------------------------- ---------------------------------------- --------- --------------------  ------
    Payables                     Accrual Basis                            Oracle    Credit Memos          Valid
    Payables                     Accrual Basis                            Oracle    Debit Memos           Valid
    Payables                     Accrual Basis                            Oracle    Future Dated Payments Valid
    Payables                     Accrual Basis                            Oracle    Invoices              Valid
    Payables                     Accrual Basis                            Oracle    Payments              Valid
    Payables                     Accrual Basis                            Oracle    Prepayment            Valid
                                                                                    Applications
    Payables                     Accrual Basis                            Oracle    Prepayments           Valid
    Payables                     Accrual Basis                            Oracle    Reconciled Payments   Valid
    Payables                     Accrual Basis                            Oracle    Refunds               Valid
                                                        End of Report

Ask AP staff to run Create Accounting again.  E-Mail to me, and cc DBA  if any problem.

0 comments: