Quick View Of Tables Involved Receipts

Oracle Apps Knowledge Sharing

Meant for sharing our knowledge related to Oracle E-Business Suite

• HOME
• TECHNICAL TUTORIALS
• USEFUL LINKS
• ARTICLE INDEX
• VIDEO INDEX

• API's
• AP
• AOL
• AR
• CE
• IBY
• GL
• SLA
• INV
• PO
• OM
• OPM
• TCA
• SOA
• WF
• Scripts
• Alerts
• IQ
• PLSQL
• SQL

Saturday, February 13, 2010

Quick view of tables involved Receipts

AR_PAYMENT_SCHEDULES_ALL, The AR_PAYMENT_SCHEDULES_ALL table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. Transaction classes determine if a transaction relates to either the RA_CUSTOMER_TRX_ALL table or the AR_CASH_RECEIPTS_ALL table. Using the CUSTOMER_TRX_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the RA_CUSTOMER_TRX_ALL table for non-payment transaction entries, such as the creation of credit memos, debit memos, invoices, chargebacks, or deposits. Using the CASH_RECEIPT_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the AR_CASH_RECEIPTS_ALL table for invoice-related payment transactions. AR_CASH_RECEIPTS_ALL, 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. AR_RECEIVABLE_APPLICATIONS_ALL, 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. Cash receipts proceed through the confirmation, remittance, and clearance steps. Each step creates rows in the AR_CASH_RECEIPT_HISTORY table

Do you think this Article is useful?

0 Responses to “Quick view of tables involved Receipts”

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.

• Twitter
• Facebook
• RSS
• Email

Stay Connected

Follow @shareoracleapps

Followers

Modules

Accounting (6) AP (58) API's (190) AR (56) Cash Management (23) DBA (23) DBMS_DDL (1) DBMS_LOB (1) DBMS_SCHEDULER (8) DBMS_UTILITY (4) DBMS_XSLPROCESSOR (2) DIRECT PUNCHOUT (1) E-Commerce Gateway (1) EDI (1) ETEXT Templates (5) Fixed Assets (4) FND (79) Forms Personalization (4) Human Resources (HR) (11) Interview Questions (17) Inventory (27) iSourcing (1) iSuppliers (3) JAVA (1) Jdeveloper Issues (1) Oracle (75) Oracle Alerts (3) Oracle Application Framework(OAF) (2) Oracle apps (408) Oracle E-Business Tax (2) Oracle General Ledger (23) Oracle iProcurement (8) Oracle Payments (18) Oracle Process Manufacturing (1) Oracle Purchasing (26) Order Management (44) PDOI Sample Scripts (2) PLSQL (44) PLSQL Tuning Examples (4) REUSABLE CODE (24) Scripts (82) SED (1) Shell Scripts (6) SOA (12) SQL (35) SQL TUTORIAL (17) Sub Ledger Accounting (7) Supplier API's (9) TCA (41) Useful Queries (82) UTL_ENCODE (1) UTL_FILE (2) UTL_MATCH (1) UTL_URL (1) Workflow (9) Workflow Mailer (1) XML Publisher (10)

Popular Posts

• Procure To Pay Cycle in Oracle Apps R12 (P2P Cycle)
• WSH_DELIVERY_DETAILS.RELEASED_STATUS ( Pick Release Status)
• API to find AP INVOICE Status (AP_INVOICES_PKG.GET_APPROVAL_STATUS)
• Query to fetch Purchase Receipt and its related Purchase order, Vendor details in Oracle Apps R12 (RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES)
• Query to find Supplier and their Bank Details in R12
• API to add responsibility to a user (FND_USER_PKG.ADDRESP)
• Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS)
• Forms Personalization in Oracle Apps R12 Example: Zoom Functionality
• Query to get basic AP Invoice and Payment information from Oracle Apps R12
• API to Update Purchase Order Document (PO) (PO_CHANGE_API1_S.UPDATE_PO)

Blog Archive

Blog Archive December 2022 (1) November 2022 (2) October 2022 (3) September 2022 (3) September 2021 (1) June 2021 (1) May 2021 (4) April 2021 (2) March 2021 (5) February 2021 (1) January 2021 (3) December 2020 (1) November 2020 (3) October 2020 (3) September 2020 (5) August 2020 (10) July 2020 (6) June 2020 (6) May 2020 (7) September 2019 (2) August 2019 (4) April 2019 (9) March 2019 (1) August 2018 (2) March 2018 (7) February 2018 (2) July 2017 (2) June 2017 (1) January 2017 (3) November 2016 (2) April 2016 (4) June 2015 (6) May 2015 (20) August 2014 (8) January 2014 (2) December 2013 (2) September 2013 (4) June 2013 (2) May 2013 (2) April 2013 (3) September 2012 (9) April 2012 (5) March 2012 (5) February 2012 (9) January 2012 (2) December 2011 (3) November 2011 (2) October 2011 (19) July 2011 (1) June 2011 (7) May 2011 (34) March 2011 (23) February 2011 (20) January 2011 (14) December 2010 (21) November 2010 (7) October 2010 (8) September 2010 (1) August 2010 (3) July 2010 (2) June 2010 (40) May 2010 (32) April 2010 (11) March 2010 (27) February 2010 (38) January 2010 (21) December 2009 (2)

shareoracleapps.com

Site Stats (Last 30 Days)

All Rights Reserved Oracle Apps Knowledge Sharing | Home by Team Search