R12: AP: Invoice Approval Workflow Program (APXIAWRE) Completes With Errors: REP-0736, REP-1247, REP-0069 (Doc ID 2886705.1)

Last updated on DECEMBER 07, 2023

Applies to:

Oracle Payables - Version 12.2.11 and later
Information in this document applies to any platform.
R12: AP: Invoice Approval Workflow Program (APXIAWRE) Completes With Errors: REP-0736, REP-1247, REP-0069

Symptoms

"Invoice Approval Workflow" program (APXIAWRE) ends in error.

The request standard log file shows the following:

APXIAWRE: Invoice Approval Workflow
+---------------------------------------------------------------------------+
Current system time is 25-MAY-2022 12:51:51
+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------

------------
Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :
AMERICAN_SAUDI ARABIA.AR8ISO8859P6
'.,'
BINARY
Enter Password:

REP-0004: Warning: Unable to open user preference file.
REP-0736: There exist uncompiled program unit(s).
MSG-00001: After SRWINIT
REP-0736: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1247: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.

Report Builder: Release 10.1.2.3.0 - Production on Wed May 25 12:51:52 2022
Copyright (c) 1982, 2005, Oracle. All rights reserved.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 9952901.

Review your concurrent request log and/or report output file for more detailed information.
Successfully resubmitted concurrent program APXIAWRE with request ID 9954683 to start at 25-MAY-2022 16:51:52 (ROUTINE=AFPSRS)

Notice the highlighted log lines.

Steps to reproduce:

Log into Oracle Applications using a Payables responsibility.
Open the "Standard Request Submission" (SRS) screen
(N) Other > Requests > Run
Run the concurrent program "Invoice Approval Workflow"
Wait the request to complete in error.
Review the request Log file. The above errors are listed.

An output of the WFStat.sql script executed for an Invoice processed by the concurrent, shows the following:

...

**** Errored Activities


Activity	RESULT	Error Name	Error Message	Error Stack
PROCESS_SUB_APPROVAL_RESPONSE	#EXCEPTION	-6550	ORA-06550: line 1, column 23: PLS-00302: component 'PROCESS_SUB_APPROVAL_RESPONSE' must be declared	Wf_Engine_Util.Function_Call(AP_WORKFLOW_PKG.PROCESS_SUB_APPROVAL_RESPONSE, APINVAPR, 2015898-1, 276219, RUN)

*** Error Process Activity Statuses


Begin Date	Activity	Status	RESULT	User	NID	Status
29-MAY-22 10:59:26	ROOT/DEFAULT_ERROR	ACTIVE	#NULL
29-MAY-22 10:59:26	DEFAULT_ERROR/START-1	COMPLETE	#NULL
29-MAY-22 10:59:26	DEFAULT_ERROR/INITIALIZE_ERROR	COMPLETE	COMPLETE
29-MAY-22 10:59:26	DEFAULT_ERROR/DEFAULT_RESET_ERROR_NTF	NOTIFIED		SYSADMIN	6867529	OPEN

...

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

R12: AP: Invoice Approval Workflow Program (APXIAWRE) Completes With Errors: REP-0736, REP-1247, REP-0069 (Doc ID 2886705.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

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