My Oracle Support Banner

Close Purchasing Periods (Poxraf) Gets Error: Poxraf-001: Ora-01427 (Doc ID 2485860.1)

Last updated on APRIL 26, 2019

Applies to:

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

Symptoms

When running the program "Close Purchasing Periods" (short code = POXRAF) in a MOAC responsibility, the program finishes in an error.


A trace file reveals that the following sql is failling:
update PO_DISTRIBUTIONS_ALL  set ACCRUED_FLAG='N',LAST_UPDATED_BY=:b0
where  (ACCRUED_FLAG='Y' and SET_OF_BOOKS_ID=(select SET_OF_BOOKS_ID  from
  FINANCIALS_SYSTEM_PARAMETERS ))
 
 
Workaround: Using responsibility without MOAC (only 1 OU)

Error:
Cause:        POXRAF encountered an internal error.  Parameters: POXRAF,
Action:        Note both this error number and the actions you are trying to perform. Contact your system administrator for
POXRAF-001: ORA-01427: single-row subquery returns more than one row


Replication:
The issue can be reproduced at will  in a MOAC responsibility (with multiple OU.)
 
1. Purchasing responsibility > Setup > Financials > Accounting > Control Purchasing Periods
Choose “Closed” for Period.

2. System Administrator responsibility

Choose « Control Purchasing Periods » function
Choose an operating unit
Restrict to year and search the periods
Choose “Closed” for Period
A process is started
Completed Error

Changes

 

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