Oracle Fusion Receivable - Data Flow

Home » Ar_cash_receipts_all Status » Oracle Fusion Receivable - Data Flow

Maybe your like

Pages

  • Home
  • SOA
  • Fusion BI Reporting
  • Fusion BI Reports SQL
  • Fusion Quick Ref SQL
  • OAF
  • WedADI
  • Workflow
  • Reports
  • Debugging
  • FNDLOAD
  • Concurrent Programs
  • Quick Reference API
  • Form Personalization
  • Quiz

Tuesday, 8 January 2019

Oracle Fusion Receivable - Data Flow

Invoice, Debit Memo, Credit Memo select * from RA_CUSTOMER_TRX_ALL -> get Customer_Trx_Id -> get Trx_Class [INV, DM, CM] -> select * from fnd_lookup_values_vl where lookup_type='APPLICATION_TYPE' -> get bill_to_customer_id select * from ra_customer_trx_lines_all where customer_trx_id = select * from hz_cust_accounts where cust_account_id= <> bill_to_customer_id -> get customer account details SELECT * FROM AR_PAYMENT_SCHEDULES_ALL WHERE NVL(CUSTOMER_TRX_ID,-1) = <Customer_Trx_Id> -> table contains payment details
  • CUSTOMER_TRX_ID
  • STATUS [OP: Open, CL: Close]
  • CLASS [INV, DM, CM]
  • CASH_RECEIPT_ID
  • DUE_DATE
  • AMOUNT_DUE_ORIGINAL
  • AMOUNT_DUE_REMAINING
  • CUSTOMER_ID
  • CUSTOMER_SITE_USE_ID
  • AMOUNT
SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE CASH_RECEIPT_ID = <AR_PAYMENT_SCHEDULES_ALL .CASH_RECEIPT_ID> [The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter. Oracle Receivables concurrently creates records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts. For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table. Receivables associates a status with each receipt. These statuses include: APP for applied, UNAPP for unapplied, UNID for unidentified, NSF for nonsufficient funds, REV for reversed receipt and STOP for stop payment. Receivables does not update the status of a receipt from UNAPP to APP until the entire amount of the receipt is either applied or placed on account. A receipt can have a status of APP even if the entire receipt amount is placed on account. Cash receipts proceed through the confirmation, remittance, and clearance steps. Each step creates rows in the AR_CASH_RECEIPT_HISTORY table. The CODE_COMBINATION_ID column in this table stores the general ledger accounts that are debited and credited as part of the cycle of steps. The RECEIVABLES_TRX_ID column links the AR_CASH_RECEIPTS_ALL table to AR_RECEIVABLES_TRX_ALL table and identifies receivables activity associated with miscellaneous receipts. The DISTRIBUTION_SET_ID column links AR_CASH_RECEIPTS_ALL table to AR_DISTRIBUTION_SETS_ALL table and identifies distribution set and distribution set line accounts that are credited for miscellaneous receipts. The CUSTOMER_BANK_ACCOUNT_ID column is a foreign key to the IBY_EXT_BANK_ACCOUNTS table for bank accounts that do not belong to you and have a type of EXTERNAL. The primary key for this table is CASH_RECEIPT_ID. ] Posted by Labels: Fusion-BIP, Receivables

1 comment:

  1. Smith10 November 2019 at 21:53

    Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com

    ReplyDeleteReplies
      Reply
Add commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Disclaimer

The views expressed are my own and not necessarily those of Oracle and its affiliates. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine. I am not responsible if you ever happen to suffer a loss/damage using this blog.

