Control Payables Period not Close

[rana.abdulwahid]

Dear All,

Control Payables Period not Close, Exception shows not data.
Navigation is Payable --> Control Payable Period
When close the period of Jul-09 and save it show the error, screen shot has been attached.
Please help me in this regards urgently.

Regards,
Rana Abdul Wahid


[img]/images/icon_zip.gif[/img] <b>Attachment:</b> period-close.zip <i>( 34451bytes )</i>

[oteixeira]

Hello.
The message means that you have unaccounted transactions in the period and, therefore, those transactions have not been transferred to GL. You cannot close the period while those transactions remain unaccounted. You should run the Unaccounted Transactions Report to review that transactions, account and transfer them to GL and then try to close the period.

Octavio

[rana.abdulwahid]

Hi,

Unaccounted Transactions Report have no data.

Rana Abdul Wahid

[tgs100]

I would suggest you to create a service request with oracle support to analyze the issue.

Also you can download the period close diagnostic scripts available in the metalink and run the same to find the problematic records.

Cheers,
Saravanan

[admin]

Also try to use the following query to find if any unaccounted transaction,

select invoice_id,
invoice_payment_id,
check_id,
posted_flag,
accrual_posted_flag
from ap_invoice_payments_all
where (posted_flag != 'Y'
or accrual_posted_flag != 'Y')
and period_name = '<period_name>'
and set_of_books_id = <set_of_book_id>;

[tgs100]

One more point.

If you have more than one operating unit, then run the exceptions report in all the OUs and find out if there are any error records exist. You can not close the period unless transactions in all the OUs under the SOB are accounted and transfered.

Cheers,
Saravanan

[AmanKhan]

HI Saravanan,

In R12 you don't need to try period closing in each OU, if u try to close period in one OU then payables lists exceptions in all OUs.

Regards,

Aman

[tgs100]

Hi Aman,

Thanks for the info. I am not sure in which version Abdul Wahid is working on...

Cheers,
Saravanan

[AmanKhan]

I believe that there is no difference in 11i and R12 period closing, AP periods are defined according to OUs. Plz correct if i am wrong.

Regards,