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 laterInformation 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:
**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.
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 |