Site

Search Results

by oracleguru

Program – Create Journals

October 27, 2011 in Concurrent Requests & Reports

 

NAME: Program – Create Journals
SHORT CODE: GLSWPR
MODULE: Oracle General Ledger

Description: Automatically creates feeder system Funds Reservation journals
Navigation: Oracle GL Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • access_set_id : Access set id
  • ledger_id : Ledger id
  • minimum_save_time : Minimum save time
  • create_summary_journal : Create summary journal option
  • run_mode : Run all or specific packet id

 

Tags: No Comments »

by oracleguru

Oracle Distributed Warehouse Management System Overview

October 3, 2010 in Oracle Distributed Warehouse Management System

Oracle Distributed WMS is a new module released in R12 that can support the WMS features in a stand alone system. This architecture is similar to Oracle Advanced Supply Chain Planning system where APS can be implemented as a separate instance. Distributed WMS can also be implemented as separate instance that will collect the data from ERP system and feed the inventory back to ERP system. Distributed WMS can be integrated with non-Oracle ERP systems.

Distributed WMS will be of tremendous help for a customers who need 24 x 7 availability of WMS systems. WMS can still process transactions while ERP system is down. Apart from this it also comes with Light weight Purchasing & Light weight Order Management that supports basic features of OM & PO modules without implementing them fully.

Distributed WMS inbound data collections from ERP:

  • Advanced Shipment Notices (ASN)
  • Purchase Orders
  • Items
  • Customers
  • Suppliers
  • Shipment Requests

Distributed WMS outbound data collections to ERP:

  • PO Receipts
  • Onhand quantities
  • Inventory Adjustments
  • Ship Confirmation

Tags: 1 Comment »

by oracleguru

Oracle Accounts Payables Tables

