My Oracle Support Banner

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

Last updated on JULY 11, 2020

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


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 1 Inside DB ins line det factors No of records in tbl1, Inside DB First index1, Inside DB Last index1, p_insert_index1

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'.


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.