What is Accounting Convention in 4C's - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/06/what-is-accounting-convention-in-4cs.html

The ledger is a basic concept in R12. The ledger replaces the 11i concept of a set of books. It represents an accounting representation for one or more legal entities or for a business need such as consolidation or management reporting.

1.      Chart of accounts

2.      Functional  Currency

3.      Accounting Calendar

4.      Accounting Convention

Convention: Importing the journals from other modules (AP, AR, FA, CM) in to GL

Conventional method means Sub ledger Accounting method. Importing the journals from other Modules (AP, AR, FA, CM) in to General Ledger (GL). For that purpose we are using the 4th'C (Sub ledger accounting method)

General Ledger Setup Steps - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/06/general-ledger-setup-steps-oracle-ebs.html

S.No	Steps
1	Create GL Responsibility
2	Attach Responsibility to User
3	Create COA (Segment & Values)
4	Enabling Functional Currency
5	Define Calendar
6	Create Legal Entity
7	Ledger Setup
8	Attach Legal Entity
9	Complete the Ledger
10	Profile Options for GL Responsibility: GL Ledger Name, GL: Data Access Set
11	Period Opening in GL
12	Document Sequencing

APPROVAL_STATUS_CODE

https://generalledger-gl.blogspot.com/2019/05/approvalstatuscode.html

The APPROVAL_STATUS_CODE shows the approval situation:

R is Required: cannot be selected for posting

Z is Not required: can be selected for posting

A is Approved: can be selected for posting but cannot be modified

J is rejected: must be reapproved or modified

I is In process: must wait for the approval

everything else is an error status

Can the Daily Rates form be inquiry only?

https://generalledger-gl.blogspot.com/2018/11/can-daily-rates-form-be-inquiry-only.html

Please try to do below steps:

1. Enter a new function for Daily Rates using Sysadmin responsibility

Navigation: Application > Function

2. Query the function: GLXRTDLY with  a User Function Name: Daily Rates

3. Create a new function logically the same as the old one however on the Form tab, indicate QUERY_ONLY="YES" on the Parameters field

4. Attached the newly created function on the Currency Rates Menu

Navigation: Application > Menu

Menu: GL_SU_S_C_RATES

Add the newly created by indicating the function name  on the Function field

5. To apply these inquiry only access on a specific responsibility, query the responsibility

Navigation: Security > Define > Query the responsibility

6. On the menu exclusions indicate the Function name of the old one (Daily Rates original as this is not limited to inquiry only) leaving the newly created one which is for inquiry only

8. Access the form

Hope this helps.

Query to get Account Segment Description

https://generalledger-gl.blogspot.com/2018/11/blog-post.html


SELECT gl_flexfields_pkg.get_description_sql 

 
(

chart_of_accounts_id,--- chart of account id
1,----- Position of segment
segment1 ---- Segment value
) 

 
FROM gl_code_combinations

How to check the user which posted GL Journal Batch - Oracle EBS R12

https://generalledger-gl.blogspot.com/2018/09/how-to-check-user-which-posted-gl.html

How to check the user which posted GL Journal Batch. 

Able to extract posted_date from gl_je_headers, but need to find also the user which posted the related journal.

SOLUTION

From GL_JE_HEADERS table, the LAST_UPDATED_BY field is the last person who made some changes.

From GL_JE_BATCHES table, the POSTED_BY field represents the user who posted the journal batch.

----------------------------------------------------------
select b.DOC_SEQUENCE_VALUE, d.user_je_category_name, c.USER_NAME Posted_by --264975
from gl_je_batches a, gl_je_headers b, fnd_user c, gl_je_categories d
where a.JE_BATCH_ID = b.JE_BATCH_ID
and a.POSTED_BY = c.USER_ID(+)
and b.JE_CATEGORY = d.je_category_name
--and d.user_je_category_name = 'Auto Reversal'
--and b.DOC_SEQUENCE_VALUE = 18000160
----------------------------------------------------------

Updating the Journal Template Layout Generates Error - NUMBERFORMATEXCEPTION - Oracle EBS R12

https://generalledger-gl.blogspot.com/2018/05/updating-journal-template-layout.html

While trying to update the Web ADI template layout for the General Leger Journal template the following error is received:

Error

The following error has occurred
Exception Name: java.lang.NumberFormatException
Log File Bookmark: 366432

Reference

Updating the Journal Template Layout Generates Error - NUMBERFORMATEXCEPTION (Doc ID 2181278.1)