Wednesday, 28 February 2018

R12.2.5 Form Monitor Application Users (FNDSCMON.fmb) Does Not Display All Users

The Monitor User screen does not show all users who are logged in in the system. Some time it was showing single row with latest login user.

Issue resolve by applying the patch Patch 23263396.

Please refer the document 
12.2 E-Business Suite Form Monitor Application Users (FNDSCMON.fmb) Does Not Display All Users In 12.2, As Data Is Lost When Users Logout (Doc ID 2275716.1)

Friday, 23 February 2018

Can we assign multiple Grade in a single Lot or How To Assign Multiple Grades to a Single Lot Number on Inventory Transactions

This requirement is not supported.
Per the design of the e-business suite, a lot has one grade value only. If there are multiple grades then it is different lots.

See for instance Oracle Inventory User's Guide Release 12.1 Part No. E13450-02, CH 12 On-hand and Availability, Item Reservations. The following is said:
"A lot can have only one grade at any given
moment, and grades can change over time.
"



Similarly, go to Item Lots / Maintain Lot Numbers form (INVTDILT):
Inventory: (N) On-hand, Availability : Lots
This form is for creating, maintaining or just reviewing lots.
See there is a field "Grade" and there is no way to assign nor display multiple grade values for same lot.

Friday, 9 February 2018

GST Account code list / How many account is required to setup GST


Account Name Account Nature
IGST Interim Rcovery Rcovery Account
CGST Interim Rcovery
SGST Interim Rcovery
UGST Interim Rcovery
IGST Interim Liability Liability Account
CGST Interim Liability
SGST Interim Liability
UGST Interim Liability
IGST Expence Account  Expence Account 
CGST Expence Account 
SGST Expence Account 
UGST Expence Account 
IGST Cash Ledger Cash Ledger
CGST Cash Ledger
SGST Cash Ledger
UGST Cash Ledger
IGST Rounding Account Rounding Account
CGST Rounding Account
SGST Rounding Account
UGST Rounding Account
IGST Advance Suspence Advance Suspence
CGST Advance Suspence
SGST Advance Suspence
UGST Advance Suspence
IGST Suspence Account Suspence Account
CGST Suspence Account
SGST Suspence Account
UGST Suspence Account
IGST Recovery Rcovery Account
CGST Recovery
SGST Recovery
UGST Recovery
IGST Liability Liability Account
CGST Liability
SGST Liability
UGST Liability



 

 

 














































































 

 

 













































































 
 
 

GST normal tax rates


Tax Type Code Tax Rate Code
IGST IGST_0%
IGST IGST_5%
IGST IGST_12%
IGST IGST_18%
IGST IGST_28%
CGST CGST_0%
CGST CGST_2.5%
CGST CGST_6%
CGST CGST_9%
CGST CGST_14%
SGST SGST_0%
SGST SGST_2.5%
SGST SGST_6%
SGST SGST_9%
SGST SGST_14%

GST State Code and Name List


Reporting Code Reporting Code Description 
01 Jammu and Kashmir
02 Himachal Pradesh
03 Punjab
04 Chandigar
05 Uttarakhand
06 Haryana
07 Delhi
08 Rajasthan
09 Uttar Pradesh
10 Bihar
11 Sikkim
12 Arunachal Pradesh
13 Nagaland
14 Manipur
15 Mizoram
16 Tripura
17 Meghalaya
18 Assam
19 WEST BENGAL
20 Jharkhand
21 Orissa
22 Chhattisgarh
23 Madhya Pradesh
24 Gujarat
25 Daman and Diu
26 Dadra and Nagar Haveli
27 Maharashtra
28 Andhra Pradesh
29 Karnataka
30 Goa
31 Lakshadweep
32 Kerala
33 Tamil Nadu
34 Puducherry
35 Andaman and Nicobar Islands

GST Tax Authority List

We need to define multiple Tax authority to accommodate GST requirement. All the tax authority need to setup as supplier in EBS.


Authority name Type
Custom Authority of India India Tax Authority
GST Tax Authority of India India Tax Authority
GST Tax Authority of India (Transit) India Tax Authority
GST Commissioner of Income Tax India Tax Authority

GST Patch List with RUP 11 for R12.2.X


 Path to GST Implementation - Patch Details For 12.2.X :
Patch 19283503:R12.GL.C India GST functional patch
Patch 22005246:R12.FND.C India GST functional patch
Patch 26153906:R12.JAI.C India GST functional patch
Patch 26194366:R12.JAI.C TDS Migration Patch
Patch 26273448:R12.JAI.C TDS Migration Patch
Patch 26003443:R12.JAI.C GST Enablement patch
Patch 26171921:R12.JAI.C TDS Enablement patch
Patch 26576846:R12.JAI.C RUP-9
Patch 26657833:R12.JAI.C GSTR 3B
Patch 26704259:R12.JAI.C GSTR1 Report
Patch 26720651:R12.JAI.C GSTR2 Report
Patch 26492480:R12.JAI.C DOCUMENT SEQUENCE 
Patch 27421320:R12.JAI.C RUP 11