My Portfolio

Web ADI Errors & Solutions Error1: Exception Name: oracle.apps.bne.exception.BneFatalException Cause: Microsoft VBScript runtime error: 429. ActiveX component can't create object  Solution for Error1:  Do the setup changes in IE 1. On the Tools menu -> Internet Options -> Security tab and press the Custom Level button. 2. Set "Initialize and script ActiveX controls not marked as safe" to "Prompt". 3. Press 'OK' button after that press 'APPLY' button. Error2: Exception Name: oracle.apps.bne.exception.BneFatalException Cause: Line 85 - Programmatic access to Visual Basic Project is not trusted Solution for Error2: Open excel -> Click on File -> Click on Options -> On the bottom left click on "Trust Center" -> On the bottom right click on "Trust Center Settings" button -> On the left click on "Macro Settings" -> on the right "Check" "Trust access to the VBA project object model...

How to join GL tables with XLA (SubLedger Accounting) tables GL_JE_BATCHES (je_batch_id)                            => GL_JE_HEADERS (je_batch_id) GL_JE_HEADERS (je_header_id)                           => GL_JE_LINES (je_header_id) GL_JE_LINES (je_header_id,  je_line_num)               => GL_IMPORT_REFERENCES (je_header_id, je_line_num) GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) XLA_AE_HEADERS (application_id, event_id)              => XLA_EVENTS (application_id, event_id)    XLA_AE_L...

Oracle Subledger Accounting (SLA) Tables, Views Oracle Subledger Accounting Tables: TABLE NAME DESCRIPTION XLA_AAD_GROUPS The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis.  All application accounting definitions with the same GROUP_NUM must be merged together. XLA_AAD_HDR_ACCT_ATTRS The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. XLA_AAD_HEADER_AC_ASSGNS Store the analytical criteria for the application accounting definitions. XLA_AAD_LINE_DEFN_ASSGNS This table stores the journal lines definitions for the application accounting definitions. XLA_AAD_LOADER_DEFNS_T The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. XLA_AAD_LOADER_LOGS The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. XLA_AAD_SOURCES XLA_AAD_SOURCES table stores a...