Retainage refers to a portion of the payment that is withheld until the completion of a project. In that case the client doesn’t pay the contractor/party the retainage until all work on the project is complete. Retainage is negotiated upfront and is stated as a percentage or amount of the overall cost of the project. […]
Part -I: Online Accounting: (For single entity)DRAFT will create Journal Entries, which are NOT final, which means they are NOT ready to be transferred to GL. You can see the accounting in XLA_AE_HEADERS and XLA_AE_LINES. XLA_AE_HEADERS.accounting_entry_status_code is ‘D’ XLA_EVENTS.process_status_code is ‘D’ XLA_EVENTS.event_status_code is ‘U’ You can […]
Often times, WebADI can be very confusing to work with. There are just too many issues if it is not properly set up. Sometimes you may encounter VBProject Runtime Error when trying to open Web-ADI template file, or sometimes the Excel spreadsheet just hangs up, or can’t be opened.There are few steps you will have to take […]
Oracle Apps tables ending with _ALL holds transaction data for multiple org ( Operating Units). In 11i we had views on these tables. It requires setting context in order to fetch data from these views. This is for security concerns as these objects holds transaction details. The SQL command to set the ORG_ID prior to […]
This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers. UTL_INADDRSYS_CONTEXTV$INSTANCEV$SESSION UTL_INADDR The UTL_INADDR provide a means of retrieving host names and IP addresses of remote hosts from PL/SQL. The GET_HOST_ADDRESS function returns the IP address of the specified host name. SQL> SELECT UTL_INADDR.get_host_address(‘TEST’) FROM […]
Recent Comments