Reserved KeyWords in Oracle

Oraclehas several reserved words and these keywords can't be used in different places like naming in identifier or in attribute.

The v$reserved_words view show a list of reserved keywords in oracle.


SQL> DESC V$RESERVED_WORDS;
 Name                                      Null?    Type
 ----------------------------------------- --------
 KEYWORD                                            VARCHAR2(30)
 LENGTH                                                NUMBER
 RESERVED                                           VARCHAR2(1)
 RES_TYPE                                            VARCHAR2(1)
 RES_ATTR                                            VARCHAR2(1)
 RES_SEMI                                            VARCHAR2(1)
 DUPLICATE                                          VARCHAR2(1)

The RESERVED field value Y indicates that the corresponding row is always reserved and hence we can't name in anywhere in oracle as it's name.

If the RESERVED field value is N then it indicates that the keyword is not always reserved and hence can be used based on RES_TYPE, RES_ATTR, RES_SEMI value.

There are four kinds of Reserved objects:

• Oracle Reserved Words
• Oracle Keywords
• PL/SQL Reserved Words
• Oracle Reserved Namespaces

Oracle Reserved Words have a special meaning to Oracle and they cannot be redefined to name database objects such as columns, tables, or indexes.

Oracle Keywords also have a special meaning to Oracle but are not reserved words and so can be redefined. However, some might eventually become reserved words.

PL/SQL Reserved Words are those that may require special treatment when used in embedded SQL statements

Oracle Reserved Namespaces are reserved by Oracle. The function names in Oracle libraries have initial characters which are restricted to the following strings. To avoid potential name conflicts, do not use function names that begin with these characters.

Namespace - Library 
O        -         OCI functions
S        -          function names from SQLLIB and system-dependent libraries
XA     -         external functions for XA applications only
GEN KP L NA NC ND NL NM NR NS NT NZ TTC - UPI Internal functions

PSEUDO COLUMNS in Oracle

PSEUDO COLUMNS are associated with table data , but nothing to do with table data and retrieved from database.
But it looks like retrieved from the table data directly .

Some of the Most commonly used Pseudo columns in Oracle are

• SYSDATE
• SYSTIMESTAMP
• ROWID
• ROWNUM
• USER 
• UID
• LEVEL
• CURRVAL
• NEXTVAL

SYSDATE:- It shows the Current date from the local or remore database . We can use the CURRENT_DATE also with for the same purpose.

Syntax:-

SELECT SYSDATE FROM DUAL

SYSTIMESTAMP:- SYSTIMESTAMP function returns the current system date and time (including fractional seconds and time zone) on your database.

Syntax:-

SELECT SYSTIMESTAMP  FROM DUAL


ROWID:- ROWID is a pseudo column that uniquely identifies a row within a table, but not within a database. It is possible for two rows of two different tables stored in the same cluster to have the same ROWID.

Syntax:-

SELECT ROWID FROM EMP


ROWNUM:- ROWNUM numbers the records in a result set. The first record that meets the where criteria in a select statement is given rownum=1, and every subsequent record meeting that same criteria increases rownum.

Code (Text):

SELECT ROWNUM  FROM EMP WHERE ROWNUM <=10


USER:- USER is a pseudo column that returns the name of the user currently connected to the session.

Code (Text):

SELECT USER FROM DUAL


UID:- Uid is a pseudo column that returns the id number of a user currently connected to the session.

Code (Text):

SELECT UID FROM DUAL


LEVEL:- LEVEL pseudo-column is an indication of how deep in the tree one is. It is used in hierarchical queries along with CONNECT by clause.

Syntax:-

SELECT  level, empno, ename, mgr
FROM     emp
CONNECT BY PRIOR empno = mgr
START WITH mgr IS NULL


NEXTVAL:- NEXTVAL is used to invoke a sequence. If nextval is invoked on a sequence, it makes sure that a unique number is generated.

Syntax:-

SELECT <SEQUENCE>.NEXTVAL FROM DUAL


CURRVAL:- CURRVAL can only be used if a session has already called nextval on a trigger. currval will then return the same number that was generated with nextval.

Syntax:-

SELECT <SEQUENCE>.CURRVAL FROM DUAL


With flashback queries, the following Pseudo Columns are available:

versions_xid
versions_operation
versions_startscn
versions_starttime
versions_endscn
versions_endtime

Internal Requisitions(IR), Internal Sales Order(ISO),Schedule Ship Date, Schedule Arrival Date & Processing Constraint terms in Oracle APPS

Internal Requisitions(IR): An Oracle Requisition is to procure the goods from another warehouse in Oracle.

Internal Sales Order(ISO): An oracle sales order used to fulfil demand for internal requisitions.

Schedule Ship Date: The date by which you can ship the products. This can be entered manually or returned by Oracle.

Schedule Arrival Date: The date which you customer will receive the products.

Processing Constraint: Order management rules that control what changes or who can make changes.

What is PRE-APPROVED status of Purchase Requisition

• Pre–Approved document is one in which a person with the final authority to approve the purchasing document approves it, but then forwards it to someone else for additional approval, thus changing its status to Pre–Approved.

• Your organization uses encumbrance budgeting (reserves funds for documents), and the purchasing document is eligible for approval but funds have not yet been reserved for it. Even if someone with sufficient approval authority approves this document, its status may still remain Pre–Approved if funds were not able to be reserved at the time of approval. Once funds have been reserved for the approved document, the document changes its status to Approved.

• A Pre–Approved document does not show up as supply for planning module until its status changes to Approved. 

General Ledger R12 New Features

1)      Multiple Organizations Access Control

Multiple Organizations Access Control (MOAC) has made significant

enhancements to the Multiple Organizations architecture that was used in Release 11i. If

Your company has implemented a Shared Services operating model, Multi-Org Access

Control allows you to process business transactions more efficiently. You can access,

process, and report on data across multiple operating units from a single responsibility

without compromising data security or system performance.

2)      Oracle Subledger Accounting

3)      Definition Access set

General Ledger definitions and setup definitions, such as Mass Allocations and

Financial Statement Generator (FSG) reports, can be more easily shared and secured

across your organization by allowing you to restrict certain users from viewing or

updating those definitions or using them in processes.

Terminology Changes

Sets of books is replaced by ledgers

This is simply a terminology change. All set of books options are now called ledger

Options

Multiple Reporting Currencies is replaced by Reporting Currencies

Reporting sets of books are replaced by reporting currencies. Reporting sets of

books assigned to primary sets of books automatically upgrade to reporting

currencies that are assigned to a primary ledger. All conversion options for Multiple

Reporting Currencies are retained as part of the reporting currency definition