Labels

  • ADF (1)
  • AOL (2)
  • API (4)
  • Arabic-Specific Customization (1)
  • Assets (1)
  • Cash Management (3)
  • Concurrent Program (5)
  • Data Structures (1)
  • Debugging (2)
  • External Table (1)
  • FNDLOAD (1)
  • Form Personalization (5)
  • Fusion Reports SQL (6)
  • Fusion-BIP (30)
  • Fusion-SQL (3)
  • General Ledger (3)
  • HCM (3)
  • Interview Questions (5)
  • JavaScript (3)
  • leetcode (1)
  • nodeJs (1)
  • OAF (20)
  • Oracle Application Developer Guide (1)
  • Oracle Technical Various (2)
  • Order Management (2)
  • Payables (7)
  • PL/SQL (14)
  • PLSQL Web Service (2)
  • Procurement (1)
  • R12 Scripts (4)
  • Receivables (9)
  • Reports (5)
  • RTF Coding (34)
  • SOA (1)
  • SQL (6)
  • SQL Hints (1)
  • SQL LOADER (2)
  • SQL Optimization (1)
  • Subtemplates (1)
  • Table Relations (2)
  • UTL_FILE (2)
  • VM (1)
  • WEB ADI (8)
  • Workflow (5)
  • XML (5)
  • XML Publisher (21)
  • XSLT (3)

Pages

  • Home
  • Quiz
  • Workflow
  • Reports
  • Form Personalization
  • Quick Reference API
  • Fusion Quick Ref SQL
  • OAF
  • ADF
  • WedADI
  • Concurrent Programs
  • FNDLOAD
  • Debugging

Followers

Total Hits

Contact Form

Name Email * Message *

Blog Archive

  • ▼  2019 (67)
    • ▼  January (15)
      • Print Complete XML Data Element Values in RTF for ...
      • Oracle Fusion Tables
      • xsl, xslt : Using in BI Publisher
      • Learn XSLT
      • Report with Variable Columns Based on XML Data
      • Using XPATH in RTF: count, starts-with, name funct...
      • Using XPATH in RTF Templates
      • Address Formatting SQL
      • Getting Started with XSD
      • BIP: Webservice Based Data Set in Data Model: Resp...
      • Oracle SOA: Getting Started - Day-1
      • BI Publisher : SubTemplates : Testing from Desktop...
      • Oracle Fusion Receivable - Data Flow
      • BI Publisher: RTF: Creating Pivot Table Reports
      • AP Invoice Tax SQL

Popular Posts

  • New tables in R12 for Payables and to what R12 objects are obsoleted 11i tables mapped Suppliers New R12 tables  -> Old 11i Tables AP_SUPPLIERS - replaces PO_VENDORS AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SITES_ALL Ad...
  • page breaks in rtf template there are 3 ways to create page breaks <?split-by-page-break:?> #below code should be written inside the BIP Field element <x...
  • PL-SQL Interview Questions Collections 2. What is the basic structure of PL/SQL? PL/SQL uses block structure as its basic structure. Anonymous...
  • Understand Loops in BI Publisher: for-each vs for-each-group vs for-each: current-group xml grouping SUPPLIERS INVOICES Required: SUPPLIERS CURRENCY INVOICES ‘for-each-group’ to regroup to show the in...
  • SQL: Requisition to PO: Oracle Fusion SELECT POH.PO_HEADER_ID, POH.SEGMENT1  , PRHA.REQUISITION_NUMBER FROM PO_HEADERS_ALL POH, PO_DISTRIBUTIONS_ALL PDA , POR_REQ_DISTRIBU...
  • Parameterized Popup in OAF for R12.1.3 As per Dev Guide, There are two popup screen we can prepare in OAF, embedded and Parametrized, oracle has its tutorial on embedded pop...
  • Handle Null or Not Present tags in xml file in BI Publisher Workaround Option 2 in RTF template If using RTF templates another option is to use a conditional IF at the template level to verify the ...
  • Creating Search Insert Update Delete On Same Page in OAF I would provide an example of Creating Search Insert Update Delete On Same Page in OAF Outline of the Development Steps A. Create DB Com...
  • Dependent LOV in WEBADI using Java validator 1. Create a webadi for invoice/supplier load 2. Interface Fields     a. vendor name ()     b. vendor site code () 3. based on the valu...
  • Oracle Fusion Business Unit, Ledgers, Value Set SQLs --BUSINESS UNIT ---------------------- SELECT BusinessUnitEO.NAME BU_NAME,   LocationDPEO.DESCRIPTION LOCATION,   PersonNameDPEO.LIST_NA...

Live

Tag » Ar_cash_receipts_all Status