AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE and AP_CHECKS_ALL.PAYMENT_METHOD_CODE in Oracle APPS

Below is from Oracle Metalink ID 1919051.1

PAYMENT_METHOD_LOOKUP_CODE is obsolete in R12 hence it should not be referred in R12. If you want to refer payment method code from Invoice header then PAYMENT_METHOD_CODE should be used. During upgrade to R12 we populate PAYMENT_METNHOD_CODE with PAYMENT_METHOD_LOOKUP_CODE for migrated invoices.

SELECT payment_method_code, payment_method_name, description

  FROM iby_payment_methods_tl

 WHERE payment_method_code IN

          (SELECT DISTINCT PAYMENT_METHOD_CODE

              FROM AP_CHECKS_ALL

              )

AND language = USERENV('LANG')

Unapplied and Unresolved Receipts Register report completing with Error

 "Unapplied and Unresolved Receipts" report is the replacement for "Unapplied Receipt Register". When tried to run "Unapplied and Unresolved Receipts" report for the first time, its completed with below error.

Its not a BIDI char set

Its not a BIDI language

Error executing cursor. ORA-06502: PL/SQL: numeric or value error: NULL index table key value 

ORA-06512: at "APPS.FA_RX_PUBLISH", line 2205 

ORA-06512: at line 1

Unable to execute cursor

To resolve this issue Oracle Provided data fix as mentioned in Note "Unapplied and Unresolved Receipts Register Cannot Be Submitted (Doc ID 866105.1)"

Please make sure that you will do testing in test instance.

As per Oracle the error occurs because the concurrent_program_id is null for the reports having report_ids 492 and 493.

1. Please run the following sql

select report_id, application_id, concurrent_program_id,
last_update_date,concurrent_program_name
from fa_rx_reports
where report_id in (492,493);

2. If the query results concurrent_program_id as NULL then please run the following update statement:

Update fa_rx_reports farr
set concurrent_program_id =
(Select concurrent_program_id
From fnd_concurrent_programs
Where application_id = farr.application_id
And concurrent_program_name = farr.concurrent_program_name);

3. Then run the report.

"Unapplied Receipt Register" report completing with Error in Oracle Apps R12

While running "Unapplied Receipts Register" completing with below error in Oracle APPS R12.

REP-0004: Warning: Unable to open user preference file.

MSG-00100: BeforeReport_Procs.Set_Sort_Order

MSG-00200: Total forAGENCY: 

REP-1401: 'report_subtitleformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.AR_MO_GLOBAL_CACHE", line 55

ORA-06512: at "APPS.ARP_STANDARD", line 3021

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error: m

REP-1401: MSG-00100: BeforeReport_Procs.Set_Sort_Order

MSG-00200: Total forAGENCY: 

REP-1401: 'report_subtitleformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.AR_MO_GLOBAL_CACHE", line 55

ORA-06512: at "APPS.ARP_STANDARD", line 3021

Solution: As mentionbed in Oracle Note Document ID 418261.1 "Unapplied Receipt Register" is Obsoleted in R12. 

Below are the comments from Oracle Note.

"In Release 12, the Unapplied Receipt Register has been made Obsoleted. 

The Unapplied and Unresolved Receipts Register is a new RXI report which gives you the ability to change the columns on the report as needed with the Report eXchange Designer responsibility."

GL Table Changes R12 in Oracle APPS

