AR Checking Query

http://receivablesar.blogspot.com/2016/09/ar-checking-query.html

Customer Checking

select count(*)
  from RA_CUSTOMER_TRX_ALL          ll,
       ar_customers                 kk,
       RA_CUST_TRX_LINE_GL_DIST_ALL jj,
       gl_code_combinations         gcc,
       Ra_Cust_Trx_Types_all tt
 where kk.CUSTOMER_ID = ll.BILL_TO_CUSTOMER_ID
   and jj.CUSTOMER_TRX_ID = ll.CUSTOMER_TRX_ID
   and gcc.CODE_COMBINATION_ID = jj.CODE_COMBINATION_ID
   and tt.CUST_TRX_TYPE_ID=ll.CUST_TRX_TYPE_ID
   and ll.ORG_ID=jj.ORG_ID
   and tt.ORG_ID=  jj.ORG_ID
   and jj.ORG_ID=82   --479

 
 and gcc.SEGMENT2 = '001'
 and kk.customer_id !=1040 --001

  --and gcc.SEGMENT2='002'
 --and kk.CUSTOMER_ID !=1043 --002

-- and gcc.SEGMENT2='002'
 -- and kk.CUSTOMER_ID !=1047 --002


---------------------------------------------------------

Transaction Type and Line Item Location Checking

select count(*)
  from RA_CUSTOMER_TRX_ALL          ll,
       ar_customers                 kk,
       RA_CUST_TRX_LINE_GL_DIST_ALL jj,
       gl_code_combinations         gcc,
       gl_code_combinations gc,
       Ra_Cust_Trx_Types_all tt
 where kk.CUSTOMER_ID = ll.BILL_TO_CUSTOMER_ID
   and jj.CUSTOMER_TRX_ID = ll.CUSTOMER_TRX_ID
   and gcc.CODE_COMBINATION_ID = jj.CODE_COMBINATION_ID
   and tt.CUST_TRX_TYPE_ID=ll.CUST_TRX_TYPE_ID
   and gc.CODE_COMBINATION_ID=tt.GL_ID_REC
   and gcc.SEGMENT2!=gc.SEGMENT2

Default Draft Option When Create Accounting From Menu Tools For Receivables

http://receivablesar.blogspot.com/2016/08/default-draft-option-when-create.html

As workaround you can apply the following personalization in both screens through Help > Diagnostics > Custom Code > Personalize.

Please see below screen prints on how to implement this.

Those additionally include on how to disable the other 2 options.

Changing Standard Oracle Message

http://receivablesar.blogspot.com/2016/08/changing-standard-oracle-message.html

goal: How to generate messages?

fact: FNDMDMSG - Define Messages

fact: FNDMDGEN - Generate Messages



fix:

Responsibility: System Administrator
Submit the concurrent process : Generate Messages

Afterwards restart Oracle Application.

OR

Run from command line. 
Syntax is : 
$ FNDMDGEN APPS/APPS 0 Y  DB_TO_RUNTIME <
application shortname> .msb

+---------------------------------------------------------------------------+

Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDMDGEN: Generate Messages

+---------------------------------------------------------------------------+

Current system time is 10-AUG-2016 15:51:10

+---------------------------------------------------------------------------+

Writing file /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US648412.tmp

Moving file /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US.msb to /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US648412.old.

Moving file /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US648412.tmp to /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US.msb.

Processed a total of 7060 messages

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

No completion options were requested.

Output file size:

0

+---------------------------------------------------------------------------+

Concurrent request completed successfully

Current system time is 10-AUG-2016 15:51:11

+---------------------------------------------------------------------------+

Bounce the Application Tier to see Changes

Why does concurrent program FNDMDGEN: Generate Messages only create message files on the Concurrent Manager tier?

SOLUTION

As per the development guide:
Make a copy of the resulting file (which is on the server side), and transfer the copy to the appropriate mesg directory for your application on other machines as needed (concurrent processing servers, forms server machines). The file should have the same name (such as US.msb) in each location.

The program was never intended to create the message files on all tiers as such manual copying of the files are required as per the guide.

Credit Memo against Invoice

http://receivablesar.blogspot.com/2016/06/credit-memo-against-invoice.html

Please Copy and Paste the Below URL in your Browser

http://oracler12applicationfunctional.blogspot.com/2014/03/credit-memo-against-invoice-in-r12.html

Receipt Workbench Issue: Custom Menu has Tools -> View Accounting Disabled. How can I enable it? (Doc ID 417417.1)

http://receivablesar.blogspot.com/2016/06/applies-to-oracle-receivables-version-11.html

Receipt Workbench Issue: Custom Menu has Tools -> View Accounting Disabled. How can I enable it? (Doc ID 417417.1)

GOAL

When you navigate to Receipts window using a Custom Responsibility that has Custom menu attached, the Tools > View Accounting menu is grayed out/disabled. How do I enable this option?

Responsibility: Receivables manager

Navigation: Receipt > Receipts
Invoke Menu Tools > View Accounting

It is grayed out on Receipts form

SOLUTION

Function SLA: View Accounting - Lines Inquiries needs to be attached to the menu.

Perform the following steps:

Responsibility: System Administrator

Navigation: Application > Menu
Query the menu being used
Add a new line and enter the following values:
Seq# - enter a unique value
Prompt - leave blank
SubMenu - leave blank
Function - SLA: View Accounting - Lines Inquiries
Description - enter a description
Grant - Yes

Save your changes. Now, View Accounting should be enabled on Tools Menu on Receipts form.

Receipt Workbench Error: Listing of APP-AR Errors (Doc ID 460857.1)

http://receivablesar.blogspot.com/2016/05/receipt-workbench-error-listing-of-app.html

Receipt Workbench Error: Listing of APP-AR Errors (Doc ID 460857.1)

How to enable Manage Exceptions on Oracle Receivables R12.2.4

http://receivablesar.blogspot.com/2016/03/how-to-enable-manage-exceptions-on.html

How to Setup the New Manage Accounting Exception Program in Receivables? (Doc ID 1937611.1)

APPLIES TO:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

GOAL

How can I setup the new Consolidated Review and Manage Accounting Exception Program in Receivables?

SOLUTION

Please perform the following:

1. For Release 12.1, the Manage Exception Functionality is available through Patch 22482346, and in the FEB-2016 RPC Patch 22471504. For Release 12.2, it is available through Patch 16634326.
NOTE: The program will ONLY sweep those transactions that are in error (xla_events.event_status_code = U and xla_events.process_status_code = I)

2. Once the patch is applied, please make sure the function Accounting Exception: Manage (AR_ARXSUMPS_MANAGE_EXP) is available in the AR Control Accounting Menu:

a. Under your System Administrator Responsibility, please go to Application --> Menu

b. Query for Menu = AR_CONTROL_ACC_GUI



3. When you try to close the period the system will check for Unposted items. If there are any, the Manage Exception button will be enabled in the Open/Close Period form.



4. Click on Manage Exceptions and you will get the following warning:



5. If you choose to sweep the transactions, you will get another warning stating that the changes cannot be undone.