Gl Calendar Table In Oracle Apps
Gl Calendar Table In Oracle Apps. Here is the query to find out the status of gl and po accounting periods from back end: Name set of books, fnd.
I want to make cte from this table from minimum fromdate and maximum todate. For legacy accounting calendars migrated from instances prior to oracle fusion, calendar_id may have a one to many relationship with period_set_name. Edited mar 7, 2017 at 8:01.
The Gl_Interface Table The Gl_Interface Table Is Where Journal Import Receives Accounting Data That You Import From Other Systems.
Each row includes the set of books name, description, functional currency, and other information. Sql query to find status of gl and po accounting periods. Unique identifier for accounting and commitment calendars created in oracle fusion and has a one to one relationship with period_set_name.
For Legacy Accounting Calendars Migrated From Instances Prior To Oracle Fusion, Calendar_Id May Have A One To Many Relationship With Period_Set_Name.
Your company's calendar year is changing from a fiscal year to a calendar year, and you already have a ledger/set of books that is using the fiscal year calendar. Edited mar 7, 2017 at 8:01. Gl period how to open gl accounting periods open gl period in oracle apps.
This Table Corresponds To The Set Of Books Form.
This table stores gl journals header information. This table stores gl journals lines information,. This table has important columns such as name, je_source, period_name, currency_code, status.
For Legacy Accounting Calendars Migrated From Instances Prior To Oracle Fusion, Calendar_Id May Have A One To Many Relationship With Period_Set_Name.
It is used internally by oracle general ledger applications to post budget balances to the gl_balances table.rows are added to this table whenever you run the budget posting program. This is a simple and easy way to do it. This table stores gl ledger details.
You Then Run Create Accounting.
That row is in u/u (unprocessed / unposted) status. Assets creates the rows in the depreciation tables and also inserts a row in xla_events with an event_date of september 30th. The budget posting program updates the appropriate budget balances in gl_balances based on the rows in this table, and then deletes the rows in this.
Post a Comment for "Gl Calendar Table In Oracle Apps"