R12: Error Occurs When Trying To Autocreate a Requisition Into a Complex Purchase Order Using Document Builder Functionality (Doc ID 1580842.1)

Last updated on FEBRUARY 25, 2016

Applies to:

Oracle Purchasing - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to autocreate a purchase requisition into a Service PO, using Document Builder, the following error occurs.

Error

Document was not created. Possible causes:
1) An exception occurred in the PO Account Generator workflow during the document creation process.
2) Some other error occurred during the document creation process.

Encumbrance is active.
Standard PO's can be created without any problem.

Next Error can be seen in the FND Logs:

po.plsql.PO_PERIODS_SV.GET_PERIOD_NAME.BEGIN 2 Start of subprogram.
po.plsql.PO_PERIODS_SV.GET_PERIOD_NAME.000 1 x_sob_id = 2021
po.plsql.PO_PERIODS_SV.GET_PERIOD_NAME.000 1 x_gl_date = 21-AUG-2013 11:56:15AM
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.000 1 p_date_tbl(1) = 21-AUG-2013 11:56:15AM
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.040 1 set of books passed
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.120 1 x_invalid_period_flag = T
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_period_name_tbl.COUNT = 1
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_period_name_tbl(1) is null
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_period_year_tbl.COUNT = 1
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_period_year_tbl(1) is null
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_period_num_tbl.COUNT = 1
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_period_num_tbl(1) is null
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_quarter_num_tbl.COUNT = 1
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_quarter_num_tbl(1) is null
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.900 1 x_invalid_period_flag = T
po.plsql.PO_PERIODS_SV.GET_PERIOD_INFO.END 2 End of subprogram.
po.plsql.PO_PERIODS_SV.GET_PERIOD_NAME.020 1 x_gl_period is null
po.plsql.PO_PERIODS_SV.GET_PERIOD_NAME.END 2 End of subprogram.
po.plsql.PO_INTERFACE_S.create_payitem_dists50.EXCEPTION 4 Unable to find period name for SYSDATE;SQLERRM = ORA-0000: normal, successful completion
po.plsql.PO_INTERFACE_S.create_payitem_dists50.EXCEPTION 4 1User-Defined Exception;SQLERRM = User-Defined Exception



Steps to Reproduce

1. Go to Buyer Work Center > Requisitions> Search for Requisitions Lines
2. Select PR lines > press on Add button
3. On the Document Builder set Document Style to the one used for Complex PO's
4. Press on Create button > error occurs

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