Link Between AP(Account Payable),GL(General Ledger) and SLA(Sub Ledger Accounting _XLA)

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,

                APPS.XLA_AE_HEADERS XAH,

                APPS.AP_INVOICES_ALL AIA,

                APPS.AP_INVOICE_LINES_ALL AILA,

                APPS.AP_INVOICE_DISTRIBUTIONS_ALL AIDA,

                APPS.AP_EXPENSE_REPORT_HEADERS_ALL AERHA,

                APPS.AP_EXPENSE_REPORT_LINES_ALL AERLA

--APPS.XLA_EVENTS XE,

--XLA.XLA_TRANSACTION_ENTITIES XTE,

--APPS.XLA_DISTRIBUTION_LINKS XDL,

WHERE           GJH.JE_HEADER_ID = GJL.JE_HEADER_ID

            AND GJL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID

            AND GJL.JE_HEADER_ID = GIR.JE_HEADER_ID

            AND GJL.JE_LINE_NUM = GIR.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.APPLICATION_ID = XAH.APPLICATION_ID

            AND AIA.INVOICE_ID = AILA.INVOICE_ID

            AND AIA.INVOICE_ID = AIDA.INVOICE_ID

            AND AILA.LINE_NUMBER = AIDA.DISTRIBUTION_LINE_NUMBER

            AND AERHA.REPORT_HEADER_ID = AERLA.REPORT_HEADER_ID

            AND AIA.INVOICE_ID = AERHA.VOUCHNO

            AND AIDA.INVOICE_LINE_NUMBER = AERLA.DISTRIBUTION_LINE_NUMBER

            AND AIDA.ACCOUNTING_EVENT_ID = XAH.EVENT_ID

            AND XAL.AE_HEADER_ID = XAH.AE_HEADER_ID

            AND (    GJH.JE_SOURCE = 'Payables'

                 AND GJH.JE_CATEGORY = 'Purchase Invoices'

                )

            AND GJH.CURRENCY_CODE = 'INR'

--AND XAH.EVENT_ID=XE.EVENT_ID

--AND XAH.APPLICATION_ID=XE.APPLICATION_ID

--AND XE.ENTITY_ID=XTE.ENTITY_ID

--AND XE.APPLICATION_ID=XTE.APPLICATION_ID

--AND XTE.SOURCE_ID_INT_1=AIA.INVOICE_ID

--AND XAH.APPLICATION_ID=XTE.APPLICATION_ID

--AND XAH.ENTITY_ID=XTE.ENTITY_ID

--AND XDL.APPLICATION_ID=XAH.APPLICATION_ID

--AND AIDA.INVOICE_DISTRIBUTION_ID=XDL.SOURCE_DISTRIBUTION_ID_NUM_1

--AND XDL.AE_HEADER_ID=XAH.AE_HEADER_ID

--AND XE.EVENT_ID=AIDA.ACCOUNTING_EVENT_ID

--AND AERHA.INVOICE_NUM LIKE '%12345%'

--AND GJH.PERIOD_NAME = 'AUG-15'

“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 Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Continue Reading..

FND (Foundation) Basic Table Name in Oracle Apps R12

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 Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Continue Reading..

AP, AR, GL, INV, PA, FA, PO, TCA, Workflow - Interface and Base table in Oracle Apps R12

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_period_types

OM Module (Order Management Module tables in Oracle Apps R12)
Interface Table	Base Table
oe_headers_iface_all oe_lines_iface_all oe_actions_iface_all	oe_order_headers_all oe_order_lines_all oe_order_sources oe_transaction_types_tl oe_transaction_types_all

INV Module (Inventory Module tables in Oracle Apps R12)
Interface Table	Base Table
mtl_system_items_interface mtl_item_categories_interface mtl_item_revisions_interface mtl_interface_errors	mtl_system_items_b mtl_system_items_tl mtl_item_locations mtl_item_categories mtl_item_revisions_b mtl_parameters hr_all_organizations_units cst_item_costs qp_list_headers jft_rs_salesreps

Workflow Tables tables in Oracle Apps R12
Interface Table	Base Table
	wf_items wf_process_activities wf_item_activity_statuses wf_item_types_tl

PO Module (Purchase Order tables in Oracle Apps R12)
Interface Table	Base Table
PO REQUISITIONS po_requistitions_interface_all po_req_dist_interface_all PURCHASE ORDERS po_headers_interface po_lines_interface po_distributions_interface	PO VENDORS po_vendors po_vendor_sites_all po_vendor_contacts PO REQUISITIONS po_requisition_headers_all po_requisition_lines_all po_req_distributions_all PURCHASE ORDERS po_headers_all po_lines_all po_line_locations_all po_distributions_all

AP Module (Account Payables tables in Oracle Apps R12)
Interface Table	Base Table
ap_invoices_interface ap_invoice_lines_interface	ap_invoices_all ap_invoice_distributions_all ap_payments_schedules_all

FA Module (Fixed Asset tables in Oracle Apps R12)
Interface Table	Base Table
fa_inv_interface fa_production_interface fa_mass_additions	fa_additions_b fa_additions_tl fa_books fa_deprn_summary fa_deprn_details fa_deprn_history fa_retirements

PA  Module (Project Accounting in Oracle Apps R12)
Interface Table	Base Table
	pa_tasks pa_expenditure_items_all pa_expenditures_all pa_transaction_constrols pa_projects_all pa_budget_versions pa_resource_assigments

TCA Architecture (Trading Community Architecture tables in Oracle Apps R12)
Interface Table	Base Table
	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

“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 Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Continue Reading..

Setup Step for ECO Cycle (Engineering Change Order) in Oracle Apps

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 Change Order Schedule Report

“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 Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Continue Reading..

ECO Cycle (Engineering Change Order) in Oracle Apps

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, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Continue Reading..