Skip to main content

Posts

Showing posts with the label AR Technical

AR Adjustments to SLA Link R12

AR Adjustments to SLA Link R12 Accounting Data Model – Adjustments •Where postable <> ‘N’ •Status should be ‘A’ •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=ADJ) •Debit & credit amounts should match •Adjustments Status = ‘W’ (Waiting for Approval) to either A or R •Adjustments with status R (Reject) should not be processed i.e. EVENT_STATUS_CODE=N •PROCESS_STATUS_CODE=U in XLA_EVENTS AR_ADJUSTMENTS table Important columns in the AR_ADJUSTMENTS table include: ADJUSTMENT_ID column AMOUNT column CUSTOMER_TRX_ID column TYPE column PAYMENT_SCHEDULE_ID column CODE_COMBINATION_ID column The AR_ADJUSTMENTS table stores information about invoice adjustments. Each adjustment is stored as a unique record, based on the primary key adjustment_id. The amount column stores the amount of the adjustment. Receivables uses the customer_trx_id and payment_schedule_id to link the adjustment to the adjusted transaction and to update the amount_due_remaining and amount_adjusted colum...

R12- AR Tables and Changes

Here goes... AR R12 Tables New Tables Description of Change AR_REC_TRX_LE_DETAILS_ALL Added detail level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a receivables activity and the sets of asset and liability tax codes by legal entity. AR_DEFERRAL_REASONS Revenue Deferral Reasons AR_DEFERRED_LINES_ALL Revenue Deferral Reasons AR_RDR_PARAMETERS_GT Revenue Deferral Reasons AR_REVIEWED_LINES_GT Revenue Deferral Reasons Changed Tables Table Name Description of Change RA_CUSTOMER_TRX_LINES_ALL Added numerous columns to support E-Business Tax and line-level Ship To, Added Payment extension identifier. AR_MEMO_LINES Added tax_product_category to support E-Business Tax uptake. AR_TRX_LINES_GT Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag. AR_TRX_LINES_TMP_GT Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag. AR_ARCHIVE_DETAIL Added numerous columns to sup...

Aging Reports in Oracle Apps Receivables - Quick Overview

AGING REPORTS IN ORACLE APPS RECEIVABLES - QUICK OVERVIEW OVERVIEW Aging reports are used to review information about your open items so as to know how much funds have been held up and with whom. Aging reports display the customers who have outstanding balances and the amount each customer owes us which also helps to expedite the collection process.    Receivables  aging reports Do Not include customers with a zero outstanding balance. These reports can print both detail and summary information about your customer’s current and  past due  invoices, debit memos, and charge backs.    Receivables also gives the option to see  credit memos , on–account credits, unidentified payments, and on–account and unapplied cash amounts. As mentioned above, Oracle Receivables ages the transactions according to   due date .  The aging  reports however select transactions according to   gl date .  Receivables aging reports includes all open...

APPS TABLES WITH LINKS

======= SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'AP_E%ALL' AND OWNER='AP' PAYABLES INTERFACE TABLES ========================== AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT PAYABLES BASE TABLES ====================== AP_INVOICES_ALL AP_INVOICE_LINES_ALL AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_PAYMENTS_ALL AP_PAYMENT_SCHEDULES_ALL AP_PAYMENT_HISTORY_ALL AP_PAYMENT_DISTRIBUTIONS_ALL AP_AE_HEADERS_ALL AP_AE_LINES_ALL AP_BATCHES_ALL AP_TERMS AP_LOOKUP_CODES AP_ACCOUNTING_EVENTS_ALL AP_BANK_ACCOUNTS_ALL AP_BANK_ACCOUNT_USES_ALL AP_CHECKS_ALL AP_HOLDS_ALL AP_CARD_CODES AP_CARDS_ALL AP_CARD_CODES_ALL AP_CARD_CODE_SETS_ALL AP_EXPENSE_REPORTS_ALL AP_EXPENSE_REPORT_HEADERS_ALL AP_EXPENSE_REPORT_LINES_ALL AP_EXP_REPORT_DISTS_ALL ==================================================================================== SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'PO_%E_ALL' AND OWNER='PO' PO I...