Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Receivables

Lockbox Basics

  • by Yogesh Pachpute
  • Posted on February 6, 2018February 6, 2018
  • Receivables

Auto Lockbox in Oracle Receivables Introduction AutoLockbox is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. This feature eliminates the need for manual data entry […]

Read More

What are the different methods to transfer Sub ledger journals to GL

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • Payables

What are the different methods to transfer Sub ledger journals to GL? a) ONLINE MODE GL Transfer can be spawned during Online Accounting using the “Final Post” option for a specific document (Example: AP Invoice and […]

Read More

Data flow between AR and SLA

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

Data flow between AR and SLA Queries to retrieve data from XLA tables for a given AR transaction Q1) Get the customer_trx_id for the transaction number SELECT * FROM ra_customer_trx_all WHERE trx_number = &trx_number; Q2) […]

Read More

AR Transaction to SLA Link

  • by Yogesh Pachpute
  • Posted on October 23, 2017April 8, 2019
  • Oracle Cloud Fusion Financial

AR Transaction to SLA Link R12 Important columns in the RA_CUST_TRX_LINE_GL_DIST table include: CUST_TRX_LINE_GL_DIST_ID column CODE_COMBINATION_ID column CUSTOMER_TRX_LINE_ID column ACCOUNT_CLASS column AMOUNT column The RA_CUST_TRX_LINE_GL_DIST table stores the accounting distribution for invoice, debit memo, and […]

Read More

AR Adjustments to SLA Link R12

  • by Yogesh Pachpute
  • Posted on October 23, 2017April 8, 2019
  • Oracle Cloud Fusion Financial

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 […]

Read More

Transactions with Credit Applied and SLA Link

  • by Yogesh Pachpute
  • Posted on October 23, 2017April 8, 2019
  • Oracle Cloud Fusion Financial

Transactions with Credit Applied and SLA Link R12 Accounting Data Model – Transaction With Credit Applied •Where postable <> ‘N’ •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=RA) •Debit and credit amounts should match •Amount prorated for each […]

Read More

Function to get reporting currency conversion rate for AR invoice

  • by Yogesh Pachpute
  • Posted on October 19, 2017October 19, 2017
  • Receivables

Function to get reporting currency conversion rate for AR 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 […]

Read More

AR Receipts to SLA Link R12

  • by Yogesh Pachpute
  • Posted on October 17, 2017April 8, 2019
  • Oracle Cloud Fusion Financial

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 […]

Read More

AR Miscellaneous Receipt to SLA Link R12

  • by Yogesh Pachpute
  • Posted on October 17, 2017April 8, 2019
  • Oracle Cloud Fusion Financial

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 […]

Read More

AR Reconciliation – Internal (Within AR) and External (GL) in R12

  • by Yogesh Pachpute
  • Posted on October 17, 2017October 26, 2018
  • AR Reconciliation

Ref: Oracle Webcast – Oracle receivables posting & Reconciliation in R12  

Read More

Posts navigation

Older posts

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Fixed Asset (23)
  • General Ledger (19)
  • GRC (5)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (11)
  • Oracle Database (2)
  • Oracle Fusion HCM (9)
  • Oracle Fusion HCM Technical (4)
  • Oracle Fusion Technical (9)
  • Oracle Installations (3)
  • Oracle Inventory (1)
  • Oracle SQL (4)
  • Order Management (1)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (16)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • SubLedger Accounting (25)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 17 other followers

Calendar

Calendar

March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Apr    
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×