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.

GL_Interface containing duplicate records which has already been posted in GL transferred from Receivables (Query)

http://receivablesar.blogspot.com/2016/02/select-h.html

SELECT
H.NAME,
H.DEFAULT_EFFECTIVE_DATE,
H.DESCRIPTION,
H.JE_HEADER_ID,
A.JE_HEADER_ID,
H.JE_SOURCE,
H.JE_CATEGORY,
H.LEDGER_ID,
H.ACTUAL_FLAG,
H.PERIOD_NAME,
A.GL_SL_LINK_ID,
H.CODE_COMBINATION_ID,
H.ENTERED_DR,
H.ENTERED_CR
FROM
(
SELECT * FROM GL_INTERFACE
WHERE USER_JE_SOURCE_NAME='Receivables' AND USER_JE_CATEGORY_NAME='Sales Invoices' AND LEDGER_ID=2021 AND ACTUAL_FLAG='A' -- 783
) A,
(
SELECT
H.JE_SOURCE,
H.JE_CATEGORY,
H.LEDGER_ID,
H.ACTUAL_FLAG,
H.PERIOD_NAME,
gll.CODE_COMBINATION_ID,
gll.ENTERED_DR, gll.ENTERED_CR,
ael.gl_sl_link_id,
H.NAME,
H.DEFAULT_EFFECTIVE_DATE,
H.JE_HEADER_ID,
H.DESCRIPTION
FROM
GL_JE_HEADERS H,
GL_JE_LINES gll,
XLA_AE_HEADERS aeh,
XLA_AE_LINES ael,
XLA_EVENTS aea,
GL_IMPORT_REFERENCES gir

WHERE 1=1
AND H.JE_HEADER_ID=gll.JE_HEADER_ID
   AND ael.gl_sl_link_id = gir.gl_sl_link_id
   AND gir.gl_sl_link_table in ('APECL', 'XLAJEL','XLAJEL')
   AND aea.application_id = 222
   AND aea.event_id = aeh.event_id
   AND aeh.ae_header_id = ael.ae_header_id
   AND gll.je_header_id = gir.je_header_id
   AND gll.je_line_num = gir.je_line_num

AND H.JE_SOURCE='Receivables'
AND H.JE_CATEGORY='Sales Invoices'
AND H.LEDGER_ID=2021
AND H.ACTUAL_FLAG='A'
--AND H.DEFAULT_EFFECTIVE_DATE='20-JUL-2009'
--AND H.PERIOD_NAME='JUL-09'
--AND H.DESCRIPTION LIKE '%200900160%'
) H
WHERE 1=1
AND H.JE_SOURCE=A.USER_JE_SOURCE_NAME
AND H.JE_CATEGORY=A.USER_JE_CATEGORY_NAME
AND H.LEDGER_ID=A.LEDGER_ID
AND H.ACTUAL_FLAG=A.ACTUAL_FLAG
AND H.PERIOD_NAME=A.PERIOD_NAME
--AND H.CODE_COMBINATION_ID=A.CODE_COMBINATION_ID
--AND (H.ENTERED_DR=A.ENTERED_DR or H.ENTERED_CR=A.ENTERED_CR)
AND H.GL_SL_LINK_ID=A.GL_SL_LINK_ID