Archive for July 2015

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

12:42 0 Comments A+ a-



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

FND (Foundation) Basic Table Name in Oracle Apps R12

12:39 0 Comments A+ a-




FND (Foundation) Basic Table Name in Oracle Apps R12 

Basic Table List -:

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

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

05:06 0 Comments A+ a-



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

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

09:33 0 Comments A+ a-


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


  • Defining ECO Types
  • Defining ECO Auto numbering
  • 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

ECO Cycle (Engineering Change Order) in Oracle Apps

09:12 0 Comments A+ a-


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






Subscribe to: Posts (Atom)