Global Intercompany System (GIS) is replaced by Advanced Global Intercompany

System (AGIS)

Centralized Accounting Setup

The new Accounting Setup Manager simplifies and centralizes accounting-related setup

for common financial. you can define your legal entities and their accounting context, such as

the ledgers and reporting currencies that perform the accounting for your legal entities.

Sets of Books

• All sets of books upgrade to ledgers in an accounting setup.

The upgrade creates data access sets for upgraded ledgers to facilitate the creation

of advanced data access and data security policies.

• A subledger accounting method, such as Standard Accrual, is automatically

assigned to all upgraded ledgers.

A subledger accounting method allows General Ledger to integrate with sub ledgers

via Subledger Accounting.

• The secondary tracking option for revaluation and closing and translation has been

streamlined.

Global Accounting Engine functionality is obsolete

Single posting sets of books with multiple main sets of books upgrade to multiple

primary ledgers that share the same secondary ledger.

Period Rates Replaced by Daily Rates

Period rates are replaced with daily rates.

GROUP_ID in GL (Oracle APPS)

The GROUP_ID distinguishes import data within a particular source, i.e. Oracle Receivables, Payables and other Sub Ledgers. This allows you to choose a Selection Criteria:

1. No Group ID: Will select lines with the group id not populated (null)
2. All Group IDs: Will select all lines from the specified source with the group id populated (not null)
3. Specific Group ID: Will select lines with that specific group id

Query to get Prepayment Invoice Status in Oracle Payables

SELECT   aps.vendor_name,
           ai.invoice_num,
           NVL (
              DECODE (
                 SIGN (SUM (amount - NVL (prepay_amount_remaining, amount))),
                 1,
                 DECODE (SUM (prepay_amount_remaining), 0, 'Y', NULL),
                 NULL
              ),
              'N'
           )
              AS prepayment_invoice_status     -- Y is Fully Applied, N is Partially or Not Applied
    FROM ap_invoice_distributions_all aid
        ,ap_invoices_all ai
        ,ap_suppliers aps
   WHERE aid.invoice_id = ai.invoice_id
     AND aps.vendor_id = ai.vendor_id
     AND aid.line_type_lookup_code = 'ITEM'
     AND ai.invoice_type_lookup_code = 'PREPAYMENT'
     --AND ai.invoice_id = :p_invoice_id
     AND NVL (reversal_flag, 'N') <> 'Y'
GROUP BY   aps.vendor_name, ai.invoice_num

Receipt API in Oracle Receivables

Autolock box provides a functionality to create Receipts using Interface method. Below are the list of API's:-

ar_receipt_api_pub.Create_cash
ar_receipt_api_pub.Apply
ar_receipt_api_pub.Unapply
ar_receipt_api_pub.Reverse
ar_receipt_api_pub.Apply_on_account
ar_receipt_api_pub.Unapply_on_account
ar_receipt_api_pub.Activity_application
ar_receipt_api_pub.Activity_unapplication
ar_receipt_api_pub.Apply_other_account
ar_receipt_api_pub.Unapply_other_account
ar_receipt_api_pub.create_misc
ar_receipt_api_pub.set_profile_for_testing
ar_receipt_api_pub.Apply_Open_Receipt
ar_receipt_api_pub.Unapply_Open_Receipt

R12: "No ZX_PARTY_TAX_PROFILE was found for XX ID, THIRD_PARTY" error message displayed updating a Customer Name" in Oracle APPS

Some times we may get error while updating Customer Name in R12 as shown in below images.

There might be multiple reasons for this error, one of the reason is data does not exists in ZX_PARTY_TAX_PROFILE table. There must be one record for each customer in this table(Party_id from hz_parties). You can find more information about this issue in oracle documents 1156573.1, 601633.1.

After inserting data into ZX_PARTY_TAX_PROFILE table oaf page allowing to update Customer Name without any error.

Sample script:-

INSERT INTO zx_party_tax_profile (
  party_type_code
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,party_tax_profile_id
,party_id
,object_version_number
)
 VALUES('THIRD_PARTY'
   ,p_user_id--fnd_global.user_id--Pass User ID
   ,SYSDATE
   ,p_user_id--fnd_global.user_id--Pass User ID
   ,SYSDATE
   ,1
   ,zx_party_tax_profile_s.NEXTVAL
   ,i.party_id --Pass Party_id from hz_parties table for given customer name
   ,1
);

Note: This post is just for information only, if you face same issue check with oracle, do proper testing in test instance before migrating to production instance.

FA Tables in Oracle APPS

