Period End Close - Inventory

Uncosted Material Transactions Issues (Costed_Flag = 'E'):
SELECT 'UNCOSTED TXNS',
organization_id,
transaction_id,
TO_CHAR(creation_date,'DD-MON-YY HH24:MI:SS') creation_date,
request_id,
transaction_set_id,
transaction_group_id,
costed_flag, error_code, error_explanation, mmt.*
FROM mtl_material_transactions mmt
WHERE costed_flag IN ('E','N');
1. Error Code: Error in obtaining the transfer price
Resolution: Add the item to the source price list and re-process (by Material cost transaction worker).
_______________________
_______________________
Source: ORDER ENTRY
The stuck transaction can be viewed by using the below query:
SELECT * FROM Mtl_Transactions_Interface WHERE Lock_Flag = 1
2. Error Code: 100
Error Explanation: failure:Ele_Acct( 40 ): 100 Error populating code combination segments
Resolution:

Period End Close - Receivables

Period End Close - Receivables

Issue #1: 

Unposted Items Exist :

RA_CUST_TRX_LINE_GL_DIST_ALL

Solution: Run the 'General Ledger Transfer Program' for the org you're trying to close AR period for and try running the AR Close Period program again.

Period End Close - Inventory

Once closed, Inventory period can't be re-opened from Apps. Execute below to re-open a closed inventory period:

SELECT acct_period_id period, open_flag, period_name name,  
      period_start_date, schedule_close_date, period_close_date  
      FROM  org_acct_periods  
      WHERE organization_id = &org_id  
      order by 1,2;
UPDATE org_acct_periods 
SET open_flag = 'Y', 
period_close_date = NULL, 
summarized_flag = 'N' 
WHERE organization_id = &&org_id 
AND acct_period_id >= &&acct_period_id; 
DELETE mtl_period_summary 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id; 
DELETE mtl_period_cg_summary 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id; 
DELETE mtl_per_close_dtls 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id; 
DELETE cst_period_close_summary 
WHERE organization_id = &org_id 
AND acct_period_id >= &acct_period_id;  
commit

Period End Close - Payables

1. Check on Invoice on Hold Report – To ensure all of the invoices is not on Hold. This can be done by using ‘Invoice on Hold Report’

2. Check for Unapproved invoices – To ensure all invoices are approved before the month end closing. This can be done by using ‘Invoice Register’ with option of unapproved only.

3. Check for any unaccounted invoice or payment – To ensure all of the approved invoices and payments are accounted in the system. This can be done using ‘Unaccounted Transaction Report’.

4. Transfer all accounted invoices and payments to GL – To consolidate all of the invoices and payments to GL. This can be done using the ‘Payable Transfer to GL’ Program. At this stage the program will also automatically call up another program ‘Journal Import’ to import the Program to GL.

5. Run ‘Account Payable Trial Balance’ Report to reconcile with GL ‘Account Analysis with Subledger’ Report, with parameter “Source: Payables”. All of the amount in each account should be equal. If it is not equal, then AP and GL need to investigate, also GL Interface table has to be investigated

6. Run ‘Account Payable Trial Balance’ Report for last period.

7. Run ‘Posted Invoice Register’ report to view the invoice posted in this period.

8. Run ‘Posted Payment Register’ report to view the payment posted in this period.

9. Reconcile these reports according to this manner:

A/P Trial Balance (Current) = A/P Trial Balance (last month) + Posted Invoice Register – Posted Payment Register.

10.Close Current month period.

11.Open Next Period.

12.Sweep all of the left over invoices to next period.

Period End Close - General

Periods represent non-overlapping consecutive date ranges. Every Financials customer needs to successfully close the accounting books each period.
General Steps
Here are some guidelines, from a general perspective, how you can perform the close process for every subledger:
a) Complete transactions
b) Create accounting
c) Reconcile transactions
d) Post to General Ledger
e) Reconcile accounting
f) Close period

Step b), Create Accounting, is a new step in Release 12, as it is an SLA feature. The accounting can be created immediately online, or can be run as a process in the background e.g. as a batch job at a time that matches your business needs.
The important thing to note, is that the accounting is not the distribution on the transaction. The final accounting by SLA could result in different accounting entries being generated based on the accounting rules you have configured. Therefore, you need to ensure that all your accounting for your transactions is created before you post to General Ledger, in order to update the balances correctly.

In Release 11i, when you close your periods in each of the subledgers, Oracle General Ledger will automatically create the balancing lines for journals posted to General Ledger. This changes in Release 12 as subledger accounting creates the balancing lines at the time you account for the subledger transactions.

The subledger accounting journal represents your REAL accounting and the balancing lines are created as part of these subledger accounting journals. When you close a period in Release 12, you’re actually closing subledger accounting. The journals can then be posted to the general ledger to update the GL balances.

Period End Close Dependencies