We can register the Table using Application DBA Data Definitions (AD_DD)
Package from the Back End. You can also use the AD_DD API to delete the registrations
of tables and columns from Oracle Application Object Library tables. To alter a
registration you should first delete the registration, and then re register the table or
column. You should delete the column registration first, then the table registration,you should run the AD_DD procedures against the APPS schema. You must commit your changes for them to take effect.
Oraask Latest Articles
Query to get all Personalization applied to Forms in oracle ebs r12
Query to get all Personalization applied to Forms in oracle ebs r12
Simple Query to find form Personalization with Created By and Last Updated by whom:
API to Create Person Extra Information Types EIT
API to Create Person Extra Information Types EIT
Today we will explain by example how to create person extra information in ORACLE EBS HRMS by using standard API (hr_person_extra_info_api.create_person_extra_info), but first, ...
API to update EAM Asset Numbers
API to update EAM Asset Numbers
Understanding Date Tracking in Oracle HRMS – what does it mean? how it used in HRMS ?
Understanding Date Tracking in Oracle HRMS – what does it mean? how it used in HRMS ?
ORA-20001: FLEX-ID Does Not Exist Error when calling HR_Personal_Pay_Method_Api .Create_Personal_Pay_Method API
ORA-20001: FLEX-ID Does Not Exist Error when calling HR_Personal_Pay_Method_Api .Create_Personal_Pay_Method API
When Calling HR_Personal_Pay_Method_Api.Create_Personal_Pay_Method it errors with the following: ORA-20001: FLEX-ID Does Not Exist Cause : This is caused by ...
ORA-20001: System Error: Procedure PAY_ELEMENT_LINKS_T1 at Step &STEP Error in PAY_ELEMENT_LINK_API .update_element_link API
ORA-20001: System Error: Procedure PAY_ELEMENT_LINKS_T1 at Step &STEP Error in PAY_ELEMENT_LINK_API .update_element_link API
While running while running PAY_ELEMENT_LINK_API.update_element_link to update costing and balancing flexfield , then following error is encountered:
ORA-20001: System Error: Procedure PAY_ELEMENT_LINKS_T1 at Step &STEP
.
Cause: The procedure PAY_ELEMENT_LINKS_T1 has created an error at Step
&STEP.
.
Action: Contact your system administrator quoting the procedure
PAY_ELEMENT_LINKS_T1 and Step &STEP.
ORA-6512: at “APPS.HR_UTILITY”, line 934
ORA-6512: at “APPS.PAY_ELEMENT_LINKS_T1”, line 35
ORA-4088: error during execution of trigger ‘APPS.PAY_ELEMENT_LINKS_T1’
ORA-6512: at “APPS.PAY_ELEMENT_LINK_API”, line 1221
Cause :
ORA-01403: No Data Found Error in HR_PERSONAL_PAY_METHOD_API
ORA-01403: No Data Found Error in HR_PERSONAL_PAY_METHOD_API
When attempting to run the API – HR_PERSONAL_PAY_METHOD_API to create a personal payment methods, the following error occurs:
ORA-01403: No Data Found
Find that when using the API HR_Personal_payment_Methods_API.Update.US_Personal_Pay_Method, that the API fails with the following error:
ORA-01403: no data found
ORA-06512: at “APPS.HR_PERSONAL_PAY_METHOD_API”, line 2759
ORA-06512: at “APPS.HR_PERSONAL_PAY_METHOD_API”, line 3114
ORA-06512: at line 11Script Terminated on line 1.
Cause :
ORA-20001: FLEX-DSQL EXCEPTION Error in HR_PERSONAL_PAY_METHOD_API
ORA-20001: FLEX-DSQL EXCEPTION Error in HR_PERSONAL_PAY_METHOD_API
When attempting to run the API – HR_PERSONAL_PAY_METHOD_API to create a personal payment methods, the following error occurs:
ORA-20001: FLEX-DSQL EXCEPTION
This Error has been observed in :
- CREATE_GB_PERSONAL_PAY_METHOD
- CREATE_US_PERSONAL_PAY_METHOD
Cause :
Query to get invoices unmatched to purchase order
Query to get invoices unmatched to purchase order
Query to find invoices unmatched to purchase order select * from ap_invoices_all ...