fa_methods
fa_ace_books
fa_additions_b
fa_additions_tl
fa_addition_rep_itf
fa_add_warranties
fa_adjustments
fa_adjust_rep_itf
fa_amort_schedules
fa_archive_history
fa_asset_hierarchy
fa_asset_hierarchy_purpose
fa_mass_reval_rep_itf
fa_reserve_ledger_gt
fa_balances_report_gt
fa_asset_hierarchy_values
fa_asset_history
fa_asset_invoices
fa_asset_keywords
fa_asset_listing_rep_itf
fa_as_efc_07_jan_2002_03
fa_as_efc_20_feb_2003_12
fa_balances_report
fa_balances_rep_itf
fa_bonus_rates
fa_bonus_rules
fa_books
fa_books_groups
fa_books_summary
fa_book_controls
fa_book_controls_history
fa_budget_distribution
fa_budget_interface
fa_calendar_periods
fa_calendar_types
fa_ceilings
fa_ceiling_types
fa_cl_efc_07_jan_2002_03
fa_cl_efc_20_feb_2003_12
fa_conventions
fa_convention_types
fa_costclear_rep_itf
fa_ct_efc_07_jan_2002_03
fa_ct_efc_20_feb_2003_12
fa_capital_budget
fa_cap_bud_efc_07_jan_2002_03
fa_cap_bud_efc_20_feb_2003_12
fa_cap_rep_itf
fa_categories_b
fa_categories_tl
fa_category_books
fa_category_book_defaults
fa_cbd_efc_07_jan_2002_03
fa_cbd_efc_20_feb_2003_12
fa_deferred_deprn
fa_deleted_mass_additions
fa_deprn_basis_rules
fa_distribution_defaults
fa_distribution_history
fa_distribution_sets
fa_exclude_hierarchy_levels
fa_ext_inv_retirements
fa_fiscal_year
fa_flat_rates
fa_formulas
fa_gar_efc_07_jan_2002_03
fa_gar_efc_20_feb_2003_12
fa_group_assets
fa_group_asset_default
fa_group_asset_rules
fa_group_deprn_detail
fa_group_deprn_rates
fa_group_deprn_summary
fa_group_rep_itf
fa_hierarchy_controls
fa_hierarchy_distributions
fa_hierarchy_rule_details
fa_hierarchy_rule_set
fa_hrd_efc_07_jan_2002_03
fa_hrd_efc_20_feb_2003_12
fa_hrh_efc_07_jan_2002_03
fa_hrh_efc_20_feb_2003_12
fa_hr_retirement_details
fa_hr_retirement_headers
fa_ins_lines
fa_ins_mst_pols
fa_ins_policies
fa_ins_values
fa_inventory
fa_invmiss_rep_itf
fa_invoice_transactions
fa_inv_compare_rep_itf
fa_inv_interface
fa_ip_efc_07_jan_2002_03
fa_ip_efc_20_feb_2003_12
fa_itc_rates
fa_itc_recapture_rates
fa_iv_efc_07_jan_2002_03
fa_iv_efc_20_feb_2003_12
fa_journal_entries
fa_leases
fa_lease_payments
fa_lease_payment_items
fa_lease_schedules
fa_life_derivation_info
fa_locations
fa_lookups_b
fa_lookups_tl
fa_lookup_types_b
fa_lookup_types_tl
fa_lsp_efc_07_jan_2002_03
fa_lsp_efc_20_feb_2003_12
fa_lss_efc_07_jan_2002_03
fa_lss_efc_20_feb_2003_12
fa_ls_efc_07_jan_2002_03
fa_ls_efc_20_feb_2003_12
fa_maint_events
fa_maint_rep_itf
fa_maint_schedule_dtl
fa_maint_schedule_hdr
fa_massadd_distributions
fa_massadd_rep_itf
fa_mass_additions
fa_mass_changes
fa_mass_changes_itf
fa_mass_external_transfers
fa_mass_ext_retirements
fa_mass_ext_ret_excepts
fa_mass_reclass
fa_mass_reclass_itf
fa_mass_retirements
fa_mass_ret_excepts
fa_mass_revaluations
fa_mass_revaluation_rules
fa_mass_tax_adjustments
fa_mass_transfers
fa_mass_update_batch_details
fa_mass_update_batch_headers
fa_mc_adjustments
fa_mc_asset_invoices
fa_mc_books
fa_mc_books_groups
fa_mc_books_rates
fa_mc_books_summary
fa_mc_book_controls
fa_mc_br_efc_07_jan_2002_03
fa_mc_br_efc_20_feb_2003_12
fa_mc_ch_efc_07_jan_2002_03
fa_mc_ch_efc_20_feb_2003_12
fa_mc_conversion_history
fa_mc_conversion_rates
fa_mc_deferred_deprn
fa_mc_deprn_detail
fa_mc_deprn_periods
fa_mc_deprn_summary
fa_mc_group_deprn_detail
fa_mc_group_deprn_summary
fa_mc_mass_rates
fa_mc_retirements
fa_me_efc_07_jan_2002_03
fa_me_efc_20_feb_2003_12
fa_mrc_inq_financials
fa_msd_efc_07_jan_2002_03
fa_msd_efc_20_feb_2003_12
fa_msh_efc_07_jan_2002_03
fa_msh_efc_20_feb_2003_12
fa_parallel_workers
fa_periodic_production
fa_period_maps
fa_plsql_debug
fa_price_indexes
fa_price_index_values
fa_production_interface
fa_project_rep_itf
fa_proptax_rep_itf
fa_rates
fa_reclass_rep_itf
fa_reserve_ledger
fa_retirements
fa_retire_rep_itf
fa_rx_attrsets_b
fa_rx_attrsets_tl
fa_rx_dynamic_columns
fa_rx_lov
fa_rx_multiformat_reps
fa_rx_reports
fa_rx_rep_columns_b
fa_rx_rep_columns_tl
fa_rx_rep_parameters
fa_rx_security
fa_rx_summary_tl
fa_short_tax_reserves
fa_super_groups
fa_super_group_rules
fa_system_controls
fa_tax_interface
fa_tax_report
fa_track_members
fa_transaction_headers
fa_transfer_details
fa_transfer_rep_itf
fa_trx_references
fa_warranties
fa_war_efc_07_jan_2002_03
fa_war_efc_20_feb_2003_12
fa_whatif_itf
je_de_fa_summary
je_hu_balances_report
jg_zz_fa_ins_lines_r110
jg_zz_fa_ins_mst_pols_r110
jg_zz_fa_ins_policies_r110
jg_zz_fa_ins_values_r110

GL Tables in Oracle APPS

gl_daily_post_int2
gl_budget_interim
gl_translation_interim
gl_xlate_posting_interim
gl_sets_of_books
gl_periods
gl_code_combinations
gl_daily_conversion_types
gl_encumbrance_types
gl_budget_versions
jg_zz_ta_rule_sets
jg_zz_ta_rule_lines
jg_zz_ta_cc_ranges
jg_zz_ta_account_ranges
gl_je_lines
gl_je_categories_tl
gl_period_types
gl_period_statuses
gl_transaction_calendar
gl_period_sets
gl_recurring_batches
gl_budget_period_ranges
gl_summary_templates
gl_je_sources_tl
gl_je_headers
gl_balances
gl_budget_entities
gl_account_hierarchies
gl_elimination_sets
gl_iea_subsidiaries
gl_daily_rates
gl_stat_account_uom
gl_budgets
gl_cons_segment_map
gl_date_period_map
gl_import_references
jg_zz_ta_allocated_lines
gl_mc_reporting_options
gl_je_batches
gl_translation_rates
gl_translation_tracking
gl_ussgl_transaction_codes
gl_cons_flex_hierarchies
gl_consolidation
gl_weighted_avg_details
gl_interface

