My Oracle Support Banner

Custom Call To The Receipt Traveller Concurrent Program Errors Out During Receiving - PLS-00306: wrong number or types or arguments in call to LABEL_WRAPPER (Doc ID 2852001.1)

Last updated on APRIL 04, 2023

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Receipt Traveller Concurrent Program is failing with the following errors as seen in the concurrent request log:

   **SQL error and free**
   **Oracle error 6550 in FDPSTP

   Cause: FDPSTP failed due to ORA-06550: line 1, column 7
   PLS-00306: wrong number or types or arguments in call to 'LABEL_WRAPPER'
   ORA-06550: line1, column 7:
   PL/SQL: Statement ignored


To accommodate a requirement to print label(s) when Receipt Traveller Concurrent Program is launched in Receiving,
we have incorporated a custom procedure that launches instead of the actual Receipt Traveller Concurrent Program.
The custom procedure prints the label and then calls the actual Receipt Traveller Concurrent Program (renamed within
the application) with a call to fnd_request.submit_request.
 

In the application without any customization the following is the behavior:

1. You Save the Receipt.

2. This causes Receiving code to launch Receiving Transaction Processor
    -and-
   "Receipt Traveller Concurrent Program" (SHORT NAME=RCVDLPDT)

3. SHORT_NAME "RCVDLPDT" is executable POXDLPDT which is REPORT POXDLPDT.rdf

4. REPORT POXDLPDT.rdf is what is actually run
and the parameters passed to it are what is seen in INVRCVPB.pls

5. "RCVDLPDT" is run, the REPORT POXDLPDT.rdf needs to accept the parameters passed to it from the fnd_request.submit_request call in INVRCVPB.pls


In the application with the implemented customization the following is the behavior:

1. You Save the Receipt.

2. This causes Receiving code to launch Receiving Transaction Processor
-and-
"Receipt Traveller Concurrent Program" (SHORT NAME=RCVDLPDT)

3. SHORT_NAME RCVDLPDT is:

EXECUTABLE XYZPOXDLPDT
EXECUTION METHOD PL/SQL Stored Procedure
EXEUTION FILE NAME XYZ_PO_PRINT_CUSTOM_LABEL

4. PROCEDURE XYZ_PO_PRINT_CUSTOM_LABEL

Does some processing
Makes following call:
FND_REQUEST.SUBMIT_REQUEST (
APPLICATION => 'PO',
PROGRAM => 'XYZRCVDLPDT', --'XXRCVDLPDT',
DESCRIPTION => NULL,
START_TIME => SYSDATE,
SUB_REQUEST => FALSE,
ARGUMENT1 => P_GROUP_ID,
ARGUMENT2 => P_RECEIPT_SOURCE_TYPE,
ARGUMENT3 => P_QTY_PRECISION,
ARGUMENT4 => P_ORG_ID);

 

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
Symptoms
Cause
Solution


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