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 NOVEMBER 01, 2020

Applies to:

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 = <SOB_ID>
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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.