gl_balances_delta_interim
gl_cross_rate_temp
gl_cross_rate_rules
gl_cross_rate_rule_dtls
gl_iea_transactions
gl_iea_transaction_types
gl_iea_recur_transactions
gl_iea_clearing_accounts
gl_consolidation_audit
gl_cons_flexfield_map
gl_cons_set_assignments
gl_consolidation_sets
gl_alloc_formulas
gl_automatic_posting_options
gl_alloc_batches
gl_iea_segment_map
gl_auto_alloc_bat_hist_det
gl_auto_alloc_sets
gl_mc_book_assignments
gl_revaluations
gl_reval_account_ranges
gl_suspense_accounts
je_be_vat_rep_rules
gl_autoreverse_options
gl_intercompany_acc_sets
gl_oasis_summary_data
gl_bc_packets
gl_bc_option_details
gl_iea_autogen_map
gl_auto_alloc_set_history
gl_entity_budgets
gl_row_multipliers
gl_recurring_headers
gl_historical_rates
gl_auto_alloc_batch_history
gl_authorization_limits
gl_budget_batches
ap_mc_invoices_tmp
gl_alloc_int_1_2618275
gl_alloc_int_1_2618555
gl_alloc_int_1_2618750
gl_alloc_int_1_2618752
gl_alloc_int_1_2618780
gl_alloc_int_1_2618783
gl_alloc_int_1_2618798
gl_alloc_int_1_2618809
gl_alloc_int_1_2618846
gl_alloc_int_1_2618906
gl_alloc_int_1_2618940
gl_alloc_int_1_2618941
gl_alloc_int_1_2622147
gl_alloc_int_1_2626340
gl_alloc_int_1_2626368
gl_alloc_int_1_2627515
gl_alloc_int_1_2627516
gl_alloc_int_1_2627517
gl_alloc_int_1_2627518
gl_alloc_int_1_2627531
gl_alloc_int_1_2627533
gl_alloc_int_1_2632882
gl_alloc_int_1_2633706
gl_alloc_int_2_2618275
gl_alloc_int_2_2618750
gl_alloc_int_2_2618752
gl_alloc_int_2_2618780
gl_alloc_int_2_2618783
gl_alloc_int_2_2618798
gl_alloc_int_2_2618809
gl_alloc_int_2_2618846
gl_alloc_int_2_2618906
gl_alloc_int_2_2618940
gl_alloc_int_2_2618941
gl_alloc_int_2_2622147
gl_alloc_int_2_2626340
gl_alloc_int_2_2626368
gl_alloc_int_2_2627515
gl_alloc_int_2_2627516
gl_alloc_int_2_2627517
gl_alloc_int_2_2627518
gl_alloc_int_2_2627531
gl_alloc_int_2_2627533
gl_alloc_int_2_2632882
gl_alloc_int_2_2633706
gl_alloc_int_3_2618275
gl_alloc_int_3_2618750
gl_alloc_int_3_2618752
gl_alloc_int_3_2618780
gl_alloc_int_3_2618783
gl_alloc_int_3_2618798
gl_alloc_int_3_2618809
gl_alloc_int_3_2618846
gl_alloc_int_3_2618906
gl_alloc_int_3_2618940
gl_alloc_int_3_2618941
gl_alloc_int_3_2622147
gl_alloc_int_3_2626340
gl_alloc_int_3_2626368
gl_alloc_int_3_2627515
gl_alloc_int_3_2627516
gl_alloc_int_3_2627517
gl_alloc_int_3_2627518
gl_alloc_int_3_2627531
gl_alloc_int_3_2627533
gl_alloc_int_3_2632882
gl_alloc_int_3_2633706
gl_alloc_segvals_int
gl_alloc_target_2618275
gl_alloc_target_2618750
gl_alloc_target_2618752
gl_alloc_target_2618780
gl_alloc_target_2618783
gl_alloc_target_2618798
gl_alloc_target_2618809
gl_alloc_target_2618846
gl_alloc_target_2618906
gl_alloc_target_2618940
gl_alloc_target_2618941
gl_alloc_target_2622147
gl_alloc_target_2626340
gl_alloc_target_2626368
gl_alloc_target_2627515
gl_alloc_target_2627516
gl_alloc_target_2627517
gl_alloc_target_2627518
gl_alloc_target_2627531
gl_alloc_target_2627533
gl_alloc_target_2632882
gl_alloc_target_2633706
gl_ahe_detail_ranges_gt
gl_alloc_formula_lines
gl_alloc_history
gl_application_groups
gl_archive_balances
gl_archive_batches
gl_archive_daily_balances
gl_archive_headers
gl_archive_history
gl_archive_lines
gl_archive_references
gl_automatic_posting_sets
gl_auto_alloc_batches
gl_auto_alloc_rev_batches
gl_balances_delta
gl_budget_assignments
gl_budget_assignment_ranges
gl_budget_frozen_ranges
gl_budget_interface
gl_budget_range_interim
gl_budget_types
gl_carryforward_ranges
gl_bc_dual
gl_bc_dual2
gl_bc_event_timestamps
gl_bc_options
gl_bc_packet_arrival_order
gl_bc_period_map
gl_bis_segval_int
gl_cons_interface_24407
gl_daily_balances
gl_daily_conversion_rates_r10
gl_daily_open_int
gl_daily_rates_interface
gl_doc_sequence_audit
gl_dynamic_summ_combinations
gl_efc_budget_mapping
gl_efc_changed_trx
gl_efc_data_utility
gl_efc_disabled_triggers
gl_efc_run_history
gl_elimination_history
gl_concurrency_control
gl_concurrent_schedules
gl_consolidation_accounts
gl_consolidation_history
gl_cons_batches
gl_cons_interface_24401
gl_cons_interface_24406
gl_elimination_journals
gl_elim_accounts_map
gl_elim_bal_options
gl_extract_history
gl_historical_rate_ranges
gl_iea_import_registry
gl_iea_interface
gl_iea_recur_batches
gl_iea_recur_history
gl_iea_recur_lines
gl_iea_segment_rule_map
gl_iea_transaction_lines
gl_interface_control
gl_intercompany_accounts
gl_interco_accounts_r110
gl_interco_bsv_int_24656
gl_interco_bsv_int_24659
gl_interco_bsv_int_24884
gl_interco_bsv_int_24936
gl_interco_bsv_int_25002
gl_interco_bsv_int_25184
gl_interco_bsv_int_25355
gl_interco_bsv_int_25356
gl_interco_bsv_int_26078
gl_interco_bsv_int_26081
gl_interco_bsv_int_26127
gl_interco_bsv_int_26184
gl_interco_bsv_int_26212
gl_interco_bsv_int_26214
gl_interco_bsv_int_26420
gl_interco_bsv_int_26481
gl_interco_bsv_int_26547
gl_interco_bsv_int_26666
gl_interco_bsv_int_26681
gl_interco_bsv_int_26774
gl_interco_bsv_int_26978
gl_interco_bsv_int_27022
gl_interco_bsv_int_27060
gl_interco_bsv_int_27180
gl_interco_bsv_int_27263
gl_interco_bsv_int_27422
gl_interco_bsv_int_27486
gl_interco_bsv_int_27564
gl_interco_bsv_int_27663
gl_interco_bsv_int_27729
gl_interco_bsv_int_27912
gl_interco_bsv_int_27994
gl_interco_bsv_int_28030
gl_interco_bsv_int_28102
gl_interco_bsv_int_28178
gl_interco_bsv_int_28346
gl_interco_bsv_int_28424
gl_interco_bsv_int_28692
gl_interco_bsv_int_28756
gl_interco_bsv_int_29006
gl_interco_bsv_int_29092
gl_interco_bsv_int_29229
gl_interco_bsv_int_29265
gl_interco_bsv_int_29307
gl_interco_bsv_int_29372
gl_interco_bsv_int_29650
gl_interco_bsv_int_29740
gl_interco_bsv_int_29882
gl_interco_bsv_int_30002
gl_interco_bsv_int_30062
gl_interco_bsv_int_30518
gl_interco_bsv_int_30539
gl_interco_bsv_int_30671
gl_interco_bsv_int_30724
gl_interco_bsv_int_30728
gl_interco_bsv_int_30732
gl_interco_bsv_int_30734
gl_interco_bsv_int_30738
gl_interco_bsv_int_30798
gl_interco_bsv_int_30952
gl_interco_bsv_int_31022
gl_interco_bsv_int_31073
gl_interco_bsv_int_31074
gl_interco_lines_int_30724
gl_interco_lines_int_30728
gl_interco_lines_int_30732
gl_interco_lines_int_30734
gl_interco_lines_int_30738
gl_interco_lines_int_30798
gl_interco_lines_int_30952
gl_interco_lines_int_31022
gl_interco_lines_int_31073
gl_interco_lines_int_31074
gl_interface_history
gl_je_inclusion_rules
gl_journal_reports_itf
gl_lookups_old
gl_mc_conversion_rules
gl_mc_conv_int_30717
gl_mc_conv_int_30719
gl_mc_conv_int_30721
gl_mc_conv_int_30724
gl_mc_conv_int_30730
gl_mc_conv_int_30732
gl_mc_conv_int_30734
gl_mc_conv_int_30736
gl_mc_conv_int_30738
gl_mc_conv_int_30794
gl_mc_conv_int_30852
gl_mc_conv_int_30932
gl_mc_conv_int_31018
gl_mc_conv_int_31058
gl_mc_conv_int_31060
gl_mc_conv_int_31061
gl_mc_conv_int_31069
gl_mc_conv_int_31070
gl_mc_conv_int_31085
gl_mc_conv_int_31122
gl_mc_options_int_30717
gl_mc_options_int_30719
gl_mc_options_int_30721
gl_mc_options_int_30724
gl_mc_options_int_30730
gl_mc_options_int_30732
gl_mc_options_int_30734
gl_mc_options_int_30736
gl_mc_options_int_30738
gl_mc_options_int_30794
gl_mc_options_int_30852
gl_mc_options_int_30932
gl_mc_options_int_31018
gl_mc_options_int_31058
gl_mc_options_int_31060
gl_mc_options_int_31061
gl_mc_options_int_31069
gl_mc_options_int_31070
gl_mc_options_int_31085
gl_mc_options_int_31122
gl_mc_upgrade_history
gl_mc_upgrade_rates
gl_movemerge_accounts
gl_movemerge_bal_103
gl_movemerge_bal_104
gl_movemerge_bal_123
gl_movemerge_bal_143
gl_movemerge_bal_164
gl_movemerge_bal_184
gl_movemerge_bal_63
gl_movemerge_bal_83
gl_movemerge_bal_84
gl_movemerge_interim_103
gl_movemerge_interim_104
gl_movemerge_interim_123
gl_movemerge_interim_143
gl_movemerge_interim_164
gl_movemerge_interim_184
gl_movemerge_interim_63
gl_movemerge_interim_83
gl_movemerge_interim_84
gl_movemerge_requests
gl_net_income_accounts
gl_oasis_collection_int
gl_oasis_fin_assignments
gl_oasis_fin_items
gl_oasis_fin_metrics
gl_open_interim
gl_posting_interim
gl_posting_interim_24331
gl_posting_interim_24656
gl_posting_interim_30716
gl_recurring_lines
gl_recurring_line_calc_rules
gl_revaluation
gl_revaluation_accounts
gl_reval_chd_ranges_gt
gl_reval_exp_ranges_gt
gl_rollup_group_scores
gl_rx_trial_balance_itf
gl_segment_frequencies
gl_segval_inherit_history
gl_shares_activity
gl_shares_outstanding
gl_storage_parameters
gl_summary_hierarchies
gl_summary_hierarchy_int
gl_system_setup
gl_system_usages
gl_tax_options
gl_tax_option_accounts
gl_temporary_combinations
gl_transaction_dates
gl_transaction_rate_exceptions
gl_translation_statuses
gl_ussgl_account_pairs
gl_year_end_acct_int_1
gl_year_end_acct_int_8
gl_year_end_bal_int_1
gl_year_end_bal_int_8
je_be_annual_vat
je_be_esl_summaries
je_be_line_type_map
je_be_logs
je_be_reporters
je_be_vat_allocations
je_be_vat_alloc_errors
je_doc_sequence_audit
je_gr_cutoff_rules
je_gr_je_header_sequence
je_it_report_parameters
je_it_tmp_rpt_headers

