Use the following queries to check the status of accounting periods. Be sure to substitute the relevant start and end dates as needed.

 SELECT FA.APPLICATION_NAME, SOB.NAME LEDGER, GPS.PERIOD_NAME,

       GPS.PERIOD_NUM, GPS.START_DATE, GPS.END_DATE, GPS.CLOSING_STATUS,

       DECODE(CLOSING_STATUS,'O','Open', 'C','Closed', 'F','Future', 'N','Never', CLOSING_STATUS) GL_STATUS

  FROM GL_PERIOD_STATUSES GPS,

       GL_SETS_OF_BOOKS SOB,

       FND_APPLICATION_VL FA

 WHERE 1=1 

   --AND FA.APPLICATION_NAME = 'General Ledger'

   AND SOB.NAME LIKE 'Vision Operations (USA)%'

   AND SOB.SET_OF_BOOKS_ID=GPS.SET_OF_BOOKS_ID

   AND FA.APPLICATION_ID = GPS.APPLICATION_ID

   --AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'

   --AND GPS.CLOSING_STATUS = 'O'

   AND PERIOD_NAME ='Jun-25'

   

How to find GL Code Combination ID and Description

Find GL Code Combination ID & Description

SELECT    gcc.segment1

       || '.'

       || gcc.segment2

       || '.'

       || gcc.segment3

       || '.'

       || gcc.segment4

       || '.'

       || gcc.segment5      ACCOUNT_CODE,

          a1.description

       || '-'

       || a2.description

       || '-'

       || a3.description

       || '-'

       || a4.description

       || '-'

       || a5.description    ACCOUNT_DECS

  FROM fnd_flex_values_vl    A1,

       fnd_flex_values_vl    A2,

       fnd_flex_values_vl    A3,

       fnd_flex_values_vl    A4,

       fnd_flex_values_vl    A5,

       gl_code_combinations  gcc

 WHERE     a1.flex_value = gcc.segment1

       AND a1.flex_value_set_id IN

               (SELECT FLEX_VALUE_SET_ID

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT1')

       AND a2.flex_value = gcc.segment2

       AND a2.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT2')

       AND a3.flex_value = gcc.segment3

       AND a3.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT3')

       AND a4.flex_value = gcc.segment4

       AND a4.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT4')

       AND a5.flex_value = gcc.segment5

       AND a5.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT5')

PLSQL query to find Open/Close status of Periods - Oracle EBS R12

 /* Formatted on 5/6/2025 9:55:34 AM (QP5 v5.381) */

select * from GL_PERIOD_STATUSES

select * from GL_PERIOD_STATUSES_V

SELECT * FROM GL_LEDGERS where name ='Vision Operations (USA)'

SELECT NAME,

       LEDGER_ID,

       period_name,

       APPLICATION_NAME,

       status

  FROM (SELECT ff.NAME                  NAME,

               kk.LEDGER_ID,

               kk.PERIOD_NAME,

               jj.APPLICATION_NAME,

               period_year,

               start_date, end_date,

               DECODE (kk.CLOSING_STATUS,

                       'O', 'Open',

                       'C', 'Closed',

                       'F', 'Future',

                       'N', 'Never')    STATUS

          FROM GL_PERIOD_STATUSES_V kk, fnd_application_vl jj, gl_ledgers ff

         WHERE     1 = 1

               AND jj.APPLICATION_ID = kk.APPLICATION_ID

               AND ff.LEDGER_ID = kk.LEDGER_ID

               AND kk.CLOSING_STATUS != 'N')

               where name ='Vision Operations (USA)'

               --and period_year = 2024

               and APPLICATION_NAME='General Ledger'

UNION

(SELECT 

        fbc.BOOK_TYPE_CODE                                         NAME,

        fbc.set_of_books_id                                        LEDGER_ID,

        fdp.period_name,

        'Assets'                                                   APPLICATION_NAME,

        DECODE (fdp.period_close_date, NULL, 'Open', 'Closed')     status

   FROM fa_book_controls fbc, fa_deprn_periods fdp

  WHERE     fbc.book_type_code = fdp.book_type_code

        AND fbc.DATE_INEFFECTIVE IS NULL)

how to increase session timeout in oracle apps r12

 how to increase session timeout in Oracle apps r12

Find Profile name ICX:Session Timeout

Default : None

Recommendation : 30 (minutes)

Oracle EBS Functional Financials - Accounts Receivable setups - R12

 1. Oracle Receivables -> Setup -> System ->System Options 

   a. Receivable GL related setup

   b. Transaction and Customer-related setup

   c. Miscellaneous

   e.g., Vision Operations (USA)

   

2. Oracle Receivables -> Setup -> Transactions -> Transaction Types 

   a. Unit, Class, Transaction status, Invoice Type mapping

   b. Receivable Account GL 

   c. Revenue Account GL

   d. Tax Account GL 

   e. other GL setups

   e.g. Auto SRV CHG Invoice , BR - Drawee Issued

 

3. Oracle Receivables -> Setup -> Transactions -> Sources

   a. Transaction Source naming & Setup

   e.g. Intercompany, Manual Order Entry

4. Oracle Receivables -> Setup -> Transactions -> Memo Lines

   a. Standard Memo Lines ( Name, Type, Revenue Account definition)

5. Oracle Receivables -> Setup -> Transactions -> Accounting Rules 

   a. Type and Schedule 

6. Oracle Receivables -> Setup -> Transactions -> Payment Terms 

   a. Billing Cycle, Payment schedule, Amount, Discounts 

7. Oracle Receivables -> Setup -> Transactions -> AutoAccounting

   a. Operating Unit, Type and Segment setup

8. Oracle Receivables -> Setup -> Receipts -> Receivable Activities

   a. Operating Unit, Type, Accounting Mapping 

9. Oracle Receivables -> Setup -> Receipts -> Receipt Classes

   a. Collection Method, Remittance Method, Clearance Method mapping

   b. Remittance Banks and GL Account Mapping 

10. Oracle Receivables -> Setup -> Receipts -> Receipt Sources 

   a. Automatic & Manual, Batch numbering 

11. GL Super User Responsibility -> Setup -> Financials -> Flexfields -> Key -> Values

    a. Find Key Flexfield Segment (First Window)

       Application: General Ledger

       Title: GL Ledger FlexField

    b. Segment values ( Second Window)

Oracle Receivables Implementation Guide

https://docs.oracle.com/cd/E18727-01/doc.121/e13510/T447343T355914.htm

https://www.oracleerpappsguide.com/2013/01/r12-receivables-setups-ar-in-oracle-apps.html

Oracle EBS Vision Instance Installation on VirtualBox

A. 

Download and install VirtualBox There are possibilities of different versions based on your Operating System. Here we worked with VirtualBox-6.1.14-140239-Win

B. Download EBS Software

On the  Oracle Software Delivery Cloud page: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

1. Login with your credentials

2. Search by Oracle VM Virtual Appliance for Oracle E-Business Suite

3. Select Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6

4. Continue in the Download Queue

5. Accept Licence & Download

6. A software for download will be downloaded name eg.Oracle_SSN_DLM_12130645.exe

7. Unzip All the files by any utility like winzip or 7zip etc.

8. Merge the unzip files with command prompt in the following way 

type Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.00 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.01 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.02 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.03 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.04 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.05 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.06 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.07 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.08 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.09 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.10 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.11 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.12 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.13 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.14 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.15 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.16 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.17 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.18 > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

It takes at least 1 to 2 hours or even more based on your Processor/Memory to get the merged file.

9. Import Appliance

At this stage, you should have at least 400 gigabytes or the process aborts. You may need to delete the zip files to make room for the import.

10. 

Adjust RAM memory keep 30% for Main CPU. Also adjust Graphics controller to VMSVGA 

For Networking, you can attach Adapter as:

Bridged Adapter (the default setting)

NAT or Host-Only Adapter.

11. Start the VM

      Set the IP when it is prompted 

12. Login & Password reset

     

13. EBS demo Application install

At a certain point during the post-install process you will be prompted to:

select whether to add start or stop of the database and application tier processes to the OS boot script.

Enter VISION to configure the Vision Demo instance.

14. Step – 5 Access to E-Business suite VISION.

To access the EBS Application from your website you will have to make minor changes in the

Windows host file by:

Getting the IP address of the VM using ifconfig -a on the terminal.

Edit the file on your Windows, add a line in c:\windows\system32\drivers\etc\hosts

(You may have to temporarily change permissions if you do have Administrator privileges)

<IP address> apps.example.com apps

Use an SSH client, like Putty to ssh to the file system and explore the operating system installation.

To Start the application

/u01/install/APPS/fs1/inst/apps/EBSDB_apps/admin/scripts

./adstrtal.sh apps/apps

Use http://apps.example.com:8000 to access EBS Application

The default passwords are:

SYSADMIN/sysadmin

demo/demo

apps/apps

sys/manager

system/manager

WebLogic/welcome1

All these passwords could be changed but you can keep them as they are until you get used to the Apps.

But if you feel the need to change, connect to the VM through SSH as oracle:

Change directory to:  /u01/install/APPS/scripts

You will find a script to change the password for Sysadmin and for the Demo users.

[oracle@apps scripts]$ ./enableSYSADMIN.sh

[oracle@apps scripts]$ ./enableDEMOusers.sh

 

If you want to access the db 

export ORACLE_BASE=/u01/install/APPS

export ORACLE_HOME=/u01/install/APPS/12.1.0

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=EBSDB

use sys as sysdba and enter the EBSDB schema.