EBS

AP Payment status showing unprocessed in oracle apps

AP Payment status showing unprocessed in oracle apps   1>>> Check account status unprocessed ,it showing period exception reports   2>>> Check invoices status is accounted or not. 3>>> Check…

Read More

How to Assign a Concurrent Program to a Responsibility

Suppose you want to run a Program, lets take an example of  “Autoinvoice Import Program” from Order Management Super User. Navigate to this responsibility > View> Requests>Submit a new request>single…

Read More

Account details are not able to see from the customer search window.

The one of the customer record under the IE Operating unit is having some data corruption, the customer account details are not able to see from the customer search window.…

Read More

How to add Chart of account mapping code combinations In GL ?

Navigation :- GL Role >> Accounts >> Chart of Account mapping Choose Mapping name:- Ex IM CZ Local GAAP Mapping click on Account Rules field Click on New and enter…

Read More

Could not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing

Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Manager was found…

Read More

Oracle R12 Customer TaxPayer ID Update API

/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20), tax_reg_num VARCHAR2(50), status VARCHAR2(1), message VARCHAR2(1000)); / set serveroutput on;…

Read More

Oracle R12 Customer Remittance Email Update API

DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…

Read More

Oracle R12 Customer Site Remittance Email Update API

DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…

Read More

Oracle R12 AP Invoice Extract With PO And CHECK Details

select aia.INVOICE_NUM ,aia.INVOICE_AMOUNT ,aia.CREATION_DATE,aia.INVOICE_DATE,aia.SOURCE,aia.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE, (select aca.STATUS_LOOKUP_CODE from apps.ap_invoice_payments_all aipa, apps.ap_checks_all aca where aipa.check_id = aca.check_id and nvl(aipa.reversal_flag,’N’) <> ‘Y’ and aipa.invoice_id = aia.invoice_id and aipa.org_id = aia.org_id and rownum…

Read More

Oracle R12 Expense Type Master Based On Operating Unit

SELECT ( SELECT hou.name FROM apps.hr_operating_units hou WHERE hou.organization_id = aerpa.org_id ) operating_unit, aerpa.prompt expense_type, aerpa.flex_description gl_description, aerpa.flex_concactenated gl_code, aerpa.category_code, aerpa.end_date FROM apps.ap_expense_report_params_all aerpa WHERE aerpa.org_id IN ( 382, 402,…

Read More