September 20, 2010 in Technical Design

  • AP_1096_DATA_ALL
  • AP_1099_TAPE_DATA_ALL
  • AP_ACCOUNTING_EVENTS_ALL
  • AP_AE_HEADERS_ALL
  • AP_AE_LINES_ALL
  • AP_AGING_PERIODS
  • AP_AGING_PERIOD_LINES
  • AP_ALLOCATION_RULES
  • AP_ALLOCATION_RULE_LINES
  • AP_APINV_APPROVERS
  • AP_AUD_AUDITORS
  • AP_AUD_AUDIT_REASONS
  • AP_AUD_AUTO_AUDITS
  • AP_AUD_QUEUES
  • AP_AUD_RULE_ASSIGNMENTS_ALL
  • AP_AUD_RULE_SETS
  • AP_AUD_WORKLOADS
  • AP_AWT_BUCKETS_ALL
  • AP_AWT_GROUPS
  • AP_AWT_GROUP_TAXES_ALL
  • AP_AWT_TAX_RATES_ALL
  • AP_AWT_TEMP_DISTRIBUTIONS_ALL
  • AP_BANK_ACCOUNTS_ALL
  • AP_BANK_ACCOUNT_USES_ALL
  • AP_BANK_BRANCHES
  • AP_BANK_CHARGES
  • AP_BANK_CHARGE_LINES
  • AP_BANK_TRANSMISSIONS
  • AP_BATCHES_ALL
  • AP_CARDS_ALL
  • AP_CARD_CODES_ALL
  • AP_CARD_CODE_SETS_ALL
  • AP_CARD_CURRENCIES
  • AP_CARD_DETAILS
  • AP_CARD_EMP_CANDIDATES
  • AP_CARD_GL_ACCTS_ALL
  • AP_CARD_GL_SETS_ALL
  • AP_CARD_PARAMETERS
  • AP_CARD_PROFILES_ALL
  • AP_CARD_PROFILE_LIMITS_ALL
  • AP_CARD_PROGRAMS_ALL
  • AP_CARD_REQUESTS_ALL
  • AP_CARD_SUPPLIERS_ALL
  • AP_CC_ACCEPTORS
  • AP_CC_TRX_DETAILS
  • AP_CHECKRUN_CONC_PROCESSES_ALL
  • AP_CHECKRUN_CONFIRMATIONS_ALL
  • AP_CHECKS_ALL
  • AP_CHECK_FORMATS
  • AP_CHECK_INTEGERS
  • AP_CHECK_STOCKS_ALL
  • AP_CHECK_TRANSMISSIONS
  • AP_CHRG_ALLOCATIONS_ALL
  • AP_CHRG_ALLOCATIONS_ALL_EFC
  • AP_CREDIT_CARD_TRXNS_ALL
  • AP_CURRENCY_GROUP
  • AP_DBI_LOG
  • AP_DISTRIBUTION_SETS_ALL
  • AP_DISTRIBUTION_SET_LINES_ALL
  • AP_DOC_SEQUENCE_AUDIT
  • AP_DUPLICATE_VENDORS_ALL
  • AP_ENCUMBRANCE_LINES_ALL
  • AP_ENCUMBRANCE_LINES_ALL_EFC
  • AP_EXPENSE_FEED_DISTS_ALL
  • AP_EXPENSE_FEED_LINES_ALL
  • AP_EXPENSE_PARAMS_ALL
  • AP_EXPENSE_REPORTS_ALL
  • AP_EXPENSE_REPORT_HEADERS_ALL
  • AP_EXPENSE_REPORT_LINES_ALL
  • AP_EXPENSE_REPORT_PARAMS_ALL
  • AP_EXP_LOCATIONS
  • AP_EXP_REPORT_DISTS_ALL
  • AP_FLEX_SEGMENT_MAPPINGS_ALL
  • AP_HISTORY_CHECKS_ALL
  • AP_HISTORY_INVOICES_ALL
  • AP_HISTORY_INV_PAYMENTS_ALL
  • AP_HOLDS_ALL
  • AP_HOLD_CODES
  • AP_IDENT_PARTY_SITE_GT
  • AP_INCOME_TAX_REGIONS
  • AP_INCOME_TAX_TYPES
  • AP_INTEREST_PERIODS
  • AP_INTERFACE_CONTROLS
  • AP_INTERFACE_REJECTIONS
  • AP_INVOICES_ALL
  • AP_INVOICES_INTERFACE
  • AP_INVOICES_UPG_CONTROL
  • AP_INVOICE_DISTRIBUTIONS_ALL
  • AP_INVOICE_DISTRIBUTIONS_GT
  • AP_INVOICE_KEY_IND_ALL
  • AP_INVOICE_LINES_ALL
  • AP_INVOICE_LINES_INTERFACE
  • AP_INVOICE_PAYMENTS_ALL
  • AP_INVOICE_PREPAYS_ALL
  • AP_INVOICE_RELATIONSHIPS
  • AP_INVOICE_TRANSMISSIONS
  • AP_INV_APRVL_HIST_ALL
  • AP_INV_DISTS_UPDATE
  • AP_INV_SELECTION_CRITERIA_ALL
  • AP_LE_GROUP
  • AP_LIABILITY_BALANCE
  • AP_LINES_UPG_SYNC_DATA
  • AP_LINE_APRVL_HIST_ALL
  • AP_MAP_CODES
  • AP_MAP_TYPES_B
  • AP_MAP_TYPES_TL
  • AP_MATCHED_RECT_ADJ_ALL
  • AP_MC_CHECKS
  • AP_MC_INVOICES
  • AP_MC_INVOICE_DISTS
  • AP_MC_INVOICE_PAYMENTS
  • AP_MC_PAYMENT_HISTORY
  • AP_NEGOTIATION_HIST
  • AP_NOTES
  • AP_NO_MATCH_TRXNS
  • AP_ORG_ATTRIBUTES_GT
  • AP_ORG_COUNTRY_GT
  • AP_OTHER_PERIODS
  • AP_OTHER_PERIOD_TYPES
  • AP_OU_GROUP
  • AP_PARTY_CONTACT_SITES_GT
  • AP_PAYCARD_TRX_FEE_HEADER_ALL
  • AP_PAYCARD_TRX_FEE_LINES
  • AP_PAYMENT_DISTRIBUTIONS_ALL
  • AP_PAYMENT_HISTORY_ALL
  • AP_PAYMENT_HIST_DISTS
  • AP_PAYMENT_KEY_IND_ALL
  • AP_PAYMENT_PROGRAMS
  • AP_PAYMENT_REP_ITF
  • AP_PAYMENT_SCHEDULES_ALL
  • AP_PAYMENT_TEMPLATES
  • AP_PAY_GROUP
  • AP_PBATCH_SETS_ALL
  • AP_PBATCH_SET_LINES_ALL
  • AP_PERIOD_CLOSE_EXCPS_GT
  • AP_POL_CAT_OPTIONS_ALL
  • AP_POL_CONTEXT
  • AP_POL_EXRATE_OPTIONS_ALL
  • AP_POL_EXRATE_TOLERANCES
  • AP_POL_HEADERS
  • AP_POL_ITEMIZATIONS
  • AP_POL_LINES
  • AP_POL_LINES_HISTORY
  • AP_POL_LOCATIONS_B
  • AP_POL_LOCATIONS_TL
  • AP_POL_SCHEDULE_OPTIONS
  • AP_POL_SCHEDULE_PERIODS
  • AP_POL_VIOLATIONS_ALL
  • AP_PPA_INVOICES_GT
  • AP_PPA_INVOICE_DISTS_GT
  • AP_PPA_INVOICE_LINES_GT
  • AP_PREPAY_APP_DISTS
  • AP_PREPAY_HISTORY_ALL
  • AP_PRODUCT_REGISTRATIONS
  • AP_PRODUCT_SETUP
  • AP_PURGE_INVOICE_LIST
  • AP_R115_UPGRADE
  • AP_RECON_CHECK_RESULTS
  • AP_RECON_DETAILS
  • AP_RECON_DISTRIBUTIONS_ALL
  • AP_RECON_ERROR_CHK_GROUPS
  • AP_RECON_ERROR_CHK_GROUP_LINES
  • AP_RECON_LOCKS
  • AP_RECON_RECORD_CODES
  • AP_RECON_RECORD_SPECS
  • AP_RECON_SUMMARIES
  • AP_RECON_TRANSACTION_CODES
  • AP_RECURRING_PAYMENTS_ALL
  • AP_REPORTING_ENTITIES_ALL
  • AP_REPORTING_ENTITY_LINES_ALL
  • AP_SELECTED_INVOICES_ALL
  • AP_SELECTED_INVOICE_CHECKS_ALL
  • AP_SELF_ASSESSED_TAX_DIST_ALL
  • AP_SUPPLIERS
  • AP_SUPPLIERS_INT
  • AP_SUPPLIER_BALANCE_ITF
  • AP_SUPPLIER_CONTACTS
  • AP_SUPPLIER_INT_REJECTIONS
  • AP_SUPPLIER_SITES_ALL
  • AP_SUPPLIER_SITES_INT
  • AP_SUP_SITE_CONTACT_INT
  • AP_SYSTEM_PARAMETERS_ALL
  • AP_TAX_CODES_ALL
  • AP_TAX_DERIVATIONS
  • AP_TAX_RECVRY_RATES_ALL
  • AP_TAX_RECVRY_RULES_ALL
  • AP_TB_BALANCES_TMP
  • AP_TEMP_APPROVAL_ALL
  • AP_TERMS_LINES
  • AP_TERMS_TL
  • AP_TOLERANCES_ALL
  • AP_TOLERANCE_TEMPLATES
  • AP_TRANSMISSIONS_SETUP
  • AP_TRIAL_BAL
  • AP_TRIAL_BALANCE
  • AP_TRIAL_BALANCE_LEDGERS
  • AP_UNSELECTED_INVOICES_ALL
  • AP_USER_EXCHANGE_RATES
  • AP_VENDOR_AUDIT_TMP
  • AP_VENDOR_KEY_IND_ALL
  • AP_WEB_ACCFLEX_SEGMENTS
  • AP_WEB_AMEX_PARAMS
  • AP_WEB_DISC_LINES_GT
  • AP_WEB_EMPLOYEE_INFO_ALL
  • AP_WEB_PREFERENCES
  • AP_WEB_PROXY_ASSIGNMENTS
  • AP_WEB_SIGNING_LIMITS_ALL
  • AP_WEB_VAT_SETUP_ALL
  • AP_WHT_ITF
  • FINANCIALS_PURGES
  • FINANCIALS_PURGES_ALL
  • FINANCIALS_SYSTEM_PARAMS_ALL
  • OIE_ADDON_MILEAGE_RATES
  • OIE_ALLOCATION_PREFS
  • OIE_ATTENDEES_ALL
  • OIE_CURRENT_PAGE_SETTING
  • OIE_DATA_CAPTURE_FIELDS
  • OIE_DATA_CAPTURE_OPTIONS
  • OIE_DATA_CAPTURE_RULES
  • OIE_DISTRIBUTION_SETS_ALL
  • OIE_PDM_DAILY_BREAKUPS
  • OIE_PDM_DESTINATIONS
  • OIE_POL_RATES_INTERFACE
  • OIE_SET_DISTRIBUTIONS

Tags: No Comments »