My Portfolio

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...

Cash Management (CE) New Tables Table Name Feature Area CE_BANK_ACCOUNTS Bank Account Model CE_BANK_ACCT_USES_ALL Bank Account Model CE_GL_ACCOUNTS_CCID Bank Account Model CE_INTEREST_BALANCE_RANGES Balances and Interest Calculation CE_INTEREST_RATES Balances and Interest Calculation CE_INTEREST_SCHEDULES Balances and Interest Calculation CE_BANK_ACCT_BALANCES Balances and Interest Calculation CE_PROJECTED_BALANCES Balances and Interest Calculation CE_INT_CALC_DETAILS_TMP Balances and Interest Calculation CE_CASHFLOWS Bank Account Transfers CE_CASHFLOW_ACCT_H Bank Account Transfers CE_PAYMENT_TRANSACTIONS Bank Account Transfers CE_PAYMENT_TEMPLATES Bank Account Transfers CE_TRXNS_SUBTYPE_CODES Bank Account Transfers CE_XLA_EXT_HEADERS Subledger Accounting CE_CONTACT_ASSIGNMENTS Bank Account Model CE_AP_PM_DOC_CATEGORIES Bank Account Model CE_PAYMENT_DOCUMENTS Bank Account Model CE_SECURITY_PROFILES_GT Bank Account Model CE_CHECKBOOKS Bank Account Model Changed Tables Table Name Feature...

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...

When you say Link I'm presuming you mean BACKTRACK or REFER TO=20  In Metalink look for:=20  NOTE 130542.1  Note 1011799.6 - 'How Does Oracle Payables Populate References Columns  In GL_IMPORT_REFERENCES' helps at all.=20  The reference fields are used in different ways by each subledger.  Following is the use that Oracle Accounts Payable gives to these fields:  USER_JE_CATEGORY_NAME: Payments  USER_JE_SOURCE_NAME: Payables  Reference21 Supplier name  Reference22 Internal Invoice identification  Reference23 Internal Check identification  Reference24 External check number  Reference25 Paid invoice number  Reference26 'AP Invoices'  Reference27 Payment number  Reference29 Paid invoice identification  Reference30 'CASH' or 'DISCOUNT' or 'LIABILITY'  - 19 -  USER_JE_CATEGORY_NAME: Purchase Invoices  USER_JE_SOURCE_NAME: Payables  Reference21 Supplier Name  Reference22 Internal invoi...

Draft Revenue -- draft revenue against project headers   SELECT   ppa.segment1       , ppa. name       , pdra.draft_revenue_num rev_num       , pdra.creation_date       , pdra.transfer_status_code       , pdra.transferred_date       , pdra.transfer_rejection_reason       , pdra.*    FROM   pa.pa_draft_revenues_all pdra       , pa.pa_projects_all ppa   WHERE   pdra.project_id = ppa.project_id        AND   pdra.creation_date >=  '26-FEB-2013' ;   -- draft revenue against tasks   SELECT   ppa.segment1       , ppa. name       , pdri.creation_date       , pdri.amount       , pdri.draft_revenue_num rev_num ...

This post is more on basic table structure of Oracle Account Receivable. 1.Table that holds AR Invoice data The following tables can give most of the invoice information. RA_CUSTOMER_TRX_ALL  stores invoice header information. RA_CUSTOMER_TRX_LINES_ALL stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines. The  AR_PAYMENT_SCHEDULES_ALL  table stores all transactions except adjustments and miscellaneous cash receipts. RA_CUST_TRX_LINE_GL_DIST_ALL  stores accounting distribution records for all transaction lines except bills receivable.The  RA_CUST_TRX_LINE_GL_DIST_ALL  table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line. RA_CUSTOMERS  - Customer information RA_CUST_TRX_TYPES_ALL  - Customer Transaction Type AR_PAYMENT_SCHEDULES_ALL RA_CUSTOMER_TRX_LINES_ALL  - Transaction Line information MTL_SYSTEM_ITEMS  - Base table ...