Invoice Workbench: Account Generator Does Not Override Prepayment GL Account (Doc ID 787885.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Payables - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

Setup-->Options-->Payables Options

Accounting Option

Prepayment Account - radio button "From Purchase Order" is selected.

Enter a pre_payment type invoice, the prepaid General Ledger account defaults in.

Enter a project, task, award, expenditure type etc..
and save get the message:

APP-SQLAP-97072 You changed Project-related information for
this transaction. Based on this new information,
Projects will rebuild the distribution accounts and overwrite existing
accounting information for your distribution lines.
Please update your distribution accounting information if necessary.

Account Generator is NOT called and the General Ledger account stays at the same value that was defaulted in. 

STEPS
The issue can be reproduced at will with the following steps:
1. Under Payables Manager Responsibility, Progress S&L
2. Enter a Invoice using the type of Prepaid NOT matched to a purchase Order
3. Select Lines put in the amount
4. Select Distributions
5. See the GL Account defaulted in.
6. Enter a Project, Task, Org, Expenditure Type, Expenditure Item Date
7. Save
8. Get error message
APP-SQLAP-97072 You changed Project-related infomration for
this transaction. Based on this new information,
Projects will rebuild the distribution accounts and overwrite existing
accounting information for your distribution lines.
Please update your distribution accounting information if necessary.
9.The GL account is NOT updated.
10. For Standard Invoices the GL Account does get updated.

Changes

When you upgrade to release 12, the prepayment account is a required field
Under a Payables Responsibility:
Navigate Setup-->Option-->Financial Options
Under the Accounting Tab
the GL Accounting Prepayment field is required.
Prepayment Field is a required field on the Financial Options - Accounting page.
OR
when you create a supplier, the prepayment field is defaulted in from the
system level, it can be changed, but must be populated.
THIS IS PRODUCT FUNCTIONALITY.

<Bug:5968405> exists as an enhancement request to allow POETA distributions
for prepayments to engage account generator to build the GL account.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms