R12: Requisition Import Of Requisition With Authorization Status As Approved Ending Up As Incomplete Requisitions (Doc ID 870995.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.0.6 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Apr-2011***
EXECUTABLE:POCIRM - Requisition Import


Symptoms

The requisition when imported as approved ends up as incomplete requisitions.  However when approved manually it approves.

The FND log files ( <Note 558435.1> - Process to generate FND Logs) shows the following

ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS 6 ORA-01403: no data found
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS 1 Inside DB ins line det factors No of records in tbl1, Inside DB First index1, Inside DB Last index1, p_insert_index1
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS.BEGIN 1 ZX_SRVC_TYP_PKG: DB_INSERT_LINE_DET_FACTORS()+

Steps to Reproduce :
1. Run requisition Import with the parameter 'Initiate approval after ReqImport' = Yes.
2. In requisition interface table, the 'AUTHORIZATION_STATUS' in the interface is 'APPROVED'.



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