Monday 24 June 2019

This Application Function is not Configured to any Integrator - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/06/this-application-function-is-not.html

This Application Function is not Configured to any Integrator 

You have selected the menu or function ending with "_G". Please select the menu or function without ending with "_G"

Clear the Cache

SQLGL: Journals_120 is an invalid integrator key. - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/06/sqlgl-journals120-is-invalid-integrator.html



Add: "Desktop Integration - Create Document" function into the menu

Clear the Cache

Tuesday 18 June 2019

WEBADI Error: "You Don'T Have Permission To Access This Functionality - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/06/webadi-error-you-dont-have-permission.html


Navigate to GL Responsibility Journals > Launch Journal Wizard

The below error occurs:





Navigate to System Administrator > Responsibilities from which it is erroring

Query the Menu assigned to the Responsibility

Navigate to Menu





Add Function: Desktop Integration - Create Document
Add Menu: GL_JOURNAL_ADI_HOME_MENU


Clear Cache

Now Navigate to GL Responsibility and check

Please Refer to oracle Note: 374066.1

Oracle Web ADI Error : You Do Not Have Permission To Access This Functionality - Oracle EBS R12

https://generalledger-gl.blogspot.com/2019/06/oracle-web-adi-error-you-do-not-have.html

Navigate to GL Responsibility Journals > Launch Journal Wizard > Select Layout > Create Document


The below error occurs:




Please set the Profile Option value of "BNE Disable" to N at the user/responsibility level.

Clear the Cache and check.


Please refer to Oracle Note: 2122502.1

Tuesday 4 June 2019

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