Table: JA_CN_ERROR_ACCOUNTS | Oracle EBS ETRM Search

Table: JA_CN_ERROR_ACCOUNTS 12.2.2

owner JA·JA - Asia/Pacific Localizations·26 columns

JA_CN_ERROR_ACCOUNTS stores error accounts, which have abnormal balances. The XML data template 'Account Balance Export Exception Report' will read this table to export the error accounts if any.

JA.JA_CN_ERROR_ACCOUNTS·Explore JA module →

Table: JA_CN_ERROR_ACCOUNTS 12.1.1

owner JA·JA - Asia/Pacific Localizations·26 columns

JA_CN_ERROR_ACCOUNTS stores error accounts which has abnormal balances. The XML data template will read this table to export the error accounts if any.

JA.JA_CN_ERROR_ACCOUNTS·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_GT 12.1.1

owner JA·JA - Asia/Pacific Localizations·25 columns

JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat file.

JA.JA_CN_ACCOUNT_BALANCES_GT·Explore JA module →

View: JA_CN_ACCOUNT_BALANCES_V 12.2.2

JA - Asia/Pacific Localizations·63 columns

APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore JA module →

View: JA_CN_ACCOUNT_BALANCES_V 12.1.1

FND - Application Object Library·33 columns

APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →

View: JA_CN_ACCOUNT_BALANCES_V 12.2.2

FND - Application Object Library·63 columns

APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →

Table: JA_CN_ACCOUNT_BALANCES 12.1.1 standalone

owner JA·JA - Asia/Pacific Localizations·31 columns

The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.

JA.JA_CN_ACCOUNT_BALANCES·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_POST_GT 12.1.1 standalone

owner JA·JA - Asia/Pacific Localizations·32 columns

The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency.

JA.JA_CN_ACCOUNT_BALANCES_POST_GT·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_GT 12.2.2

owner JA·JA - Asia/Pacific Localizations·55 columns

JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat file.

JA.JA_CN_ACCOUNT_BALANCES_GT·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES 12.2.2 standalone

owner JA·JA - Asia/Pacific Localizations·61 columns

The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.

JA.JA_CN_ACCOUNT_BALANCES·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_POST_GT 12.2.2 standalone

owner JA·JA - Asia/Pacific Localizations·62 columns

The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency.

JA.JA_CN_ACCOUNT_BALANCES_POST_GT·Explore JA module →

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.1.1

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.2.2

VIEW: JA.JA_CN_ERROR_ACCOUNTS# 12.2.2

owner JA

APPS.JA_CN_POST_UTILITY_PKG SQL Statements 12.1.1

APPS.JA_CN_AB_EXP_PKG SQL Statements 12.1.1

APPS.JA_CN_AB_EXP_PKG SQL Statements 12.2.2

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.1.1

VIEW: JA.JA_CN_ACCOUNT_BALANCES# 12.2.2

PACKAGE: APPS.JA_CN_AB_EXP_PKG 12.2.2

used by 1

PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.2.2

used by 1

PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.1.1

used by 1

APPS.JA_CN_APAB_EXPORT_PKG SQL Statements 12.2.2

PACKAGE: APPS.JA_CN_AB_EXP_PKG 12.1.1

used by 1

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.2.2

TABLE: JA.JA_CN_ERROR_ACCOUNTS 12.1.1

owner JA

APPS.JA_CN_POST_UTILITY_PKG SQL Statements 12.2.2

VIEW: JA.JA_CN_ACCOUNT_BALANCES# 12.2.2

owner JA

TABLE: JA.JA_CN_ACCOUNT_BALANCES_GT 12.1.1

owner JA

PACKAGE: APPS.JA_CN_POST_UTILITY_PKG 12.1.1

used by 2

PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.1.1

used by 2

PACKAGE: APPS.JA_CN_POST_UTILITY_PKG 12.2.2

used by 2

TABLE: JA.JA_CN_ERROR_ACCOUNTS 12.2.2

owner JA

TABLE: JA.JA_CN_ACCOUNT_BALANCES 12.1.1

owner JA

PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.2.2

used by 2

TABLE: JA.JA_CN_ACCOUNT_BALANCES_POST_GT 12.1.1

owner JA

PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.2.2

PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.1.1

PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.1.1

TABLE: JA.JA_CN_ACCOUNT_BALANCES_GT 12.2.2

owner JA

TABLE: JA.JA_CN_ACCOUNT_BALANCES 12.2.2

owner JA

TABLE: JA.JA_CN_ACCOUNT_BALANCES_POST_GT 12.2.2

owner JA

PACKAGE BODY: APPS.JA_CN_APAB_EXPORT_PKG 12.2.2

used by 2

PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.2.2

PACKAGE: APPS.JA_CN_APAB_EXPORT_PKG 12.2.2

used by 2

PACKAGE BODY: APPS.JA_CN_APAB_EXPORT_PKG 12.2.2

eTRM - JA Tables and Views 12.1.1

The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.

eTRM - JA Tables and Views 12.2.2

The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.

eTRM - FND Tables and Views 12.2.2

No longer used

Results for “func_period_net_cr”