Inventory Tables in Oracle APPS

mtl_system_items_tl
mtl_onhand_quantities_detail
mtl_transaction_accounts
mtl_material_transactions_temp
mtl_material_transactions
mtl_consigned_diag_errors
mtl_transaction_flow_headers
mtl_transaction_flow_lines
mtl_pac_act_cst_dtl_temp
mtl_eres_transactions_gtmp
mtl_onhand_quantities_d_bkp
mtl_onhand_discrepancies
inv_mvt_excep_rep_temp
mtl_onhand_lock_temp
mtl_rma_serial_temp
mtl_vmi_quantities_temp
inv_eres_events_temp
inv_msn_gtemp
mtl_allocations_gtmp
mtl_consigned_diag_temp
mtl_system_items_b
mtl_uom_conversions
mtl_reservations
mtl_interorg_ship_methods
mtl_transaction_types
mtl_item_locations
mtl_item_categories
mtl_eam_asset_activities
mtl_serial_numbers
mtl_units_of_measure_tl
mtl_related_items_pln_info
mtl_physical_adjustments
mtl_related_items_cust_ref
org_freight_tl
mtl_item_templates
mtl_interorg_parameters
mtl_uom_conversions_a
mtl_parameters
mtl_eam_asset_attr_values
mtl_cross_references
mtl_cst_actual_cost_details
mtl_cst_txn_cost_details
mtl_demand_interface
mtl_categories_b
mtl_txn_source_types
mtl_mfg_part_numbers
mtl_item_attributes
mtl_descr_element_values
mtl_secondary_inventories
mtl_material_statuses_b
mtl_mvt_stats_rule_sets_tl
mtl_status_transaction_control
mtl_item_status
mtl_txn_request_lines
mtl_transaction_lots_temp
mtl_transaction_reasons
mtl_mgd_inventory_positions
mtl_demand
mtl_txn_request_headers
mtl_movement_statistics
mtl_descriptive_elements
mtl_related_items
mtl_rtg_item_revisions
mtl_item_revisions_b
mtl_cross_reference_types
mtl_status_attribute_values
mtl_manufacturers
mtl_movement_parameters
mtl_uom_class_conversions
mtl_forecast_rules
mtl_lot_numbers
org_acct_periods
mtl_planners
mtl_abc_assgn_group_classes
mtl_abc_assignments
mtl_abc_assignment_groups
mtl_abc_classes
mtl_customer_item_xrefs
mtl_cycle_count_headers
mtl_cycle_count_entries
mtl_cycle_count_classes
mtl_cycle_count_items
mtl_pending_item_status
mtl_generic_dispositions
mtl_atp_rules
org_gl_batches
mtl_replenish_lines
mtl_kanban_cards
mtl_kanban_card_activity
mtl_kanban_pull_sequences
mtl_transaction_lot_numbers
mtl_physical_inventories
mtl_physical_inventory_tags
mtl_unit_transactions
mtl_replenish_headers
mtl_supply
mtl_category_sets_b
mtl_item_sub_inventories
mtl_transactions_interface
mtl_sales_orders
mtl_default_category_sets
org_access
mtl_commodity_codes
mtl_material_txn_allocations
mtl_category_sets_tl
mtl_uom_classes_tl
mtl_customer_items
mtl_serial_numbers_temp
mtl_so_rma_interface
mtl_abc_compile_headers
mtl_cc_subinventories
mtl_sys_items_sn
mtl_attr_appl_dependencies
mtl_item_catalog_groups_b
mtl_bis_inv_by_period
mtl_economic_zones_b
mtl_safety_stocks
mtl_supply_demand_temp
mtl_oh_qtys_sn
mtl_supply_sn
mtl_cc_entries_interface
mtl_cc_schedule_requests
mtl_eam_network_assets
mtl_intercompany_parameters
mtl_reservations_interface
mtl_short_chk_param
mtl_categories_tl
mtl_item_catalog_groups_tl
mtl_secondary_locators
mtl_category_set_valid_cats
mtl_country_assignments
mtl_category_accounts
mtl_eam_asset_attr_groups
mtl_demand_sn
mtl_material_statuses_tl
mtl_picking_rules
mtl_demand_histories
mtl_txn_cost_det_interface
mtl_stat_type_usages
mtl_cc_serial_numbers
wms_cartonization_temp
cost_upgr_error_table
inv_item_temp
inv_min_max_temp
je_it_inv_packslips
je_it_stk_valuation
mlog$_mtl_default_category
mlog$_mtl_demand
mlog$_mtl_material_transac
mlog$_mtl_reservations
mlog$_mtl_supply
mlog$_mtl_txn_request_head
mlog$_mtl_user_demand
mlog$_mtl_user_supply
mtl_abc_compiles
mtl_abc_compiles_efc
mtl_abc_compile_headers_efc
mtl_actual_cost_subelement
mtl_actual_cost_subelement_efc
mtl_catalog_search_items
mtl_cc_interface_errors
mtl_cc_sched_count_xrefs
mtl_ci_interface
mtl_ci_xrefs_interface
mtl_consigned_qty_temp
mtl_consumption_definition
mtl_consumption_transactions
mtl_consumption_txn_temp
mtl_copy_org_interface
mtl_copy_org_report
mtl_copy_org_report_temp
mtl_copy_org_temp
mtl_cross_references_interface
mtl_cst_actual_cost_detail_efc
mtl_cst_layer_act_cost_details
mtl_cst_txn_cost_details_efc
mtl_cycle_count_classes_efc
mtl_cycle_count_entries_efc
mtl_cycle_count_headers_efc
mtl_desc_elem_val_interface
mtl_do_check_temp
mtl_eam_asset_num_interface
mtl_eam_asset_search_temp
mtl_eam_attr_val_interface
mtl_eam_locations
mtl_economic_zones_tl
mtl_ext_objects
mtl_fiscal_cat_accounts
mtl_flex_context
mtl_icg_aliases
mtl_icg_categories
mtl_interface_errors
mtl_interface_proc_controls
mtl_onhand_quantity_temp
mtl_org_report_temp
mtl_pac_actual_cost_details
mtl_pac_actual_cost_detail_efc
mtl_pac_cost_subelements
mtl_pac_cost_subelements_efc
mtl_pac_txn_cost_details
mtl_pac_txn_cost_details_efc
mtl_period_cg_summary
mtl_period_summary
mtl_serial_numbers_clup
mtl_item_attributes_temp
mtl_item_categories_interface
mtl_item_child_info_interface
mtl_item_loc_defaults
mtl_item_revisions_interface
mtl_item_revisions_tl
mtl_item_sub_defaults
mtl_item_sub_invs_interface
mtl_item_templ_attributes
mtl_item_values_temp
mtl_kanban_card_print_temp
mtl_kanban_templates
mtl_le_economic_zones
mtl_lot_numbers_clup
mtl_material_status_history
mtl_material_transactions_efc
mtl_mobile_login_hist
mtl_movement_statistics_efc
mtl_mtrx_tmp_sn
mtl_mvt_stats_rule
mtl_mvt_stats_rules
mtl_mvt_stats_rule_sets_b
mtl_object_events
mtl_object_genealogy
mtl_object_genealogy_interface
mtl_onhand_quantities_backup
mtl_serial_numbers_interface
mtl_serial_num_intc_clup
mtl_serial_num_temp_clup
mtl_short_chk_statements
mtl_short_chk_temp
mtl_so_rma_receipts
mtl_summary_temp
mtl_system_items_b_efc
mtl_system_items_interface
mtl_transaction_accounts_efc
mtl_transaction_lots_infc_clup
mtl_transaction_lots_interface
mtl_transaction_lots_temp_clup
mtl_transaction_lot_num_clup
mtl_transfer_temp
mtl_unit_txns_clup
mtl_update_records_temp
mtl_user_demand
mtl_user_supply
mtl_u_demand_sn
mtl_u_supply_sn
rsv_temp
mtl_period_summary_efc
mtl_per_close_dtls
mtl_per_close_dtls_efc
mtl_physical_adjustments_efc
mtl_physical_inventories_efc
mtl_physical_subinventories
mtl_purge_header
mtl_qoh_item_tmp
mtl_qoh_locator_tmp
mtl_qoh_lot_tmp
mtl_qoh_rev_tmp
mtl_qoh_sub_tmp
mtl_related_items_interface
mtl_replenish_headers_int
mtl_replenish_lines_int
mtl_reservations_sn
mtl_rsv_quantities_temp
mtl_rtg_item_revs_interface
mtl_seasonality_indices
mtl_secondary_locs_interface

