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 passing the the incorrect value ...
Post
Oraask Latest Articles
Post
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
1 mins read
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 :
Post
ORA-01403: No Data Found Error in HR_PERSONAL_PAY_METHOD_API
ORA-01403: No Data Found Error in HR_PERSONAL_PAY_METHOD_API
1 mins read
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 :
Post
ORA-20001: FLEX-DSQL EXCEPTION Error in HR_PERSONAL_PAY_METHOD_API
ORA-20001: FLEX-DSQL EXCEPTION Error in HR_PERSONAL_PAY_METHOD_API
1 mins read
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 :
Post
Query to get invoices unmatched to purchase order
Query to get invoices unmatched to purchase order
1 mins read
Query to find invoices unmatched to purchase order select * from ap_invoices_all ai where not exists ...
Post
Oracle XML Publisher – Complete guide
Oracle XML Publisher – Complete guide
1 mins read
Oracle XML Publisher – Complete guide this guide will help you to know the basics of xml publisher and how to use it to make new report layout ...
Post
Query to get all employees which has supervisors only
Query to get all employees which has supervisors only
1 mins read
Query To get all Employees which has Supervisors only select ppf.full_name emp_name, ppf1.full_name supervisor_name from per_all_people_f ppf, per_all_assignments_f paaf, per_all_people_f ppf1 where ppf.person_id = paaf.person_id and ...
Post
Oracle SQL Case Statment to find if a Value is String or Number using REGEXP_LIKE
Oracle SQL Case Statment to find if a Value is String or Number using REGEXP_LIKE
1 mins read
REGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE. This condition evaluates strings using characters ...
Post
where can use $FLEX$ and $PROFILES$ ? What the benefits from ? many examples
where can use $FLEX$ and $PROFILES$ ? What the benefits from ? many examples
5 mins read
What is $FLEX$ and $PROFILES$ ? Where are they used? many examples :
$FLEX$ and $PROFILES$ are Special Variables in oracle Apps environment and are used to hold values at runtime.
Every Oracle Apps technical consultant will be familiar with the term $FLEX$ and $PROFILES$. Whenever we are working with value sets, we will be using both of these for modifying the data fetched, for basing the values of a parameter on the other parameter and also fetching the Profile Option values
You may also interested in article How to Create Profile Option in Oracle APPS.
To segregate this based on the functionality
$FLEX$: Used for basing the value of a parameter on another parameter.
$PROFILES$: used for fetching the data stored in the specified profile option value which is currently active.
Post
Using FND_GLOBAL.APPS_INITIALIZE to initializing session in Oracle EBS
Using FND_GLOBAL.APPS_INITIALIZE to initializing session in Oracle EBS
1 mins read
FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API's in Oracle E-business Suite. and also may be required ...
