Error in Workflow APINL/125-806353 ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.APINV_NO_WF_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "
Solution :- Go to v$Session and find your object and kill the session
HOW TO ADD MICROSOFT LOOP ADAPTER in Windows
1)Go to run and type ‘hdwwiz.exe’
2)
1)
/erptest/erpapp/fs1/EBSapps/appl/xdo/12.0.0/resource/xdodelivery.cfg
We can define XML Bursting Property in this file. Example SFTP Configuration.
1) Go to run and type "CMD" and click on OK
sftp ebs_es1@ftp.alam.corp.net
procedure xx_move_file_to_archive_dir(p_file_name in varchar2)
is
begin
debug_msg_prc(chr(10)||'-----Start xx_move_file_to_archive_dir: To Move same name file to archive if exists.',g_log);
debug_msg_prc( 'Source Path:'||g_directory_path_out||',Target Path:'||g_directory_path_archive ||',FileName:'||p_file_name,g_log);
UTL_FILE.FRENAME (g_directory_path_out,--source
p_file_name,
g_directory_path_archive,--target archive
p_file_name||'ar',--new archive file name
TRUE);
debug_msg_prc('FileName:'||p_file_name ||' move to archive directory',g_log);
exception when others then
debug_msg_prc('Error xx_move_file_to_archive_dir.Seems File not available to move. '||substr(SQLERRM,1,200),g_log);
end xx_move_file_to_archive_dir;
select
(select name from hr_operating_units where organization_id = hcas.org_id ) Operating_unit ,
hca.account_number customer_number,
hca.account_name customer_name,
hcsu.location site_number,
(select name from ar_collectors where collector_id = hcp.collector_id) account_level_collector ,
(select name from ar_collectors where collector_id = hcp_site.collector_id) site_level_collector ,
hl.country,
hl.address1,
hl.address2,
hl.city ,
hl.postal_code ,
hl.state ,
(select territory_short_name from FND_TERRITORIES_tl where territory_code = hl.country and language = 'US' ) country
--hcsu.site_use_code ,
-- , hca.cust_account_id , hcsu.site_use_id, hcp.status, hcp_site.status
from hz_cust_accounts_all hca,
hz_cust_acct_sites_all hcas,
hz_cust_site_uses_all hcsu,
hz_party_sites hps,
hz_locations hl,
hz_customer_profiles hcp,
hz_customer_profiles hcp_site
where hca.cust_account_id = hcas.cust_account_id
and hcas.cust_acct_site_id = hcsu.cust_acct_site_id
and hcas.party_site_id = hps.party_site_id
and hps.location_id = hl.location_id
and hca.cust_account_id = hcp.cust_account_id
and hcp.site_use_id is null
and hca.cust_account_id = hcp_site.cust_account_id
and hcsu.site_use_id = nvl(hcp_site.site_use_id,0)
and hca.status = 'A'
and hcas.status = 'A'
and hcsu.status = 'A'
and hcsu.site_use_code = 'BILL_TO'
and hcas.org_id in ('971')
--and hca.account_number = '33333333'
order by hca.account_number ,
hcsu.location
select PAYMENT_PROCESS_REQUEST_NAME,COUNT(PAYMENT_CURRENCY_CODE)
from (
select PAYMENT_PROCESS_REQUEST_NAME, PAYMENT_CURRENCY_CODE
from apps.iby_paymentS_all
--where PAYMENT_PROCESS_REQUEST_NAME='FAITRAD'
group by PAYMENT_PROCESS_REQUEST_NAME, PAYMENT_CURRENCY_CODE
) xx
group by PAYMENT_PROCESS_REQUEST_NAME--, PAYMENT_CURRENCY_CODE
having count(PAYMENT_PROCESS_REQUEST_NAME) > 1
order by 1
select PAYMENT_METHOD_CODE,PAYMENT_PROCESS_PROFILE, CURRENCY_CODE, BANK_NAME,Bank_Account_Num,
BANK_ACCOUNT_NAME,BANK_BRANCH_NAME,OU_NAME,PAYEE_COUNTRY
from (
Select aba.Bank_Account_Num Bank_Account_Num, aba.BANK_ACCOUNT_NAME Bank_account_name,aba.bank_account_id bank_account_id,
abb.BANK_BRANCH_NAME,
(select bank_name from ce_banks_v where PK_ID =aba.bank_id) bank_name,
(select name from hr_operating_units where organization_id = ac.org_id ) ou_name,
(select NLS_TERRITORY from fnd_territories where TERRITORY_CODE = ac.COUNTRY) payee_country,
ac.org_id,ac.PAYMENT_METHOD_CODE, ac.CURRENCY_CODE,ac.COUNTRY,
(select ispp.SYSTEM_PROFILE_NAME from iby_acct_pmt_profiles_b ibyac,IBY_SYS_PMT_PROFILES_VL ispp
where PAYMENT_PROFILE_ID =ac.PAYMENT_PROFILE_ID
and ibyac.SYSTEM_PROFILE_CODE=ispp.SYSTEM_PROFILE_CODE) payment_process_profile,ac.check_number
From AP_CHECKS_ALL ac,
CE_PAYMENT_DOCUMENTS acs,
CE_BANK_ACCOUNTS aba,
CE_BANK_BRANCHES_V abb
WHERE 1 = 1
--and ac.PAYMENT_METHOD_CODE = 'CHECK'
and ac.STATUS_LOOKUP_CODE = 'NEGOTIABLE'
AND ac.PAYMENT_DOCUMENT_ID = acs.PAYMENT_DOCUMENT_ID
AND acs.INTERNAL_BANK_ACCOUNT_ID = aba.bank_account_id
And abb.BRANCH_PARTY_ID = aba.Bank_Branch_Id
And upper(ac.Status_Lookup_Code) = upper('NEGOTIABLE')
and ac.BANK_ACCOUNT_NAME ='BOA USD ALL'
and trunc(ac.creation_Date) >= '31-AUG-2014'
) xx
group by PAYMENT_METHOD_CODE,PAYMENT_PROCESS_PROFILE, CURRENCY_CODE, BANK_NAME,Bank_Account_Num,
BANK_ACCOUNT_NAME,BANK_BRANCH_NAME,OU_NAME,PAYEE_COUNTRY
a) Employee Grade added along with Employee Name
b) NoteTOApprover Field:- Made Read-Only
1)
Controller
Class :- HeaderCO
Navigation:-
a) Click on Personalize link from the Page -> Select “Complete view” in Personalization Structure-> Click on Personalize “pencil” as shown below
a) Enter the Extended Controller Name at site level as shown below and click on Apply Button
Controller Class:-
Original Definition :- oracle.apps.ap.oie.webui.HeaderCO
Site level :- oracle.apps.ap.oie.webui.XXExtHeaderCO
GL
select name,currency_code,CHART_OF_ACCOUNTS_ID,
gl_flexfields_pkg.get_coa_name(CHART_OF_ACCOUNTS_ID) COA
from gl_ledgers where name in ('XXG18_500_USD');
gl_funds_available_pkg.calc_funds
('YTDE',
---X_AMOUNT_TYPE /*YTDE,QTDE , PTD, PJTD*/
i.ccid,
NULL,
-- 'A',--x_account_type,
NULL, --x_template_id,
l_ledger_id,
l_currency_code,
'Y', --x_po_install_flag,
l_accounted_period_type,
l_period_set_name,
l_period_name,
l_period_num,
l_quarter_num,
l_period_year,
l_closing_status,
l_budget_version_id,
l_encumbrance_type_id,
NULL,
--x_req_encumbrance_id,
NULL, --x_po_encumbrance_id,
x_budget,
x_encumbrance,
x_actual,
x_funds_available,
x_req_encumbrance_amount,
x_po_encumbrance_amount,
x_other_encumbrance_amount
);