WIP KEY Tables in Oracle APPS

WIP_LINES:-         

WIP_LINES stores production line information. Each row includes a line name, maximum and minimum rate information, throughput for rate based lines (lead time), and the start and stop time information that determines the amount of time per day that the line is available. Oracle Work in Process uses this information when you associate a line with a repetitive assembly and when you define a repetitive schedule on the line. Production line information is optional for discrete jobs.              

WIP_OPERATIONS:         

WIP_OPERATIONS stores information about job and repetitive schedule operations. Each row represents a specific operation and includes an operation sequence number, which orders the operations for the job or repetitive schedule. Each row also includes the assembly quantity completed at an operation, the quantity at each intraoperation step, the department associated with an operation, the scheduled start and completion dates for an operation, the operation’s count point and

backflush types and other operation attributes. In general, Oracle Work in Process uses this information to control and monitor assembly production on the shop floor.

WIP_ENTITIES:-  

WIP_ENTITIES stores information about jobs, repetitive assemblies, and flow schedules. Each row includes a unique entity name, the entity type,

and the assembly being built. Oracle Work in Process uses this information to control production activities and to ensure that entities with duplicate names are not created.         

WIP_DISCRETE_JOBS:-    

WIP_DISCRETE_JOBS stores discrete job information. Each row represents a discrete job, and contains information about the assembly being built, the revision of the assembly, the job quantity, the status of the job, the material control method, accounting information, and job schedule dates. Oracle Work in Process uses this information to control discrete production.       

