APXINWKB.fmb APP-SQLAP-97734 When Entering a Recurring Invoice With Closed Project/Task (Doc ID 779704.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Grants Accounting - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On 12.0.4 when attempting to open the distributions on a Recurring Payables Invoice with a distribution
set that contains a project whose status has been set to closed. the following error occurs.

ERROR
APP-SQLAP-97734 The system cannot generate distributions for line 1 because &ERROR occurred
in &CALLING SEQUENCE with parameters (&PARAMETERS)
while performing the following operation: &DEBUG_INFO

STEPS
The issue can be reproduced at will with the following steps:

(1) Payables Manager, Progress S&L
Navigate
Setup-->Entry-->Distribution Sets

(2) Setup Distribution Set using project A

(3) Responsibility Grants Accounting

Change status of project A to closed

(4) Payables Manager, Progress S&L
Invoices-->Entry-->Recurring Invoices

(5) Setup Recurring Invoice using Distribution Sets already setup

(6) Created DP-Recurring- Invoice


(7) Navigate Invoices-->Invoices-->Entry
F11 - Query up Recurring Invoice

(8)  Press distributions get the error:

APP-SQLAP-97734 The system cannot generate distributions for line 1 because &ERROR occurred
in &CALLING SEQUENCE with parameters (&PARAMETERS)
while performing the following operation:
&DEBUG_INFO

click ok - it takes you to a blank distribution line - but you have no idea why the error occurred.

(9) Go back and change status of project to ACTIVE

(10) Navigate Invoices-->Invoices-->Entry
F11 - Query up DP-Recurring-Oct-06

(11) Distributions
Get same error.

(12) Can cancel the invoice.


.

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