Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
Create Item not showing up in Personalize Table
There are two columns already that may fits your need. START_DATE_ACTIVE Date when the classification becomes active for the supplier END_DATE_ACTIVE Date when the classification becomes inactive for the supplier However, if you need to capture more additional informations in any standard tables, OrRead more
There are two columns already that may fits your need.
START_DATE_ACTIVE
Date when the classification becomes active for the supplier
END_DATE_ACTIVE
Date when the classification becomes inactive for the supplier
However, if you need to capture more additional informations in any standard tables, Oracle recommended to capture those additional information through out a DFF attributes. In this table you have 5 addition attributes to use them. Therefore, Oracle not recommended to add any additional physical columns on any standard table.
See lessPayables Import Invoices
Unfortunately, you can't achieve this kind of requirement without create a distribution set as per Oracle note Doc ID 1954890.1 Also currently there is no an API or interface table available to create a new distribution set from the backend. The only way is to create a temporary distribution set andRead more
Unfortunately, you can’t achieve this kind of requirement without create a distribution set as per Oracle note Doc ID 1954890.1
Also currently there is no an API or interface table available to create a new distribution set from the backend. The only way is to create a temporary distribution set and delete it’s account distributions once you have done from your task.
If you go with creating distribution set you have to pass either distribution_set_id or distribution_set_name while populating “ap_invoice_lines_interface” interface table.
See lessHow to Use pi in Python
import mathprint('The value of pi is: ', math.pi) Output : The value of pi is: 3.141592653589793
Output :
See lessWhat is fndload command for responsibility in oracle apps R12?
FNDLOAD to download responsibility from the source instance: FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt FND_RESPONSIBILITY RESP_KEY=”<RESPONSIBILITY_KEY>” FNDLOAD to upload responsibility to destination instance: FNDLOAD apps/<PWDRead more
FNDLOAD to download responsibility from the source instance:
FNDLOAD to upload responsibility to destination instance:
Notes:
Note: Don’t forget to move the LDT file after downloaded it from source instance to destination instance.
See lessFailedAuthentication Fault Reason : FailedAuthentication : The security token cannot be authenticated
Clarification: This message refer to failed authentication that's because of the credentials for one or more connections being used by your integration. Resolution: get the list of connections being used by your integration then go to them and make sure of the username and password that they are corRead more
Clarification: This message refer to failed authentication that’s because of the credentials for one or more connections being used by your integration.
Resolution: get the list of connections being used by your integration then go to them and make sure of the username and password that they are correct by doing validate and test.
See lessSQL query to find all customised dff in oracle 12g
What do you mean by Customized DFF? If you want to list all custom context that is created on a specific DFF you can run this query to get the result: SELECT FAPT.APPLICATION_NAME, FDFC.DESCRIPTIVE_FLEXFIELD_NAME, FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE, FDFC.ENABLED_FLAG, FDFC.GLOBAL_FLAG, FDFC.DESCRIPTRead more
What do you mean by Customized DFF?
If you want to list all custom context that is created on a specific DFF you can run this query to get the result:
P_APPLICATION_NAME : Is your application name
P_DFF_NAME : Is your Descriptive flexfield name. It’s not the title which is available on DFF screen, but you can find the column name “DESCRIPTIVE_FLEXFIELD_NAME” from help -> diagnostic -> examine.
Note: We have excluded three users because Oracle seeded DFF contexts are created by these users above, thus, we can get only the custom ones.
See lessOracle SQL Query to Find User Permissions
To check current user permission in oracle execute the following queries: First Query: SELECT * FROM USER_SYS_PRIVS WHERE USERNAME = USER; The result of this query would be: USERNAME PRIVILEGE ADMIN_OPTION HR CREATE VIEW NO HR UNLIMITED TABLESPACE NO HR CREATE DATABASE LINK NO HR CREATE SEQUENCE NORead more
To check current user permission in oracle execute the following queries:
First Query:
The result of this query would be:
Second Query:
Third Query:
hope this help.
See lessMaximum Number Of AP Invoice Lines Allowed In Ap_Invoice_Lines_All
There is no limit for the numbers of lines you can create per invoice, however, the only thing we have to consider is the performance of querying this transaction.
There is no limit for the numbers of lines you can create per invoice, however, the only thing we have to consider is the performance of querying this transaction.
See lessError: wsse:InvalidSecurity When Testing CreateEmployee SOAP Web Service in Oracle Applications R 12.2.10 from SOAP UI
This error message due to security token is missing in the SOAP Header section. To solve this issue you have to enter the security token as follows: 1- Open SOAP project 2- put the following security token right after SOAP Header section of the request body <soapenv:Header> <wsse:Security xRead more
This error message due to security token is missing in the SOAP Header section. To solve this issue you have to enter the security token as follows:
1- Open SOAP project
2- put the following security token right after SOAP Header section of the request body
Note: You have to change both (YourUserName & YourPassword) to the appropriate username and password that is authenticated to call the webservice.
3- Save the project and call the service again.
Another easy way to do this is :
1- Open SOAP Project
2- Right click on the request body in any black space and choose “Add WSS Username Token“
3- Choose Password Text from the drop down list of Add WSS Username Token Field, then click OK.
4- this option will take the username and password automatically from Auth which you set earlier.
5- Save the project and test the issue again, it should be resolved.
Note: If you go for the second solution you should enter authentication first.
See lessError : the stage registered as the first stage is invalid
You have to make sure of the start stage of the request set. you might not select the starting stage of the request set or the request you selected in the starting stage has a problem check it individually first to make sure it's working fine without any issue.
You have to make sure of the start stage of the request set. you might not select the starting stage of the request set or the request you selected in the starting stage has a problem check it individually first to make sure it’s working fine without any issue.
See less