Function to get reporting currency conversion rate for AP invoice
Function to get reporting currency conversion rate for AP invoice 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 […]
Author: Yogesh Pachpute
AR Receipts to SLA Link R12
AR Receipts to SLA Link R12 Accounting Data Model – Receipts •Where POSTABLE_FLAG <> ‘N’ •EVENT_ID should exist •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH and RA) •Debit & credit amounts should match Important columns in the […]
AR Miscellaneous Receipt to SLA Link R12
AR Miscellaneous Receipt to SLA Link R12 Accounting Data Model – Miscellaneous Receipts •Where POSTABLE_FLAG <> ‘N’ •EVENT_ID should exist •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH & MCD) •Debit & credit amounts should match Important columns […]
AR Reconciliation – Internal (Within AR) and External (GL) in R12
Ref: Oracle Webcast – Oracle receivables posting & Reconciliation in R12
How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?
How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger? This table contains the link between transactions and subledger journal entry lines. Module: Payables Column – EVENT_ID: Invoice/Payment In case of invoice it will be […]
Query to find responsibility for Operating Unit or Org_id
1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.fnd_profile_options_vl fpo, apps.fnd_responsibility_vl frv, apps.fnd_profile_option_values fpov, apps.hr_organization_units hou WHERE hou.NAME = <OU Name> AND fpov.profile_option_value = […]
Query to find Org ID attached to responsibility
Get Org id from Responsibility Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.hr_organization_units hou, apps.fnd_profile_options_vl fpo, apps.fnd_profile_option_values fpov, apps.fnd_responsibility_vl frv WHERE […]
Receivables Important Concurrent Programs For Posting in R12
Receivables Important Concurrent Programs for Posting in R12 •Create Accounting •Submit Accounting •Transfer Journal Entries to General Ledger •Unposted Items Report •Revenue Recognition •Subledger Period Close Exception Report Create Accounting a) Invoice distribution lines not […]
Are Credit Card Transactions Released If An Imported Expense Report Invoice Is Deleted In Payables?
Goal: If an expense report containing credit card transactions is approved and imported, then the associated invoice is deleted in Payables, are the credit card transactions then released for use with a new expense report […]
Credit Card Transactions are not Reinstated When an Associated Invoice is Canceled
Goal: After an expense report with credit card transactions has been cancelled in Accounts Payable the expense report correctly shows a status of Cancelled, however, the credit card transactions on the expense report are not […]
Enterprise Resource Planning and Integrations BlogSpot 