My Oracle Support Banner

RVCTP Not Generating Approval Notifications For Work Confirmation ( WC ) Created in iSupplier Portal / ORG_ID Is Null In RHI / RTI (Doc ID 1637837.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle iSupplier Portal - Version 12.1.3 and later
Oracle Services Procurement - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Find Receiving Transaction Processor is Not Generating Approval Notifications for Work Confirmation  / Status does not change from ' Processing ' to ' Pending Approval '.

In R 12.1.1 customer created work confirmation for OU <ORG ID>.
To generate the approval notification for Work Confirmation he was running Receiving Transaction Processor for specific <ORG ID> Operating Unit.
It generated Approval notifications for work confirmation successfully.

But in R12.1.3 when doing the same process the system is not generating any notification. If running Receiving Transaction Processor program with blank parameters then its generating approval notifications for work confirmation, which should not be.
 
It has been found that the cause is New Work Confirmations created in iSupplier Portal (iSP) in 12.1.3 are generated in RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE with NULL ORG_ID.
As a consequence when RVCTP is run for a specific operating Unit no records are selected / processed.
(but instead they are processed when RVCTP is run WITHOUT specifying a specific operating unit <ORG ID>)

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

Note: The numbers / values shown below are fictitious values for example purposes only

1) Create  Complex Purchase Order 99999 as Buyer 

2) Create Work Confirmation from either supplier or buyer in iSupplier Portal
Work confirmation = WC99999
Status = Processing
 
In RCV_HEADERS_INTERFACE table

3) Run Receiving Transaction Processor RVCTP for <ORG ID> Operating Unit parameter

4) Log File RVCTP Module Receiving Transaction Processor completes successfully but does not do anything

5) No Approval Notification is generated

6) Run again Run Receiving Transaction Processor with blank parameters (Means No OU mentioned)

7) Now approval notification is generated
Work Confirmation for <VALUE> form shows
Work confirmation has
Status = Pending Approval
 

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
References


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