Now you can Subscribe using RSS

Submit your Email

Friday, 10 July 2015

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

KULDEEP CHAUHAN


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

KULDEEP CHAUHAN



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

Sunday, 5 July 2015

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

KULDEEP CHAUHAN


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

Saturday, 4 July 2015

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

KULDEEP CHAUHAN





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

ECO Cycle (Engineering Change Order) in Oracle Apps

KULDEEP CHAUHAN








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






OracleAppsGuide.com © Coprights 2016,