WIP_TRANSACTIONS:-    

WIP_TRANSACTIONS stores information about WIP resource transactions. Each row represents a single resource transaction and includes a unique transaction Identifier, a transaction date, the job or repetitive schedule charged, the WIP operation and resource charges, and the number of units of measure applied. Oracle Work in Process uses this information to track resource charges and to calculate the values stored in WIP_TRANSACTION_ACCOUNTS.

Data Flow from AR to XLA to GL in Oracle APPS

GL tables are linked to Subledger Accounting (XLA tables).

Regarding gl_import_references, there is a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES.

GL_SL_LINK_ID and GL_SL_LINK_TABLE forms the link between these 2 tables.

Drilldown from GL to AR retrieves information from following tables mainly:

XLA_EVENTS
XLA_AE_HEADERS

The main Receivables Headers tables:

RA_CUSTOMER_TRX_ALL (Transactions)
AR_CASH_RECEIPTS_ALL (Receipts)
AR_ADJUSTMENTS_ALL

The linking between GL and AR is done between following tables mainly:

XLA_TRANSACTION_ENTITIES
XLA_SUBLEDGERS
GL_JE_SOURCES
GL_JE_CATEGORIES
GL_IMPORT_REFERENCES
GL_JE_HEADERS


11i GL_IMPORT_REFERENCES.reference_10
RA_CUST_TRX_LINE_GL_DIST, AR_RECEIVABLE_APPLICATIONS, AR_MISC_CASH_DISTRIBUTIONS

in R12:-
SELECT DISTINCT xdl.source_distribution_type 
                  FROM gl_import_references gir
                      ,xla_ae_lines xal
                      ,xla_ae_headers xah
                      ,xla_events xe
                      ,xla_distribution_links xdl
                 WHERE gir.je_header_id = :p_je_header_id
                   AND gir.je_line_num = :p_je_line_num
                   AND gir.gl_sl_link_id = xal.gl_sl_link_id
                   AND gir.gl_sl_link_table = xal.gl_sl_link_table 
                   AND xal.ae_header_id = xah.ae_header_id
                   AND xah.event_id = xe.event_id
                   AND xah.application_id = xe.application_id
                   AND xah.entity_id = xe.entity_id
                   AND xe.event_id = xdl.event_id 
                   AND xdl.ae_line_num = xal.ae_line_num
                   AND xah.ae_header_id = xdl.ae_header_id
                   AND xal.ae_header_id = xdl.ref_ae_header_id

RA_CUST_TRX_LINE_GL_DIST_ALL, AR_DISTRIBUTIONS_ALL and AR_MISC_CASH_DISTRIBUTIONS_ALL


Below is the Query for AR Invoice (RA_CUST_TRX_LINE_GL_DIST_ALL)
SELECT b.*
                              FROM gl_import_references gir
                                  ,xla_ae_lines xal
                                  ,xla_ae_headers xah
                                  ,xla_events xe
                                  ,xla_distribution_links xdl
                                  ,ra_cust_trx_line_gl_dist_all b
                             WHERE gir.je_header_id = :p_je_header_id
                               AND je_line_num = :p_je_line_num
                               AND gir.gl_sl_link_id = xal.gl_sl_link_id
                               AND gir.gl_sl_link_table = xal.gl_sl_link_table 
                               AND xal.ae_header_id = xah.ae_header_id
                               AND xah.event_id = xe.event_id
                               AND xah.application_id = xe.application_id
                               AND xah.entity_id = xe.entity_id
                               AND xe.event_id = xdl.event_id 
                               AND xdl.ae_line_num = xal.ae_line_num
                               AND xah.ae_header_id = xdl.ae_header_id
                               AND xal.ae_header_id = xdl.ref_ae_header_id

                               AND xdl.source_distribution_id_num_1 = b.cust_trx_line_gl_dist_id 

Below is the Query in case of AR_DISTRIBUTIONS_ALL
SELECT ada.*
                              FROM gl_import_references gir
                                  ,xla_ae_lines xal
                                  ,xla_ae_headers xah
                                  ,xla_events xe
                                  ,xla_distribution_links xdl
                                  ,ar_distributions_all ada
                                  ,ar_receivable_applications_all araa
                             WHERE gir.je_header_id =:p_je_header_id
                               AND gir.je_line_num = :p_je_line_num
                               AND gir.gl_sl_link_id = xal.gl_sl_link_id
                               AND gir.gl_sl_link_table = xal.gl_sl_link_table 
                               AND xal.ae_header_id = xah.ae_header_id
                               AND xah.event_id = xe.event_id
                               AND xah.application_id = xe.application_id
                               AND xah.entity_id = xe.entity_id
                               AND xe.event_id = xdl.event_id 
                               AND xdl.ae_line_num = xal.ae_line_num
                               AND xah.ae_header_id = xdl.ae_header_id
                               AND xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' 
                               AND xdl.source_distribution_id_num_1 = ada.line_id

                               AND ada.source_id = araa.receivable_application_id

