testoag

Complete relation Query for SLA(Sub Ledger Accounting _XLA), AP(Account Payable) and GL(General Ledger) Links in oracle apps r12  Or  Link Between AP(Account Payable), GL(General Ledger) and SLA(Sub Ledger Accounting _XLA) SELECT DISTINCT GJH.PERIOD_NAME, TRUNC (GJH.CREATION_DATE) GL_DATE,                 GJH.JE_SOURCE, GJH.JE_CATEGORY, GJH.CURRENCY_CODE,                 GJL.DESCRIPTION, GJL.REFERENCE_5, GJL.REFERENCE_10,                 GJL.ACCOUNTED_CR, GJL.ACCOUNTED_DR, GJL.EFFECTIVE_DATE,                 GJL.REFERENCE_1, GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3,                 GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, GCC.SEGMENT7,                 AERLA.JUSTIFICATION, AERLA.PROJECT_NUMBER,                 AERLA.EXPENDITURE_ITEM_DATE, AERLA.RECEIPT_CURRENCY_CODE            FROM APPS.GL_JE_HEADERS GJH,                 APPS.GL_JE_LINES GJL,                 APPS.GL_CODE_COMBINATIONS GCC,                 APPS.GL_IMPORT_REFERENCES GIR,                 APPS.XLA_AE_LINES XAL,            

FND (Foundation) Basic Table Name in Oracle Apps R12  Basic Table List -: FND_USER FND_MENUS FND_FORM_FUNCTIONS FND_APPLICATION FND_APPLICATION_TL FND_CONCURRENT_PROGRAMS FND_CONCURRENT_PROGRAMS_TL FND_CONCURRENT_QUEUES FND_CONCURRENT_QUEUES_TL FND_CONCURRENT_QUEUE_CONTENT FND_CONCURRENT_QUEUE_PARAMS FND_CONCURRENT_QUEUE_SIZE FND_CONCURRENT_REQUESTS FND_CONCURRENT_REQUEST_CLASS FND_CONCURRENT_TIME_PERIODS FND_CONC_PP_TEMPLATES_TL “A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More

Main Interface and Base table in Oracle Apps R12 GL Module (General Ledger Module tables in Oracle Apps R12) Interface Table Base Table gl_interface gl_budget_interface gl_je_batches gl_je_headers gl_je_lines gl_je_sources gl_je_categories gl_sets_of_books gl_daily_rates gl_balances gl_periods gl_period_sets gl_code_conbinations AR Module (Account Receivable Module  tables  in Oracle Apps R12) Interface Table Base Table ra_customers_interface_all   ra_contact_phones_int_all ra_customer_profiles_int_all hz_parties hz_cust_accounts hz_cust_acct_sites_all hz_cust_sit_use_all hz_party_sites hz_locations hz_party_site_uses hz_customer_profiles hz_organization_profiles hz_person_profiles ra_interface_lines_all ra_interface_distributions_all ra_interface_salescredits_all ra_customer_trx_all ra_customer_trx_lines_all ra_cust_trx_line_gl_dist_all ra_cust_trx_types_all ar_payment_schedules_all ra_batch_sources_All ar_vat_tax_all ra_terms ar_periods ar_perio

Setup step for ECO Cycle (Engineering Change Order) in Oracle Apps Defining ECO Types Defining ECO Autonumbering Defining ECO Priorities Defining ECO Reasons Defining ECO Approval Lists Starting the Auto Implement Manager Engineering Profile Options and Security Functions  Defining Engineering Change Orders Creating an ECO Viewing ECO Approval Status Rescheduling an ECO or Revised Items Changing the ECO Status Defining Implementation Costs Defining an ECO Revision Defining ECO Revised Items Viewing ECO Schedule History Defining Revised Components Viewing Item Revisions Assigning or Deleting Substitute Components Assigning Reference Designators Attaching Files to ECOs Engineering Change Orders Field ECO Statuses ECO Revised Item Statuses ECO Approval Statuses Disposition Field ECO Reports in Oracle Apps Engineering Change Order Approval Lists Report Engineering Change Order Detail Report Engineering Change Order Priorities Report Engineering Change Order Reasons Report Engineering Chang

ECO Cycle (Engineering Change Order) in Oracle Apps Step 1- Go to the Engineering Change Order Responsibility  Step 2- Please Define the Engineering Change Order/Query  Step 3- Now Click on Revision Item  Step 4 -  Save the Form. Step 5 - Click on Tools and Release ECO (Engineering Change Order) Accordingly.  Note - You can Check by  SELECT * FROM APPS . ENG_REVISED_ITEMS Step 5-: Now Implement ECO (Engineering Change Order) Step 6-: Now Go to View > Request > Find the "Engineering Change Order" Program. “A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Tec