Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Day: October 23, 2017

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

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

October 2017
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Sep   Nov »
Blog at WordPress.com.