Oracle E-Business Suite
Oracle E-Business Suite
Share
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.
PO Approval Error: Line # 1 Schedule # 1 Distribution # 1 The Accounting date is not in an open encumbrance period
Error Cause: The PO distributions have a GL Date of a Closed period. Therefore, the error message "The Accounting date is not in an open encumbrance period" is correct. Solution: In order to approve the PO, do one of the following: a) Re-open the SEP-15 period, or b) Change the GL Date on the distriRead more
Error Cause:
The PO distributions have a GL Date of a Closed period. Therefore, the error message “The Accounting date is not in an open encumbrance period” is correct.
Solution:
In order to approve the PO, do one of the following:
a) Re-open the SEP-15 period, or
b) Change the GL Date on the distributions to a new date that is within an ‘Open’ period.
The PO cannot be approved/reserved if the dates on the distribution do not fall within an open period.
As reference from Doc ID 2076668.1
See lessIs it recommended to increase the length of a DFF attribute in standard table
It's not as simple as changing the ATTRIBUTE column size because there are a lot of dependencies that you need to pay attention to e.g. Changes to other tables that may be related to your table, like (interface tables). Check the form that is used in this ATTRIBUTE. Check code that may require a chaRead more
It’s not as simple as changing the ATTRIBUTE column size because there are a lot of dependencies that you need to pay attention to e.g.
That’s why it is not simple; moreover, DFF ATTRIBUTES default length of “150” characters is a coding standard used for most standard tables.
See lessTablespace size
Find below the query to find the free space of a tablespace: SELECT DFQ.TABLESPACE_NAME "Tablespace Name" ,DFQ.TOTALSPACE "Total Size MB" , (DFQ.TOTALSPACE - DSQ.TOTALUSEDSPACE) "Free Space MB" ,ROUND (100 * ( (DFQ.TOTALSPACE - DSQ.TOTALUSEDSPACE) / DFQ.TOTALSPACE)) || '%' "Free Space %" FROM (SELECRead more
Find below the query to find the free space of a tablespace:
Also, you can refer to this article to find a handful of detail about the tablespace:
Check Tablespace Usage in Oracle
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 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 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 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 lessQuery to get supplier bank details in Oracle APPS R12
Hi @Marito, Find below the query to get supplier bank details: SELECT ASP.SEGMENT1 VENDOR_NUM ,ASP.VENDOR_NAME ,ASA.VENDOR_SITE_CODE ,HOU.NAME OU_NAME ,IEBA.COUNTRY_CODE ,CBBV.BANK_NAME ,IEBA.BANK_ACCOUNT_NAME_ALT ,CBBV.BANK_NUMBER ,CBBV.BANK_BRANCH_NAME ,CBBV.BRANCH_NUMBER ,CBBV.EFT_SWIFT_CODE ,IEBRead more
Hi Marito,
Find below the query to get supplier bank details:
Above query will list all suppliers bank details:
Supplier Number, Name, Supplier Site Code, Operating unit that belong to supplier site, Country, Bank name, Bank alternative Name (like Arabic Name of the bank), Bank Number, Branch number and name, the swift code, the account number, IBAN, and currency code.
And the list is open to add any other column/s you prefer.
See less