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.
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
Workaround: Using responsibility without MOAC (only 1 OU)
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
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
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