Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Receivables

RMCS – Order Management Integration

  • by Yogesh Pachpute
  • Posted on May 13, 2022May 13, 2022
  • Cost Management

Storyline and Personas: The demo flow begins with a sales order being entered into Order Management. We then follow the transaction through to Accounts Receivable, Revenue Management, Inventory, and Cost Accounting. In RMCS we will […]

Read More

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, 2017February 2, 2022
  • Oracle Fusion Technical

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, 2017February 2, 2022
  • Oracle Fusion Technical

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, 2017February 2, 2022
  • Oracle Fusion Technical

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, 2017February 2, 2022
  • Oracle Fusion Technical

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, 2017February 2, 2022
  • Oracle Fusion Technical

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

Posts navigation

Older posts

Categories

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

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

Join 35 other subscribers

Calendar

Calendar

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...