Below is the Query in Case of AR_MISC_CASH_DISTRIBUTIONS_ALL
 SELECT msd.* 
                              FROM gl_import_references gir
                                  ,xla_ae_lines xal
                                  ,xla_ae_headers xah
                                  ,xla_distribution_links xdl
                                  ,ar_misc_cash_distributions_all msd
                                  ,ar_distributions_all dist
                                  ,ar_cash_receipts_all acr
                                  ,ar_receivables_trx_all art
                             where gir.je_header_id = :p_je_header_id
                               AND gir.je_line_num = :p_je_line_num
                               AND gir.gl_sl_link_id = xal.gl_sl_link_id
                               AND xah.ae_header_id = xal.ae_header_id
                               AND xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
                               AND xdl.event_id = xah.event_id
                               AND xah.ae_header_id = xdl.ae_header_id
                               AND msd.event_id = xah.event_id
                               AND msd.misc_cash_distribution_id = dist.source_id
                               --AND dist.source_type = 'MISCCASH'
                               AND acr.cash_receipt_id = msd.cash_receipt_id
                               AND acr.type = 'MISC'

                               AND art.receivables_trx_id = acr.receivables_trx_id 

FNDLOAD for Lookups

Lookups

DOWNLOAD:-

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUST_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"

UPLOAD:-

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct  XX_LOOKUP_TYPE.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

How are Reference Columns Stored in GL_JE_LINES and GL_IMPORT_REFERENCES Tables(165327.1)

In R11i:
Journal Import populates the columns REFERENCE_1 to REFERENCE_10 in the GL_IMPORT_REFERENCES table, with the values from columns REFERENCE21 to REFERENCE30 populated in the GL_INTERFACE table (subledger details).
When import is NOT done in Summary (i.e. it is done in detail mode), then it will also map to GL_JE_LINES columns REFERENCE_1 - REFERENCE_10. 

In R12:
The information stored is substantially different from the information in previous releases due to the Subledger Accounting new architecture. 
In R12 the accounting subledger details are found in XLA tables, and GL_IMPORT_REFERENCES is used to map into it. 
Data can be transferred from SLA to GL in either Summary or Detail mode. This option is defined for the Event Class, which is attached to the Journal Line Type. Journal Line Type is then attached to the Journal Line Definition, which is finally attached to the Subledger Accounting Method. Please note that if the transfer is done in Summary mode, then the Reference columns will not be populated in either GL_IMPORT_REFERENCES or GL_JE_LINES. 

API to delete Value Set Value from Independent Value Set in Oracle APPS

DECLARE
   l_err_msg   VARCHAR2 (1000) := NULL;
   CURSOR c1
   IS
      SELECT ffv.flex_value_id, ffv.flex_value
  FROM fnd_flex_value_sets ffvs
      ,fnd_flex_values ffv
      ,fnd_flex_values_tl ffvt
 WHERE     flex_value_set_name = 'XX Value Set Name' -- Value Set Name
       AND ffv.flex_value_set_id = ffvs.flex_value_set_id
       AND ffvt.flex_value_id = ffv.flex_value_id
       AND ffvs.flex_value_set_id = ffv.flex_value_set_id
       AND ffv.flex_value = 'XX Value Set Value1'
       AND ffvt.language = USERENV('LANG')--'US'
       AND ffv.enabled_flag = 'Y'
       AND ffv.summary_flag = 'N';
BEGIN
   FOR i IN c1
   LOOP
      fnd_flex_values_pkg.delete_row (i.flex_value_id);
      COMMIT;
      DBMS_OUTPUT.put_line (i.flex_value_id || ' Deleted  Successfully !!!!');
   END LOOP;
EXCEPTION
   WHEN OTHERS
   THEN
      l_err_msg := SQLERRM;
      DBMS_OUTPUT.put_line ('Exception: ' || l_err_msg);

END;

General Ledger Profile Options

User Profile Option Name	Description / Purpose
GL: Applications Coexistence Fusion User	(null)
GL: Applications Coexistence System Identifier	(null)
GL: Archive Journal Import Data	(null)
GL: Auto Allocation Rollback Allowed	(null)
GL: DRM API Adapter URL	URL of the Hyperion DRM web-service API.
GL: DRM Property for Value Set Name	Name of the DRM attribute, against which the value set override must be checked.
GL: DRM Property to Allow Hierarchy Export	Name of the DRM attribute, against which the hierarchy override must be checked.
GL: DRM Property to Allow Version Export	Name of the DRM attribute, against which the version override must be checked.
GL: DRM Template for Hierarchy Export	Template name to be used for exporting hierarchies from DRM.
GL: DRM Template for Version Export	Export template name to be used for exporting segment values from DRM.
GL: DRM Username	Login username for Hyperion DRM
GL: DRM WSDL URL	URL for the WSDL of the Hyperion DRM web-service.
GL: Data Access Set	(null)
GL: Debug Log Directory	Directory where log files for AutoAllocation are created
GL: Debug Mode	Indicates if General Ledger programs are run in debug mode; in debug mode, additional messages are printed to the log file.
GL: Income Statement Accounts Revaluation Rule	indicates if PTD or YTD revaluation balances should be used for Revenue and Expense accounts
GL: Journal Entry Purge Set Size	Number of journal entries purged in one transaction
GL: Journal Line Purge Set Size	Number of journal entry lines purged in one transaction
GL: Journal Review Required	Journal review required before posting
GL: Launch AutoReverse After Open Period	Launch AutoReversal program after period is opened.
GL: Number of Accounts In Memory	(null)
GL: Number of Average Balance Post Workers	The number of parallel SQL workers to be used when posting average balance journals.
GL: Number of Purge Workers	The number of processes to be spawned while purging
GL: Number of Records to Process at Once	(null)
GL: Number of formulas to validate for each MassAllocation batch	Number of formulas to be validated for each MassAllocation batch
GL: Number of formulas to validate for each Recurring Journal batch	Number of formulas to be validated for each Recurring Journal batch
GL: Owner's Equity Translation Rule	Indicates the method to use when translating Owner's Equity accounts
GL: Reverse Transaction Codes on Un-natural Balances	Reverse Transaction Codes on Un-natural Balances
GL:Create Encumbrance Entries for Budgetary Accounts	GL:Create Encumbrance Entries for Budgetary Accounts
GL:Create Interfund Entries	Creates balancing Interfund entries during journal import
GL:Enforce Account Category Balancing	Enforce journals to balance by account category in Posting