Post date: Dec 06, 2010 5:53:22 AM
Bug 9357264: R12:IBY INVALID OBJECTS AFTER APPLYING PATCH 9328093:R12.AP.A
Bug Attributes
Related Products
Hdr: 9357264 10.2.0.6 INVOICES 12.0.5 PRODID-501 PORTID-46
Abstract: R12:IBY INVALID OBJECTS AFTER APPLYING PATCH 9328093:R12.AP.A
*** 02/05/10 06:38 pm ***
BUG TYPE CHOSEN
===============
Code
Product: Oracle Payables (501)
==============================
PROBLEM STATEMENT
=================
### PROBLEM SUMMARY / ISSUE CLARIFICATION OR CUSTOMER QUESTION ###
For the Invoice Validation performance problem,
support suggested patch 9328093:R12.AP.A which caused invalid objects
and did not solve the performance problem.
*--- ADADMIN LOG FILE ( adadminOracle.log )
After running Compile APPS schema(s)", there are 32 invalid objects.
Only some of them belong to AP:
INVALID OBJECTS
------------------
inval_obj.lst
Object Name Object Type Status
------------------------------ ---------------- --------
..
..
IBY_BUILD_INSTRUCTIONS_PUB_PKG PACKAGE BODY INVALID
IBY_CHECKNUMBER_PUB PACKAGE INVALID
IBY_CHECKNUMBER_PUB PACKAGE BODY INVALID
IBY_DISBURSE_SINGLE_PMT_PKG PACKAGE BODY INVALID
IBY_DISBURSE_SUBMIT_PUB_PKG PACKAGE BODY INVALID
IBY_DISBURSE_UI_API_PUB_PKG PACKAGE BODY INVALID
IBY_PAYGROUP_PUB PACKAGE INVALID
IBY_PAYGROUP_PUB PACKAGE BODY INVALID
IBY_PAYINSTR_PUB PACKAGE BODY INVALID
IBY_SINGPAY_PUB PACKAGE INVALID
IBY_SINGPAY_PUB PACKAGE BODY INVALID
IBY_VALIDATIONSETS_PUB PACKAGE BODY INVALID
JAI_AP_IA_TRIGGER_PKG PACKAGE BODY INVALID
JAI_AP_IDA_TRIGGER_PKG PACKAGE BODY INVALID
There are 32 invalid objects in the APPS schema.
These are the ones that are realted to the issue.
COMPILATION ERRORS
------------------------
ToOracle.ls
Errors for PACKAGE BODY IBY_VALIDATIONSETS_PUB:
1104/10 PLS-306: wrong number or types of arguments in call to
'GET_INTERNAL_BANK_ACCTS'
Errors for PACKAGE BODY IBY_VALIDATIONSETS_PUB:
1104/10 PLS-306: wrong number or types of arguments in call to
'GET_INTERNAL_BANK_ACCTS'
Errors for PACKAGE BODY IBY_PAYINSTR_PUB:
835/56 PLS-302: component 'PAYMENT_METHOD_CODE' must be declared
837/168 PLS-302: component 'PAYMENT_METHOD_CODE' must be declared
860/56 PLS-302: component 'PMT_METHOD_FLAG' must be declared
Errors for PACKAGE BODY IBY_DISBURSE_SINGLE_PMT_PKG:
402/23 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
Errors for PACKAGE IBY_CHECKNUMBER_PUB:
223/2 PL/SQL: Declaration ignored
227/40 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
255/2 PL/SQL: Declaration ignored
Errors for PACKAGE BODY IBY_CHECKNUMBER_PUB:
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-304: cannot compile body of 'IBY_CHECKNUMBER_PUB' without
its specification
1/14 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_DISBURSE_UI_API_PUB_PKG:
9721/10 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE IBY_SINGPAY_PUB:
172/2 PL/SQL: Declaration ignored
178/41 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
Errors for PACKAGE BODY IBY_SINGPAY_PUB:
1/14 PLS-304: cannot compile body of 'IBY_SINGPAY_PUB' without its
specification
1/14 PLS-905: object APPS.IBY_SINGPAY_PUB is invalid
Errors for PACKAGE BODY IBY_DISBURSE_SUBMIT_PUB_PKG:
1229/14 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
2153/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_DISBURSE_SUBMIT_PUB_PKG:
1229/14 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
2153/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_BUILD_INSTRUCTIONS_PUB_PKG:
395/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_BUILD_INSTRUCTIONS_PUB_PKG:
395/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE IBY_PAYGROUP_PUB:
829/26 PLS-302: component 'PAYEE_ADDRESSEE' must be declared
Errors for PACKAGE BODY IBY_PAYGROUP_PUB:
1/14 PLS-304: cannot compile body of 'IBY_PAYGROUP_PUB' without its
specification
1/14 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- iby_payment_all.lst
the description of table iby_payments_all shows that this table
does not have the column payee_addressee
PACKAGE BODY IBY_VALIDATIONSETS_PUB( ibyvallb.pls-120.51.12000000.19 )
is calling CE_BANK_AND_ACCOUNT_UTIL.get_internal_bank_accts with 6
parameters
but in cebautlb.pls-120.6 ( CE_BANK_AND_ACCOUNT_UTIL ), procedure
get_internal_bank_accts
has 5 parameters only.
>> Higher versions of cebautlb.pls also have 5 parameters.
>> Higher versions of ibyvallb.pls keep calling cebautlb.pls with 6
parameters.
I had suggested the application of patch 8649286:R12.AP.A,
but customer refused because that is a huge patch.
PROBLEM STATEMENT
=================
### PROBLEM SUMMARY / ISSUE CLARIFICATION OR CUSTOMER QUESTION ###
For the Invoice Validation performance problem,
support suggested patch 9328093:R12.AP.A which caused invalid objects
and did not solve the performance problem.
*--- ADADMIN LOG FILE ( adadminOracle.log )
After running Compile APPS schema(s)", there are 32 invalid objects.
Only some of them belong to AP:
INVALID OBJECTS
------------------
inval_obj.lst
Object Name Object Type Status
------------------------------ ---------------- --------
..
..
IBY_BUILD_INSTRUCTIONS_PUB_PKG PACKAGE BODY INVALID
IBY_CHECKNUMBER_PUB PACKAGE INVALID
IBY_CHECKNUMBER_PUB PACKAGE BODY INVALID
IBY_DISBURSE_SINGLE_PMT_PKG PACKAGE BODY INVALID
IBY_DISBURSE_SUBMIT_PUB_PKG PACKAGE BODY INVALID
IBY_DISBURSE_UI_API_PUB_PKG PACKAGE BODY INVALID
IBY_PAYGROUP_PUB PACKAGE INVALID
IBY_PAYGROUP_PUB PACKAGE BODY INVALID
IBY_PAYINSTR_PUB PACKAGE BODY INVALID
IBY_SINGPAY_PUB PACKAGE INVALID
IBY_SINGPAY_PUB PACKAGE BODY INVALID
IBY_VALIDATIONSETS_PUB PACKAGE BODY INVALID
JAI_AP_IA_TRIGGER_PKG PACKAGE BODY INVALID
JAI_AP_IDA_TRIGGER_PKG PACKAGE BODY INVALID
There are 32 invalid objects in the APPS schema.
These are the ones that are realted to the issue.
COMPILATION ERRORS
------------------------
ToOracle.ls
Errors for PACKAGE BODY IBY_VALIDATIONSETS_PUB:
1104/10 PLS-306: wrong number or types of arguments in call to
'GET_INTERNAL_BANK_ACCTS'
Errors for PACKAGE BODY IBY_VALIDATIONSETS_PUB:
1104/10 PLS-306: wrong number or types of arguments in call to
'GET_INTERNAL_BANK_ACCTS'
Errors for PACKAGE BODY IBY_PAYINSTR_PUB:
835/56 PLS-302: component 'PAYMENT_METHOD_CODE' must be declared
837/168 PLS-302: component 'PAYMENT_METHOD_CODE' must be declared
860/56 PLS-302: component 'PMT_METHOD_FLAG' must be declared
Errors for PACKAGE BODY IBY_DISBURSE_SINGLE_PMT_PKG:
402/23 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
Errors for PACKAGE IBY_CHECKNUMBER_PUB:
223/2 PL/SQL: Declaration ignored
227/40 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
255/2 PL/SQL: Declaration ignored
Errors for PACKAGE BODY IBY_CHECKNUMBER_PUB:
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-304: cannot compile body of 'IBY_CHECKNUMBER_PUB' without
its specification
1/14 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_DISBURSE_UI_API_PUB_PKG:
9721/10 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE IBY_SINGPAY_PUB:
172/2 PL/SQL: Declaration ignored
178/41 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
Errors for PACKAGE BODY IBY_SINGPAY_PUB:
1/14 PLS-304: cannot compile body of 'IBY_SINGPAY_PUB' without its
specification
1/14 PLS-905: object APPS.IBY_SINGPAY_PUB is invalid
Errors for PACKAGE BODY IBY_DISBURSE_SUBMIT_PUB_PKG:
1229/14 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
2153/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_DISBURSE_SUBMIT_PUB_PKG:
1229/14 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
2153/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_BUILD_INSTRUCTIONS_PUB_PKG:
395/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE BODY IBY_BUILD_INSTRUCTIONS_PUB_PKG:
395/26 PLS-905: object APPS.IBY_CHECKNUMBER_PUB is invalid
Errors for PACKAGE IBY_PAYGROUP_PUB:
829/26 PLS-302: component 'PAYEE_ADDRESSEE' must be declared
Errors for PACKAGE BODY IBY_PAYGROUP_PUB:
1/14 PLS-304: cannot compile body of 'IBY_PAYGROUP_PUB' without its
specification
1/14 PLS-905: object APPS.IBY_PAYGROUP_PUB is invalid
*--- iby_payment_all.lst
the description of table iby_payments_all shows that this table
does not have the column payee_addressee
PACKAGE BODY IBY_VALIDATIONSETS_PUB( ibyvallb.pls-120.51.12000000.19 )
is calling CE_BANK_AND_ACCOUNT_UTIL.get_internal_bank_accts with 6
parameters
but in cebautlb.pls-120.6 ( CE_BANK_AND_ACCOUNT_UTIL ), procedure
get_internal_bank_accts
has 5 parameters only.
>> Higher versions of cebautlb.pls also have 5 parameters.
>> Higher versions of ibyvallb.pls keep calling cebautlb.pls with 6
parameters.
I had suggested the application of patch 8649286:R12.AP.A,
but customer refused because that is a huge patch.
WORKAROUNDS
===========
none
*** 02/05/10 06:49 pm ***
*** 02/05/10 06:52 pm ***
*** 02/05/10 06:53 pm *** (CHG: Sta->16 Pri->1)
*** 02/05/10 07:14 pm ***
*** 02/05/10 07:38 pm ***
*** 02/05/10 08:27 pm *** (CHG: Sta->11)
*** 02/05/10 08:27 pm ***
*** 02/05/10 08:30 pm ***
*** 02/05/10 10:54 pm ***
*** 02/05/10 10:57 pm ***
*** 02/05/10 11:03 pm *** (CHG: Comp->INVOICES)
*** 02/05/10 11:04 pm ***
*** 02/05/10 11:27 pm ***
*** 02/06/10 12:24 am *** (CHG: Sta->30)
*** 02/06/10 12:24 am ***
*** 02/06/10 05:56 am *** (CHG: Sta->11)
*** 02/06/10 05:56 am ***
*** 02/06/10 06:00 am ***
*** 02/06/10 06:07 am ***
*** 02/06/10 06:07 am *** (CHG: Sta->30)
*** 02/07/10 10:51 am *** (CHG: Sta->11)
*** 02/07/10 10:51 am ***
update from customer:
After applying the suggested patch, i fired the concurrent request for
invoice validation program. its more than 3 hours since I fired and its still
running.
I am not sure if this is within the acceptable time limits or not. I am
uploading the trc file and tkprof of the concurrent request for your
investigation. (the progam is still running)
moebs_ora_679_M24525.trc
moebs_ora_679_M24525.out
*** 02/07/10 10:55 am ***
*** 02/07/10 11:01 am *** (CHG: Asg->NEW OWNER OWNER)
*** 02/07/10 11:01 am ***
*** 02/07/10 01:02 pm *** (CHG: Sta->30)
*** 02/07/10 01:02 pm ***
*** 02/07/10 06:23 pm *** (CHG: Sta->11)
*** 02/07/10 06:23 pm ***
update from customer:
1) The concurrent program is running for almost the past 11 hours and it is
not completed yet.
2) Please find the tkprof file
*** 02/07/10 06:25 pm ***
*** 02/07/10 07:13 pm ***
*** 02/07/10 11:42 pm *** (CHG: Sta->32 Asg->NEW OWNER OWNER)
*** 02/07/10 11:42 pm ***
*** 02/08/10 06:07 am *** (CHG: Test Name-> NULL -> PGT)
*** 02/08/10 06:07 am *** (CHG: Tag Added)
Article Rating
Comments
Provide feedback for this article. Please use 'Contact Us' for other feedback.
Important Note: this feedback is anonymously visible to other customers until processed by Oracle Support.