Receipt Creation In R12 Account Receivables

Home » Ar_cash_receipt_history_all Status » Receipt Creation In R12 Account Receivables

Maybe your like

Oracle Apps Knowledge Sharing

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

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

Thursday, March 4, 2010

Receipt Creation in R12 Account Receivables

Whenever we create a receipt it finds its entry in the below tables

  1. AR_CASH_RECEIPTS_ALL
  2. AR_CASH_RECEIPT_HISTORY_ALL
  3. AR_RECEIVABLE_APPLICATIONS_ALL with the status = 'UNAPP'
Different Status: 1. APP -- Applied 2. UNAPP -- Unapplied 3. UNID -- Unidentified UNID: - Come when customer is not known UNAPP: - Come when no application has been done select cash_receipt_id,status, amount,receipt_method_id from ar_cash_receipts_All a where receipt_number = 'TEST06'; select name from ar_receipt_methods where receipt_method_id = 'Receipt method id from previous Query' ;

Do you think this Article is useful?

Related Posts Widget for Blogger

1 Responses to “Receipt Creation in R12 Account Receivables”

malini said... January 8, 2021 at 3:45 AM

a recipt number has been created. When query the database, it is available on the ar_cash_receipts_All but it is not found in the EBS R12 form. What can be the reason.

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.

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 get basic AP Invoice and Payment information from Oracle Apps R12
  • API to add responsibility to a user (FND_USER_PKG.ADDRESP)
  • Forms Personalization in Oracle Apps R12 Example: Zoom Functionality
  • Query to find Supplier and their Bank Details in R12
  • Query to Fetch Employee Details in Oracle Apps R12 (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_ALL_POSITIONS, PER_PHONES)
  • Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS)

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

Tag » Ar_cash_receipt_history_all Status