Order to Cash (O2C) Accounting Entries

Order to Cash Accounting Cycle :
Below table show the order to cash accounting entries creation for each level

PARTICULARS	DR	CR	SPL NOTES	ACCOUNT IS PULLED FROM
Sales order entry
No Accounting
Sales Order Pick
From Sub Inventory A/c		100	At Standard Cost	Sub-inventory Material A/c Setup
To Sub Inventory A/c	100		At Standard Cost(Staging)	Sub-inventory Material A/c Setup
Sales Order Issue
COGS	100		It can be fetched from five places	Master Item/Org/Order Type/Line Type/Shipping Params
To Sub Inventory A/c		100	At Standard Cost	Sub-inventory Material A/c Setup
Transaction level
Receivable A/c	120			Auto Accounting
Tax A/c		10		Auto Accounting
Freight A/c		10		Auto Accounting
Revenue A/c		100		Auto Accounting
Receipts
Receipts with no remittance method
Cash	100		Before application of the receipt	Receipt class
Unapplied A/c		100		Receipt class
Unapplied A/c	100		After application of the receipt to the transaction	Receipt class
Receivables A/c		100		Receipt class
Cash A/c	100			Receipt class
Unidentified A/c		100	In case of receipt without customer or transaction	Receipt class
Unidentified A/c	100		when customer identified	Receipt class
Unapplied A/c		100		Receipt class
Receipts with remittance method.
Confirmed receipts A/c	100		At the time receipt entry	Receipt class
Unapplied A/c		100		Receipt class
Remitted receipts A/c	100		On remittance to bank	Receipt class
Confirmed receipts A/c		100		Receipt class
Cash	100		On clearance of cheque	Receipt class
Remitted receipts A/c		100		Receipt class
Receipts with discount/unearned discounts
Cash	90		At the time earned discounts	Bank
Discount earned A/c	10			Receivable activity
Receivable A/c		100		Transaction Type
Cash	90		At the time of unearned discount	Bank
Discount unearned A/c	10			Receivable activity
Receivables A/c

Procure to Pay (P2P)–Accounting Entries

As you know "procure to pay" Business Flow start Purchasing requisition till paying to vendors and most important, in all the case the purchase is made for basic element called Items.
As you know there are three types of items:

• Inventory Expense Item
• Inventory Asset Item
  
• Expense item

Above three Items are creating the account like below changes :

I		EXPENSES ITEM CASE:-
			Debit	Credit
	1	PO Creating
		No Entry	-	-
	2	Create Receipt
		Inventory Receiving A/C	XXX
		Accrual A/C		XXX
	3	Inspection
		No Entry	-	-
	4	Receiving Transaction
		Expenses A/C	XXX
		Inventory Receiving A/C		XXX
	5	Payable Invoice when Matched to PO
		Accrual A/C	XXX
		Liability A/c		XXX
	6	Vendor Payment
		Liability A/c	XXX
		Bank Clearing A/c		XXX
	7	When dearer In bank
		Bank Clearing A/c	XXX
		Bank A/c		XXX
II		INVENTORY ITEM CASE:-
	1	PO Creating
		No Entry	-	-
	2	Create Receipt
		Inventory Receiving A/C	XXX
		Accrual A/C		XXX
	3	Inspection
		No Entry	-	-
	4	Delivery of Item
		Inventory Validation A/c	XXX
		Inventory Receiving A/C		XXX
	5	Payable Invoice when matching to PO
		Accrual A/C	XXX
		Liability A/c		XXX
	6	Payment Made to Vendor
		Liability A/c	XXX
		Bank Clearing A/c		XXX
	7	When Clearing In Bank
		Bank Clearing A/c	XXX
		Bank A/c		XXX
	8	Inventory Issued to Department
		Expenses A/c	XXX
		Inventory Validation A/c		XXX
III		ASSEST ITEM CASE:-
	1	PO Creating
		No Entry	-	-
	2	Create Receipt
		Inventory Receiving A/C	XXX
		Accrual A/C		XXX
	3	Inspection
		No Entry	-	-
	4	Receiving Transaction
		Assets Clearing A/c	XXX
		Inventory Receiving A/C		XXX
	5	Payable Invoice when matching to PO
		Accrual A/C	XXX
		Liability A/c		XXX
	6	Payment Made to Vendor
		Liability A/c	XXX
		Bank Clearing A/c		XXX
	7	When Clearing In Bank
		Bank Clearing A/c	XXX
		Bank A/c		XXX
	8	When Assets addition done and capitalized in FA Module
		Assets A/c	XXX
		Assets Clearing A/c		XXX

APP-ONT-251213: Error: Please enter valid address elements: STATE, CITY.

Fix:

If you are using oracle application version 12.1.1 this error will occur

Please Apply 12.1.3 patch using this support note:

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

(or)

Follow the below step to install this  Patch 9294165 and fix this issue.
 
1. Download and review the readme and pre-requisites for Patch 9294165 R12.ONT.B 

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file version:
OEXOEINL.pld 120.19.12000000.10

You can use the commands like the following:
strings -a $ONT_TOP/filename |grep '$Header'

5. Retest the issue.  

How to find attached Responsibility to Application User

The below query used to find the which responsibility attached to which user

User user responsibility name instated of 'Bill of Material', so you will get to know whom are all attached this responsibility with user name.

 SELECT fu.user_name, fr.responsibility_name, furg.start_date, furg.end_date
  FROM fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
 WHERE fr.responsibility_name = 'Bills of Material'---Enter the responsibility name
   AND fu.user_name = user_name
   AND furg.user_id = fu.user_id
   AND furg.responsibility_id = fr.responsibility_id
   AND fr.LANGUAGE = USERENV ('LANG')