The Concurrent Programs "Payables Transfer To General Ledger" And "Payables Transfer to GL" Fail In R12

(Doc ID 1179363.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Jul-2013***

Goal

Q1 - On R12 application, when attempting to run the "Payables Transfer to General Ledger" program the following error occurs:

Error
APP-FND-01564: ORACLE error 904 in FDFGDF

Cause: FDFGDF failed due to ORA-00904: "AP_GL_TRANSFER_PKG"."AP_MC_CHECK": invalid identifier.

The SQL statement being executed at the time of the error was: SELECT L.MEANING FROM FND_LOOKUPS L,AP_SYSTEM_PARAMETERS ASP WHERE L.LOOKUP_TYPE = 'YES_NO' AND (( L.LOOKUP_CODE = 'N' AND 'N' = (SELECT ASP.INCLUDE_REPORTING_SOB FROM AP_SYSTEM_PARAMETERS ASP)) OR ( L.LOOKUP_CODE = 'Y' AND 'Y' = (SELECT ASP.INCLUDE_REPORTING_SOB FROM AP_SYSTEM_PARAMETERS ASP ) AND AP_GL_TRANSFER_PKG.AP_MC_CHECK(:a1) <> 'R') OR ( L.LOOKUP_CODE = 'N' AND AP_GL_TRANSFER_PKG.AP_MC_CHECK(:a2) = 'R')) and was executed from the file &ERRFILE.

Q2 - On R12 application, when attempting to run the "Payables Transfer to GL" program, the following error occurs :

Error
APP-FND-00784: Invalid reference AP_SRS_ACCT_METHOD! in default value defined for segment Discount Taken
Please check the default values you have specified for your segments.

and

APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms