E1: 48S/52: FAQ - Frequently Asked Question Regarding Workfile Transactions (F4812/F4812H) for Contract and Service Billing (Doc ID 636107.1)

Last updated on AUGUST 27, 2023

Applies to:

JD Edwards EnterpriseOne Contract and Service Billing - Version 8.0 and later
Information in this document applies to any platform.

Frequently Asked Question Regarding Workfile Transactions (F4812)

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Purpose

Question 1: Why do some Billing Workfile (P4812) transactions have the Transaction Classification (TCLS) field populated with a B?

Question 2: What creates a Billing Workfile (F4812) transaction with Transaction Classification (TCLS) of 8 (system-generated)?

Question 3: When invoice generation was run over payroll transactions in the F0911, the T3 transactions had associated accounts in the P0901 incorrectly marked with N on Billable (Y/N). Accounts have since been fixed but how can the T3 records be processed?

Question 4: A user has requested the PDBA value in the F4812 for Ledger Type entries JT in the F0911 be populated with either the R1 or R2 field from the F0911 and they referenced the R48120 as the source generating the entries to the F4812. I don't see the code in this UBE to update the F4812. Where do we look?

Question 5: Is there an issue for Service Billing if we have Journal Summarization Rules turned on in Payroll and so there are fewer lines in the GL than we have in payroll?

Question 6: T4 transactions from payroll are not showing up in the Workfile Revisions, P4812. Is there anything different about T4s or are they the same as journal entries once they are posted?

Question 7: Is it possible to create additional contract billing hold codes in UDC table 48/HL that function the same way as Hold Codes "A" and "1" which holds the transactions in the contract billing workfile F4812 for cost, invoice and revenue?

Question 8: What fields in Billing Workfile History (F4812H) indicate that a contract has been billed?

Question 9: The Time and Material line on contract has incorrect units in the Workfile Revisions (P4812). These are payroll transactions and the F0618 has 3.5 hours, however, in the workfile, the hours show as 2.66.
What could cause units and amounts to build into the workfile as amounts not equal to source?

Question 10: Is it possible to use the Item Price Group (PRGR) from inventory in the Contract Billing Markup table (P48096) ? A PO is entered with that stock item and issued to a work order.

Question 11: Please provide clarification as to why the Billing Basis Flag (BBF) is set to null during an invoice void EXCEPT for the following Transaction Classification (TCLS) values: 8,I,J,K,L,R?

Question 12: How can a record in the Workfile (P4812) be updated to non-billable so that it will not process on the Invoice Generation (R48121) (R52121)?

Question 13: There is a record in Workfile Revisions (P4812) that will not pull into a batch with Invoice Generation (R48121) for Service Billing. What should be checked and how can this be resolved?

Question 14: Is it possible to create a sales order from a service billing invoice?

Question 15: Verified setup for contract and cross reference is setup properly. Why would the contract number not get populated for accounts cross referenced with contract billing line?

Question 16: How are being populated the AID, AID5, AID6 fields under the F4812H table, and what is their significance?

Question 17: In case the revenue account information cannot be found under the F4812H table, under which specific table can be found the information related to it?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.