SL_NO	11i TABLES	R12 TABLES
1	GL_ACCOUNT_HIERARCHIES	GL_ACCOUNT_HIERARCHIES
2	GL_AHE_DETAIL_RANGES_GT	GL_AHE_DETAIL_RANGES_GT
3	GL_ALLOC_BATCHES	GL_ALLOC_BATCHES
4	GL_ALLOC_FORMULA_LINES	GL_ALLOC_FORMULA_LINES
5	GL_ALLOC_FORMULAS	GL_ALLOC_FORMULAS
6	GL_ALLOC_HISTORY	GL_ALLOC_HISTORY
7	GL_ALLOC_SEGVALS_INT
8	GL_APPLICATION_GROUPS
9	GL_ARCHIVE_HISTORY	GL_ARCHIVE_HISTORY
10	GL_AUTHORIZATION_LIMITS	GL_AUTHORIZATION_LIMITS
11	GL_AUTO_ALLOC_BAT_HIST_DET	GL_AUTO_ALLOC_BAT_HIST_DET
12	GL_AUTO_ALLOC_BATCH_HISTORY	GL_AUTO_ALLOC_BATCH_HISTORY
13	GL_AUTO_ALLOC_BATCHES	GL_AUTO_ALLOC_BATCHES
14	GL_AUTO_ALLOC_REV_BATCHES	GL_AUTO_ALLOC_REV_BATCHES
15	GL_AUTO_ALLOC_SET_HISTORY	GL_AUTO_ALLOC_SET_HISTORY
16	GL_AUTO_ALLOC_SETS	GL_AUTO_ALLOC_SETS
17	GL_AUTOMATIC_POSTING_OPTIONS	GL_AUTOMATIC_POSTING_OPTIONS
18	GL_AUTOMATIC_POSTING_SETS	GL_AUTOMATIC_POSTING_SETS
19	GL_AUTOREVERSE_OPTIONS	GL_AUTOREVERSE_OPTIONS
20	GL_BALANCES	GL_BALANCES
21	GL_BALANCES_DELTA	GL_BALANCES_DELTA
22	GL_BALANCES_DELTA_INTERIM	GL_BALANCES_DELTA_INTERIM
23	GL_BC_DUAL	GL_BC_DUAL
24	GL_BC_DUAL2	GL_BC_DUAL2
25	GL_BC_EVENT_TIMESTAMPS	GL_BC_EVENT_TIMESTAMPS
26	GL_BC_OPTION_DETAILS	GL_BC_OPTION_DETAILS
27	GL_BC_OPTIONS	GL_BC_OPTIONS
28	GL_BC_PACKET_ARRIVAL_ORDER	GL_BC_PACKET_ARRIVAL_ORDER
29	GL_BC_PACKETS	GL_BC_PACKETS
30	GL_BC_PERIOD_MAP	GL_BC_PERIOD_MAP
31	GL_BIS_SEGVAL_INT	GL_BIS_SEGVAL_INT
32	GL_BUDGET_ASSIGNMENT_RANGES	GL_BUDGET_ASSIGNMENT_RANGES
33	GL_BUDGET_ASSIGNMENTS	GL_BUDGET_ASSIGNMENTS
34	GL_BUDGET_BATCHES	GL_BUDGET_BATCHES
35	GL_BUDGET_ENTITIES	GL_BUDGET_ENTITIES
36	GL_BUDGET_FROZEN_RANGES	GL_BUDGET_FROZEN_RANGES
37	GL_BUDGET_INTERFACE	GL_BUDGET_INTERFACE
38	GL_BUDGET_INTERIM	GL_BUDGET_INTERIM
39	GL_BUDGET_PERIOD_RANGES	GL_BUDGET_PERIOD_RANGES
40	GL_BUDGET_RANGE_INTERIM	GL_BUDGET_RANGE_INTERIM
41	GL_BUDGET_TYPES	GL_BUDGET_TYPES
42	GL_BUDGET_VERSIONS	GL_BUDGET_VERSIONS
43	GL_BUDGETS	GL_BUDGETS
44	GL_CARRYFORWARD_RANGES	GL_CARRYFORWARD_RANGES
45	GL_CODE_COMBINATIONS	GL_CODE_COMBINATIONS
46	GL_CONCURRENCY_CONTROL	GL_CONCURRENCY_CONTROL
47	GL_CONCURRENT_SCHEDULES	GL_CONCURRENT_SCHEDULES
48	GL_CONS_BATCHES	GL_CONS_BATCHES
49	GL_CONS_FLEX_HIERARCHIES	GL_CONS_FLEX_HIERARCHIES
50	GL_CONS_FLEXFIELD_MAP	GL_CONS_FLEXFIELD_MAP